sql_instance_name - property in ROOT\WMI namespace

List of classes with sql_instance_name local property in ROOT\WMI namespace

property	Class	Origin
sql_instance_name	hadr_sql_instance_to_node_map_entry_created_updated	hadr_sql_instance_to_node_map_entry_created_updated
sql_instance_name	hadr_sql_instance_to_node_map_entry_deleted	hadr_sql_instance_to_node_map_entry_deleted

Code samples for sql_instance_name property

Get instance of WMI class using GetObject, sql_instance_name property of hadr_sql_instance_to_node_map_entry_deleted

Short 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

See more VBS samples of hadr_sql_instance_to_node_map_entry_deleted class

WMI query - sample windows WQL with C#, sql_instance_name property of hadr_sql_instance_to_node_map_entry_deleted

Get 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.

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\\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_deleted

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\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

WUtils.com

Includes&Samples