Includes&Samples |
LastModified - property in ROOT\Microsoft\SqlServer\ComputerManagement12 namespaceLastModified in other namespacesList of classes with LastModified local property in ROOT\Microsoft\SqlServer\ComputerManagement12 namespace
Code samples for LastModified propertyGet instance of WMI class using GetObject, LastModified 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.LastModified 'or other property name, see properties WMI query - sample windows WQL with C#, LastModified 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("LastModified : {0}", m["LastModified"]); } WMI query - sample windows WQL with VB.Net, LastModified 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("LastModified : {0}", mObject("LastModified")) Next |