Includes&Samples |
GroupID - property in ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER namespaceGroupID in other namespacesList of classes with GroupID local property in ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER namespace
List of classes with GroupID derived property in ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER namespaceCode samples for GroupID propertyThe class QN__SUBSCRIPTION is abstract and serves only as a base for new classes. Get a Class as objectShort VB Script code to get the abstract class QN__SUBSCRIPTION.
'https://wutils.com/wmi/ Dim wmiClass, oProperty Set wmiClass = GetObject( _ "WINMGMTS:\\.\ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER:" + _ "QN__SUBSCRIPTION") 'get some class property Wscript.Echo wmiClass.properties_("GroupID").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 InstancesOfList of all instances, wmi class QN__SUBSCRIPTION.
'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 QN__SUBSCRIPTION - all instances of this class and derived classes Set Instances = oWMI.InstancesOf("QN__SUBSCRIPTION") 'Enumerate instances For Each Instance In Instances 'Do something with the instance Wscript.Echo Instance.GroupID 'or other property name Next 'Instance |