Includes&Samples |
InstanceName - property in ROOT\Microsoft\SqlServer\ComputerManagement12 namespaceInstanceName in other namespacesList of classes with InstanceName local property in ROOT\Microsoft\SqlServer\ComputerManagement12 namespace
Code samples for InstanceName propertyGet instance of WMI class using GetObject, InstanceName property of SqlErrorLogEventShort 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.InstanceName 'or other property name, see properties WMI query - sample windows WQL with C#, InstanceName property of SqlErrorLogEventGet 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 c# sample code.
//https://wutils.com/wmi/ //Project -> Add reference -> System.Management //using System.Management; //create a management scope object ManagementScope scope = new ManagementScope("\\\\.\\ROOT\\Microsoft\\SqlServer\\ComputerManagement12"); //create object query ObjectQuery query = new ObjectQuery("SELECT * FROM SqlErrorLogEvent Where InstanceName=\"MSSQLServer\"LogDate=\"20141112061047.200000-480\""); //create object searcher ManagementObjectSearcher searcher = new ManagementObjectSearcher(scope, query); //get a collection of WMI objects ManagementObjectCollection queryCollection = searcher.Get(); //enumerate the collection. foreach (ManagementObject m in queryCollection) { // access properties of the WMI object Console.WriteLine("InstanceName : {0}", m["InstanceName"]); } WMI query - sample windows WQL with VB.Net, InstanceName property of SqlErrorLogEventGet 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.Net sample code.
'Project -> Add reference -> System.Management 'Imports System.Management 'Get the namespace management scope Dim Scope As New ManagementScope("\\.\ROOT\Microsoft\SqlServer\ComputerManagement12") 'Get a result of WML query Dim Query As New ObjectQuery("SELECT * FROM SqlErrorLogEvent Where InstanceName="MSSQLServer"LogDate="20141112061047.200000-480"") 'Create object searcher Dim Searcher As New ManagementObjectSearcher(Scope, Query) 'Get a collection of WMI objects Dim queryCollection As ManagementObjectCollection = Searcher.Get 'Enumerate wmi object For Each mObject As ManagementObject In queryCollection 'write out some property value Console.WriteLine("InstanceName : {0}", mObject("InstanceName")) Next |