Parameters - property in ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER namespace

Parameters in other namespaces

List of classes with Parameters local property in ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER namespace

propertyClassOrigin
Parameters__MethodInvocationEvent__MethodInvocationEvent
ParametersALTER_DATABASEALTER_DATABASE
ParametersALTER_INDEXALTER_INDEX
ParametersALTER_INSTANCEALTER_INSTANCE
ParametersALTER_PROCEDUREALTER_PROCEDURE
ParametersALTER_TABLEALTER_TABLE
ParametersALTER_TRIGGERALTER_TRIGGER
ParametersALTER_USERALTER_USER
ParametersBIND_DEFAULTBIND_DEFAULT
ParametersBIND_RULEBIND_RULE
ParametersDDL_EXTENDED_PROCEDURE_EVENTSDDL_EXTENDED_PROCEDURE_EVENTS
ParametersDDL_EXTENDED_PROPERTY_EVENTSDDL_EXTENDED_PROPERTY_EVENTS
ParametersDDL_LINKED_SERVER_EVENTSDDL_LINKED_SERVER_EVENTS
ParametersDDL_MESSAGE_EVENTSDDL_MESSAGE_EVENTS
ParametersDDL_PLAN_GUIDE_EVENTSDDL_PLAN_GUIDE_EVENTS
ParametersDDL_REMOTE_SERVER_EVENTSDDL_REMOTE_SERVER_EVENTS
ParametersRENAMERENAME
ParametersUNBIND_DEFAULTUNBIND_DEFAULT
ParametersUNBIND_RULEUNBIND_RULE

Code samples for Parameters property

The class ALTER_REMOTE_SERVER is abstract and serves only as a base for new classes.

Get a Class as object

Short VB Script code to get the abstract class ALTER_REMOTE_SERVER.
See in another language: C#, VB.Net.
'https://wutils.com/wmi/
Dim wmiClass, oProperty
Set wmiClass = GetObject( _
 "WINMGMTS:\\.\ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER:" + _
 "ALTER_REMOTE_SERVER")

'get some class property 
Wscript.Echo wmiClass.properties_("Parameters").Origin 'or other property name, see properties

'Check if the class is singleton
Wscript.Echo wmiClass.Path_.IsSingleton

'Get number of methods in the class
Wscript.Echo wmiClass.Methods_.Count

'List class properties
For Each oProperty In wmiClass.properties_
	'get property name and origin. Property value in the class is null, of course.
	Wscript.Echo oProperty.Name, oProperty.Origin, oProperty.Value
Next 

InstancesOf

List of all instances, wmi class ALTER_REMOTE_SERVER.
'https://wutils.com/wmi/
Dim oWMI, Instances, Instance

'Get base WMI object, "." means computer name (local)
Set oWMI = GetObject("WINMGMTS:\\.\ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER")

'Get instances of ALTER_REMOTE_SERVER - all instances of this class and derived classes 
Set Instances = oWMI.InstancesOf("ALTER_REMOTE_SERVER")


'Enumerate instances  
For Each Instance In Instances 
  'Do something with the instance
  Wscript.Echo Instance.Parameters 'or other property name
Next 'Instance
comments powered by Disqus
WUtils.com