Includes&Samples |
sql_instance_name - property in ROOT\WMI namespacesql_instance_name in other namespacesList of classes with sql_instance_name local property in ROOT\WMI namespace
Code samples for sql_instance_name propertyGet instance of WMI class using GetObject, sql_instance_name property of hadr_sql_instance_to_node_map_entry_deletedShort VBS code - get a single specified instance of hadr_sql_instance_to_node_map_entry_deleted 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\WMI:" + _ "hadr_sql_instance_to_node_map_entry_deleted.PropertyName=""SomeText""") Wscript.Echo wmiObject.sql_instance_name 'or other property name, see properties WMI query - sample windows WQL with C#, sql_instance_name property of hadr_sql_instance_to_node_map_entry_deletedGet a specified instance of hadr_sql_instance_to_node_map_entry_deleted 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\\WMI"); //create object query ObjectQuery query = new ObjectQuery("SELECT * FROM hadr_sql_instance_to_node_map_entry_deleted Where PropertyName=\"SomeText\""); //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("sql_instance_name : {0}", m["sql_instance_name"]); } WMI query - sample windows WQL with VB.Net, sql_instance_name property of hadr_sql_instance_to_node_map_entry_deletedGet a specified instance of hadr_sql_instance_to_node_map_entry_deleted 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\WMI") 'Get a result of WML query Dim Query As New ObjectQuery("SELECT * FROM hadr_sql_instance_to_node_map_entry_deleted Where PropertyName="SomeText"") '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("sql_instance_name : {0}", mObject("sql_instance_name")) Next |