Includes&Samples |
SqlErrorLogFile, ROOT\Microsoft\SqlServer\ComputerManagement12, c# samplesClass | Methods | Properties (5) | Qualifiers (2) | Instances (7) | Namespaces (1)Samples: VB Script | C# | VB.Net | Search on:Microsoft SqlErrorLogFile - c# code samplesWMI query - sample windows WQL with C#, ArchiveNumber 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("ArchiveNumber : {0}", m["ArchiveNumber"]); } WMI query - list of class instancesList of all instances of SqlErrorLogFile class in C#.
//https://wutils.com/wmi/ //Project -> Add reference -> System.Management //using System.Management; //set the class name and namespace string NamespacePath = "\\\\.\\ROOT\\Microsoft\\SqlServer\\ComputerManagement12"; string ClassName = "SqlErrorLogFile"; //Create ManagementClass ManagementClass oClass = new ManagementClass(NamespacePath + ":" + ClassName); //Get all instances of the class and enumerate them foreach (ManagementObject oObject in oClass.GetInstances()) { //access a property of the Management object Console.WriteLine("ArchiveNumber : {0}", oObject["ArchiveNumber"]); } |