SqlServerAlias, ROOT\Microsoft\SqlServer\ComputerManagement12, VB Net samples

Class | Methods | Properties (4) | Qualifiers (2) | Instances | Namespaces (1)
Samples: VB Script | C# | VB.Net | Search on:Microsoft

SqlServerAlias - VB.Net code samples

WMI query - sample windows WQL with VB.Net, AliasName property of SqlServerAlias

Get a specified instance of SqlServerAlias 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 SqlServerAlias")
	
	'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("AliasName : {0}", mObject("AliasName"))
	Next
	

WMI query - list of class instances

List of all instances of SqlServerAlias class in C#.
See in another language: VBScript, VB.Net.
	//http://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 = "SqlServerAlias";
	
	//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("AliasName : {0}", oObject["AliasName"]);
	}
	
comments powered by Disqus
online utility - toplist
WUtils.com