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

GroupID in other namespaces

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

propertyClassOrigin
GroupIDASSEMBLY_LOADASSEMBLY_LOAD
GroupIDAUDIT_LOGINAUDIT_LOGIN
GroupIDAUDIT_LOGOUTAUDIT_LOGOUT
GroupIDCPU_THRESHOLD_EXCEEDEDCPU_THRESHOLD_EXCEEDED
GroupIDEXCEPTIONEXCEPTION
GroupIDEXCHANGE_SPILL_EVENTEXCHANGE_SPILL_EVENT
GroupIDEXECUTION_WARNINGSEXECUTION_WARNINGS
GroupIDHASH_WARNINGHASH_WARNING
GroupIDLOCK_DEADLOCKLOCK_DEADLOCK
GroupIDLOCK_ESCALATIONLOCK_ESCALATION
GroupIDMISSING_COLUMN_STATISTICSMISSING_COLUMN_STATISTICS
GroupIDMISSING_JOIN_PREDICATEMISSING_JOIN_PREDICATE
GroupIDMOUNT_TAPEMOUNT_TAPE
GroupIDSORT_WARNINGSSORT_WARNINGS
GroupIDTRC_OBJECTSTRC_OBJECTS
GroupIDTRC_OLEDBTRC_OLEDB
GroupIDTRC_PERFORMANCETRC_PERFORMANCE
GroupIDTRC_QUERY_NOTIFICATIONSTRC_QUERY_NOTIFICATIONS
GroupIDTRC_STORED_PROCEDURESTRC_STORED_PROCEDURES
GroupIDTRC_TSQLTRC_TSQL
GroupIDTRC_USER_CONFIGURABLETRC_USER_CONFIGURABLE
GroupIDUSER_ERROR_MESSAGEUSER_ERROR_MESSAGE

Code samples for GroupID property

The class QN__SUBSCRIPTION 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 QN__SUBSCRIPTION.
See in another language: C#, VB.Net.
'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 

InstancesOf

List 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
comments powered by Disqus
WUtils.com