Includes&Samples |
MISSING_COLUMN_STATISTICS, ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER, c# samplesClass | Methods | Properties (25) | Qualifiers (1) | Instances | Namespaces (2)Samples: VB Script | C# | VB.Net | Search on:Microsoft c# Code samplesThe class MISSING_COLUMN_STATISTICS is abstract and serves only as a base for new classes. WMI query - sample windows WQL with C#, ApplicationName property of MISSING_COLUMN_STATISTICSShort C# sample code to get the abstract class MISSING_COLUMN_STATISTICS and its properties.
//https://wutils.com/wmi/ //Project -> Add reference -> System.Management //using System.Management; //set the class name and namespace string NamespacePath = "\\\\.\\ROOT\\Microsoft\\SqlServer\\ServerEvents\\MSSQLSERVER"; string ClassName = "MISSING_COLUMN_STATISTICS"; //Create ManagementClass ManagementClass mClass = new ManagementClass(NamespacePath + ":" + ClassName); // List the properties in the MISSING_COLUMN_STATISTICS class PropertyDataCollection lproperties = mClass.Properties; // display the properties Console.WriteLine(string.Format("Property Names in {0}: ",ClassName)); foreach (PropertyData property in lproperties) { Console.WriteLine("name: {0}, Origin: {1}", property.Name, property.Origin ); } WMI query - list of class instancesList of all instances of MISSING_COLUMN_STATISTICS 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\\ServerEvents\\MSSQLSERVER"; string ClassName = "MISSING_COLUMN_STATISTICS"; //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("ApplicationName : {0}", oObject["ApplicationName"]); } |