XeSqlPkg_xtp_create_procedure, ROOT\WMI, VBScript samples

XeSqlPkg_xtp_create_procedure - VB Script code samples

Get instance of WMI class using GetObject, Flags property of XeSqlPkg_xtp_create_procedure

Short VBS code - get a single specified instance of XeSqlPkg_xtp_create_procedure 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:" + _
	 "XeSqlPkg_xtp_create_procedure.PropertyName=""SomeText""")
	Wscript.Echo wmiObject.Flags '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

…

	'https://wutils.com/wmi/
	Dim oWMI, Instance
	
	'Get base WMI object, "." means computer name (local)
	Set oWMI = GetObject("WINMGMTS:\\.\ROOT\WMI")
	
	Do
	  'Get the instance of XeSqlPkg_xtp_create_procedure 
	  Set Instance = oWMI.Get("XeSqlPkg_xtp_create_procedure.PropertyName=""SomeText""")
	                    
	  'Do something with the instance
	  Wscript.Echo Instance.Flags '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 XeSqlPkg_xtp_create_procedure 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.

…

	'https://wutils.com/wmi/
	Dim oWMI, WQL, Instances, Instance
	
	'Get base WMI object, "." means computer name (local)
	Set oWMI = GetObject("WINMGMTS:\\.\ROOT\WMI")
	
	'Create a WMI query text 
	WQL = "Select * from XeSqlPkg_xtp_create_procedure Where PropertyName=""SomeText"""
	
	'Get instances of XeSqlPkg_xtp_create_procedure 
	Set Instances = oWMI.ExecQuery(WQL)
	                    
	'Enumerate instances  
	For Each Instance In Instances 
	  'Do something with the instance
	  Wscript.Echo Instance.Flags 'or other property name
	Next 'Instance

InstancesOf

List of all instances, wmi class XeSqlPkg_xtp_create_procedure.

…

	'https://wutils.com/wmi/
	Dim oWMI, Instances, Instance
	
	'Get base WMI object, "." means computer name (local)
	Set oWMI = GetObject("WINMGMTS:\\.\ROOT\WMI")
	
	'Get instances of XeSqlPkg_xtp_create_procedure - all instances of this class and derived classes 
	'Set Instances = oWMI.InstancesOf("XeSqlPkg_xtp_create_procedure")
	
	'Get instances of XeSqlPkg_xtp_create_procedure 
	Set Instances = oWMI.InstancesOf("XeSqlPkg_xtp_create_procedure", 1)
	
	
	'Enumerate instances  
	For Each Instance In Instances 
	  'Do something with the instance
	  Wscript.Echo Instance.Flags '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.

…

	'https://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\WMI", "MachineName\administrator", "Password")
	 
	'.... continue using oWMI object

WUtils.com

Includes&Samples