SqlServerAlias, ROOT\Microsoft\SqlServer\ComputerManagement12, VBScript samples

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

SqlServerAlias - VB Script code samples

Get instance of WMI class using GetObject, AliasName property of SqlServerAlias

Short VBS code - get a single specified instance of SqlServerAlias class or get a default unnamed instance (singleton) of the class, using one single command GetObject with exact path of the wmi object.
	
	'http://wutils.com/wmi/
	Dim wmiObject
	Set wmiObject = GetObject( _
	 "WINMGMTS:\\.\ROOT\Microsoft\SqlServer\ComputerManagement12:" + _
	 "SqlServerAlias.AliasName=""Value""")
	Wscript.Echo wmiObject.AliasName 'or other property name, see properties
	

Alternative codes

SWbemServices.Get

Quickest and most efficient VB Script code to get a single instance by a key - SWbemServices.Get
	'http://wutils.com/wmi/
	Dim oWMI, Instance
	
	'Get base WMI object, "." means computer name (local)
	Set oWMI = GetObject("WINMGMTS:\\.\ROOT\Microsoft\SqlServer\ComputerManagement12")
	
	Do
	  'Get the instance of SqlServerAlias 
	  Set Instance = oWMI.Get("SqlServerAlias.AliasName=""Value""")
	                    
	  'Do something with the instance
	  Wscript.Echo Instance.AliasName 'or other property name, see properties
	
	  'Wait for some time to get next value
	  Wscript.Sleep 1000
	Loop While True  
	  
	

WMI query - sample windows WQL

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 Script.
See in another language: C#, VB.Net.
	'http://wutils.com/wmi/
	Dim oWMI, WQL, Instances, Instance
	
	'Get base WMI object, "." means computer name (local)
	Set oWMI = GetObject("WINMGMTS:\\.\ROOT\Microsoft\SqlServer\ComputerManagement12")
	
	'Create a WMI query text 
	WQL = "Select * from SqlServerAlias"
	
	'Get instances of SqlServerAlias 
	Set Instances = oWMI.ExecQuery(WQL)
	                    
	'Enumerate instances  
	For Each Instance In Instances 
	  'Do something with the instance
	  Wscript.Echo Instance.AliasName 'or other property name
	Next 'Instance
	

InstancesOf

List of all instances, wmi class SqlServerAlias.
	'http://wutils.com/wmi/
	Dim oWMI, Instances, Instance
	
	'Get base WMI object, "." means computer name (local)
	Set oWMI = GetObject("WINMGMTS:\\.\ROOT\Microsoft\SqlServer\ComputerManagement12")
	
	'Get instances of SqlServerAlias - all instances of this class and derived classes 
	'Set Instances = oWMI.InstancesOf("SqlServerAlias")
	
	'Get instances of SqlServerAlias 
	Set Instances = oWMI.InstancesOf("SqlServerAlias", 1)
	
	
	'Enumerate instances  
	For Each Instance In Instances 
	  'Do something with the instance
	  Wscript.Echo Instance.AliasName 'or other property name
	Next 'Instance
	

WMI remote scripting - Locator, Connect

Get WMI management object using SWbemLocator.ConnectServer method. You can connect to a remote computer and specify Username/Password for the WMI connection.
	'http://wutils.com/wmi/
	Dim Locator, oWMI, WQL, Instances, Instance
	
	'Create Locator object
	Set Locator = CreateObject("WbemScripting.SWbemLocator")
	
	'Get base WMI object
	Set oWMI = Locator.ConnectServer("MachineName", "ROOT\Microsoft\SqlServer\ComputerManagement12", "MachineName\administrator", "Password")
	 
	'.... continue using oWMI object
	
	
comments powered by Disqus
online utility - toplist
WUtils.com