Includes&Samples |
Name - property in ROOT\Microsoft\SqlServer\ComputerManagement12 namespaceName in other namespacesList of classes with Name local property in ROOT\Microsoft\SqlServer\ComputerManagement12 namespace
List of classes with Name derived property in ROOT\Microsoft\SqlServer\ComputerManagement12 namespace
Code samples for Name propertyGet instance of WMI class using GetObject, Name property of SqlErrorLogFileShort VBS code - get a single specified instance of SqlErrorLogFile 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:" + _ "SqlErrorLogFile.InstanceName=""MSSQLServer"",Name=""ERRORLOG""") Wscript.Echo wmiObject.Name 'or other property name, see properties WMI query - sample windows WQL with C#, Name property of SqlErrorLogFileGet a specified instance of SqlErrorLogFile 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 SqlErrorLogFile Where InstanceName=\"MSSQLServer\"Name=\"ERRORLOG\""); //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("Name : {0}", m["Name"]); } WMI query - sample windows WQL with VB.Net, Name property of SqlErrorLogFileGet a specified instance of SqlErrorLogFile 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 SqlErrorLogFile Where InstanceName="MSSQLServer"Name="ERRORLOG"") '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("Name : {0}", mObject("Name")) Next |