WUtils.com

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

EventSubClass in other namespaces
…

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

propertyClassOrigin
EventSubClassAUDIT_ADD_DB_USER_EVENTAUDIT_ADD_DB_USER_EVENT
EventSubClassAUDIT_ADD_LOGIN_TO_SERVER_ROLE_EVENTAUDIT_ADD_LOGIN_TO_SERVER_ROLE_EVENT
EventSubClassAUDIT_ADD_MEMBER_TO_DB_ROLE_EVENTAUDIT_ADD_MEMBER_TO_DB_ROLE_EVENT
EventSubClassAUDIT_ADD_ROLE_EVENTAUDIT_ADD_ROLE_EVENT
EventSubClassAUDIT_ADDLOGIN_EVENTAUDIT_ADDLOGIN_EVENT
EventSubClassAUDIT_BACKUP_RESTORE_EVENTAUDIT_BACKUP_RESTORE_EVENT
EventSubClassAUDIT_CHANGE_AUDIT_EVENTAUDIT_CHANGE_AUDIT_EVENT
EventSubClassAUDIT_DATABASE_MANAGEMENT_EVENTAUDIT_DATABASE_MANAGEMENT_EVENT
EventSubClassAUDIT_DATABASE_OBJECT_GDR_EVENTAUDIT_DATABASE_OBJECT_GDR_EVENT
EventSubClassAUDIT_DATABASE_OBJECT_MANAGEMENT_EVENTAUDIT_DATABASE_OBJECT_MANAGEMENT_EVENT
EventSubClassAUDIT_DATABASE_OPERATION_EVENTAUDIT_DATABASE_OPERATION_EVENT
EventSubClassAUDIT_DATABASE_PRINCIPAL_IMPERSONATION_EVENTAUDIT_DATABASE_PRINCIPAL_IMPERSONATION_EVENT
EventSubClassAUDIT_DATABASE_PRINCIPAL_MANAGEMENT_EVENTAUDIT_DATABASE_PRINCIPAL_MANAGEMENT_EVENT
EventSubClassAUDIT_DATABASE_SCOPE_GDR_EVENTAUDIT_DATABASE_SCOPE_GDR_EVENT
EventSubClassAUDIT_FULLTEXTAUDIT_FULLTEXT
EventSubClassAUDIT_LOGINAUDIT_LOGIN
EventSubClassAUDIT_LOGIN_CHANGE_PASSWORD_EVENTAUDIT_LOGIN_CHANGE_PASSWORD_EVENT
EventSubClassAUDIT_LOGIN_CHANGE_PROPERTY_EVENTAUDIT_LOGIN_CHANGE_PROPERTY_EVENT
EventSubClassAUDIT_LOGIN_FAILEDAUDIT_LOGIN_FAILED
EventSubClassAUDIT_LOGIN_GDR_EVENTAUDIT_LOGIN_GDR_EVENT
EventSubClassAUDIT_LOGOUTAUDIT_LOGOUT
EventSubClassAUDIT_SCHEMA_OBJECT_ACCESS_EVENTAUDIT_SCHEMA_OBJECT_ACCESS_EVENT
EventSubClassAUDIT_SCHEMA_OBJECT_GDR_EVENTAUDIT_SCHEMA_OBJECT_GDR_EVENT
EventSubClassAUDIT_SCHEMA_OBJECT_MANAGEMENT_EVENTAUDIT_SCHEMA_OBJECT_MANAGEMENT_EVENT
EventSubClassAUDIT_SERVER_OBJECT_GDR_EVENTAUDIT_SERVER_OBJECT_GDR_EVENT
EventSubClassAUDIT_SERVER_OBJECT_MANAGEMENT_EVENTAUDIT_SERVER_OBJECT_MANAGEMENT_EVENT
EventSubClassAUDIT_SERVER_OPERATION_EVENTAUDIT_SERVER_OPERATION_EVENT
EventSubClassAUDIT_SERVER_PRINCIPAL_IMPERSONATION_EVENTAUDIT_SERVER_PRINCIPAL_IMPERSONATION_EVENT
EventSubClassAUDIT_SERVER_PRINCIPAL_MANAGEMENT_EVENTAUDIT_SERVER_PRINCIPAL_MANAGEMENT_EVENT
EventSubClassAUDIT_SERVER_SCOPE_GDR_EVENTAUDIT_SERVER_SCOPE_GDR_EVENT
EventSubClassBITMAP_WARNINGBITMAP_WARNING
EventSubClassDATABASE_SUSPECT_DATA_PAGEDATABASE_SUSPECT_DATA_PAGE
EventSubClassEXCHANGE_SPILL_EVENTEXCHANGE_SPILL_EVENT
EventSubClassEXECUTION_WARNINGSEXECUTION_WARNINGS
EventSubClassHASH_WARNINGHASH_WARNING
EventSubClassLOCK_DEADLOCK_CHAINLOCK_DEADLOCK_CHAIN
EventSubClassLOCK_ESCALATIONLOCK_ESCALATION
EventSubClassMOUNT_TAPEMOUNT_TAPE
EventSubClassOLEDB_CALL_EVENTOLEDB_CALL_EVENT
EventSubClassOLEDB_DATAREAD_EVENTOLEDB_DATAREAD_EVENT
EventSubClassOLEDB_QUERYINTERFACE_EVENTOLEDB_QUERYINTERFACE_EVENT
EventSubClassSERVER_MEMORY_CHANGESERVER_MEMORY_CHANGE
EventSubClassSORT_WARNINGSSORT_WARNINGS
EventSubClassSP_CACHEREMOVESP_CACHEREMOVE
EventSubClassSP_RECOMPILESP_RECOMPILE
EventSubClassSQL_STMTRECOMPILESQL_STMTRECOMPILE
EventSubClassTRC_OBJECTSTRC_OBJECTS
EventSubClassTRC_QUERY_NOTIFICATIONSTRC_QUERY_NOTIFICATIONS
…

List of classes with EventSubClass derived property in ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER namespace

propertyClassOrigin
EventSubClassOBJECT_ALTEREDTRC_OBJECTS
EventSubClassOBJECT_CREATEDTRC_OBJECTS
EventSubClassOBJECT_DELETEDTRC_OBJECTS
EventSubClassQN__DYNAMICSTRC_QUERY_NOTIFICATIONS
EventSubClassQN__PARAMETER_TABLETRC_QUERY_NOTIFICATIONS
EventSubClassQN__SUBSCRIPTIONTRC_QUERY_NOTIFICATIONS
EventSubClassQN__TEMPLATETRC_QUERY_NOTIFICATIONS

Code samples for EventSubClass property

The class AUDIT_DATABASE_PRINCIPAL_MANAGEMENT_EVENT 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 AUDIT_DATABASE_PRINCIPAL_MANAGEMENT_EVENT.
See in another language: C#, VB.Net.
…
'https://wutils.com/wmi/
Dim wmiClass, oProperty
Set wmiClass = GetObject( _
 "WINMGMTS:\\.\ROOT\Microsoft\SqlServer\ServerEvents\MSSQLSERVER:" + _
 "AUDIT_DATABASE_PRINCIPAL_MANAGEMENT_EVENT")

'get some class property 
Wscript.Echo wmiClass.properties_("EventSubClass").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 AUDIT_DATABASE_PRINCIPAL_MANAGEMENT_EVENT.
…
'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 AUDIT_DATABASE_PRINCIPAL_MANAGEMENT_EVENT - all instances of this class and derived classes 
Set Instances = oWMI.InstancesOf("AUDIT_DATABASE_PRINCIPAL_MANAGEMENT_EVENT")


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