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

PropertyName in other namespaces

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

propertyClassOrigin
PropertyNameClientNetworkProtocolPropertyClientNetworkProtocolProperty
PropertyNameServerNetworkProtocolPropertyServerNetworkProtocolProperty
PropertyNameSqlServiceAdvancedPropertySqlServiceAdvancedProperty

Code samples for PropertyName property

Get instance of WMI class using GetObject, PropertyName property of SqlServiceAdvancedProperty

Short VBS code - get a single specified instance of SqlServiceAdvancedProperty 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:" + _
 "SqlServiceAdvancedProperty.PropertyIndex=0,PropertyName=""SQLSTATES"",ServiceName=""MSSQLSERVER"",SqlServiceType=1")
Wscript.Echo wmiObject.PropertyName 'or other property name, see properties
See more VBS samples of SqlServiceAdvancedProperty class

WMI query - sample windows WQL with C#, PropertyName property of SqlServiceAdvancedProperty

Get a specified instance of SqlServiceAdvancedProperty 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 SqlServiceAdvancedProperty Where PropertyIndex=\"0\"PropertyName=\"SQLSTATES\"ServiceName=\"MSSQLSERVER\"SqlServiceType=\"1\"");

//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("PropertyName : {0}", m["PropertyName"]);
  
}

WMI query - sample windows WQL with VB.Net, PropertyName property of SqlServiceAdvancedProperty

Get a specified instance of SqlServiceAdvancedProperty 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 SqlServiceAdvancedProperty Where PropertyIndex="0"PropertyName="SQLSTATES"ServiceName="MSSQLSERVER"SqlServiceType="1"")

'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("PropertyName : {0}", mObject("PropertyName"))
Next
comments powered by Disqus
WUtils.com