LastModified - property in ROOT\Microsoft\SqlServer\ComputerManagement12 namespace

LastModified in other namespaces

List of classes with LastModified local property in ROOT\Microsoft\SqlServer\ComputerManagement12 namespace

propertyClassOrigin
LastModifiedSqlErrorLogFileSqlErrorLogFile

Code samples for LastModified property

Get instance of WMI class using GetObject, LastModified property of SqlErrorLogFile

Short 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
See more VBS samples of SqlErrorLogFile class

WMI query - sample windows WQL with C#, LastModified property of SqlErrorLogFile

Get 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.
See in another language: VBScript, VB.Net.
//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 SqlErrorLogFile

Get 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.
See in another language: VBScript, C#
'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
comments powered by Disqus
WUtils.com