SqlErrorLogEvent, ROOT\Microsoft\SqlServer\ComputerManagement12, VBScript samples

SqlErrorLogEvent - VB Script code samples

Get instance of WMI class using GetObject, FileName property of SqlErrorLogEvent

Short VBS code - get a single specified instance of SqlErrorLogEvent class or get a default unnamed instance (singleton) of the class, using one single command GetObject with exact path of the wmi object.

…

	
	'https://wutils.com/wmi/
	Dim wmiObject
	Set wmiObject = GetObject( _
	 "WINMGMTS:\\.\ROOT\Microsoft\SqlServer\ComputerManagement12:" + _
	 "SqlErrorLogEvent.InstanceName=""MSSQLServer"",LogDate=""20141112061047.200000-480""")
	Wscript.Echo wmiObject.FileName 'or other property name, see properties

Alternative codes

SWbemServices.Get

Quickest and most efficient VB Script code to get a single instance by a key - SWbemServices.Get

…

	'https://wutils.com/wmi/
	Dim oWMI, Instance
	
	'Get base WMI object, "." means computer name (local)
	Set oWMI = GetObject("WINMGMTS:\\.\ROOT\Microsoft\SqlServer\ComputerManagement12")
	
	Do
	  'Get the instance of SqlErrorLogEvent 
	  Set Instance = oWMI.Get("SqlErrorLogEvent.InstanceName=""MSSQLServer"",LogDate=""20141112061047.200000-480""")
	                    
	  'Do something with the instance
	  Wscript.Echo Instance.FileName 'or other property name, see properties
	
	  'Wait for some time to get next value
	  Wscript.Sleep 1000
	Loop While True

WMI query - sample windows WQL

Get a specified instance of SqlErrorLogEvent by a key, get a default unnamed instance (singleton) of the class or list instances of the class by wmi query using this VB Script.

See in another language: C#, VB.Net.

…

	'https://wutils.com/wmi/
	Dim oWMI, WQL, Instances, Instance
	
	'Get base WMI object, "." means computer name (local)
	Set oWMI = GetObject("WINMGMTS:\\.\ROOT\Microsoft\SqlServer\ComputerManagement12")
	
	'Create a WMI query text 
	WQL = "Select * from SqlErrorLogEvent Where InstanceName=""MSSQLServer""LogDate=""20141112061047.200000-480"""
	
	'Get instances of SqlErrorLogEvent 
	Set Instances = oWMI.ExecQuery(WQL)
	                    
	'Enumerate instances  
	For Each Instance In Instances 
	  'Do something with the instance
	  Wscript.Echo Instance.FileName 'or other property name
	Next 'Instance

InstancesOf

List of all instances, wmi class SqlErrorLogEvent.

…

	'https://wutils.com/wmi/
	Dim oWMI, Instances, Instance
	
	'Get base WMI object, "." means computer name (local)
	Set oWMI = GetObject("WINMGMTS:\\.\ROOT\Microsoft\SqlServer\ComputerManagement12")
	
	'Get instances of SqlErrorLogEvent - all instances of this class and derived classes 
	'Set Instances = oWMI.InstancesOf("SqlErrorLogEvent")
	
	'Get instances of SqlErrorLogEvent 
	Set Instances = oWMI.InstancesOf("SqlErrorLogEvent", 1)
	
	
	'Enumerate instances  
	For Each Instance In Instances 
	  'Do something with the instance
	  Wscript.Echo Instance.FileName 'or other property name
	Next 'Instance

WMI remote scripting - Locator, Connect

Get WMI management object using SWbemLocator.ConnectServer method. You can connect to a remote computer and specify Username/Password for the WMI connection.

…

	'https://wutils.com/wmi/
	Dim Locator, oWMI, WQL, Instances, Instance
	
	'Create Locator object
	Set Locator = CreateObject("WbemScripting.SWbemLocator")
	
	'Get base WMI object
	Set oWMI = Locator.ConnectServer("MachineName", "ROOT\Microsoft\SqlServer\ComputerManagement12", "MachineName\administrator", "Password")
	 
	'.... continue using oWMI object

WUtils.com

Includes&Samples