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

UserName in other namespaces

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

propertyClassOrigin
UserNameDDL_DATABASE_LEVEL_EVENTSDDL_DATABASE_LEVEL_EVENTS

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

propertyClassOrigin
UserNameADD_ROLE_MEMBERDDL_DATABASE_LEVEL_EVENTS
UserNameADD_SIGNATUREDDL_DATABASE_LEVEL_EVENTS
UserNameADD_SIGNATURE_SCHEMA_OBJECTDDL_DATABASE_LEVEL_EVENTS
UserNameALTER_APPLICATION_ROLEDDL_DATABASE_LEVEL_EVENTS
UserNameALTER_ASSEMBLYDDL_DATABASE_LEVEL_EVENTS
UserNameALTER_ASYMMETRIC_KEYDDL_DATABASE_LEVEL_EVENTS
UserNameALTER_AUDITDDL_DATABASE_LEVEL_EVENTS
UserNameALTER_AUTHORIZATION_DATABASEDDL_DATABASE_LEVEL_EVENTS
UserNameALTER_BROKER_PRIORITYDDL_DATABASE_LEVEL_EVENTS
UserNameALTER_CERTIFICATEDDL_DATABASE_LEVEL_EVENTS
UserNameALTER_DATABASE_AUDIT_SPECIFICATIONDDL_DATABASE_LEVEL_EVENTS
UserNameALTER_DATABASE_ENCRYPTION_KEYDDL_DATABASE_LEVEL_EVENTS
UserNameALTER_EXTENDED_PROPERTYDDL_DATABASE_LEVEL_EVENTS
UserNameALTER_FULLTEXT_CATALOGDDL_DATABASE_LEVEL_EVENTS
UserNameALTER_FULLTEXT_INDEXDDL_DATABASE_LEVEL_EVENTS
UserNameALTER_FULLTEXT_STOPLISTDDL_DATABASE_LEVEL_EVENTS
UserNameALTER_FUNCTIONDDL_DATABASE_LEVEL_EVENTS
UserNameALTER_INDEXDDL_DATABASE_LEVEL_EVENTS
UserNameALTER_MASTER_KEYDDL_DATABASE_LEVEL_EVENTS
UserNameALTER_MESSAGE_TYPEDDL_DATABASE_LEVEL_EVENTS
UserNameALTER_PARTITION_FUNCTIONDDL_DATABASE_LEVEL_EVENTS
UserNameALTER_PARTITION_SCHEMEDDL_DATABASE_LEVEL_EVENTS
UserNameALTER_PLAN_GUIDEDDL_DATABASE_LEVEL_EVENTS
UserNameALTER_PROCEDUREDDL_DATABASE_LEVEL_EVENTS
UserNameALTER_QUEUEDDL_DATABASE_LEVEL_EVENTS
UserNameALTER_REMOTE_SERVICE_BINDINGDDL_DATABASE_LEVEL_EVENTS
UserNameALTER_ROLEDDL_DATABASE_LEVEL_EVENTS
UserNameALTER_ROUTEDDL_DATABASE_LEVEL_EVENTS
UserNameALTER_SCHEMADDL_DATABASE_LEVEL_EVENTS
UserNameALTER_SEARCH_PROPERTY_LISTDDL_DATABASE_LEVEL_EVENTS
UserNameALTER_SEQUENCEDDL_DATABASE_LEVEL_EVENTS
UserNameALTER_SERVICEDDL_DATABASE_LEVEL_EVENTS
UserNameALTER_SYMMETRIC_KEYDDL_DATABASE_LEVEL_EVENTS
UserNameALTER_TABLEDDL_DATABASE_LEVEL_EVENTS
UserNameALTER_TRIGGERDDL_DATABASE_LEVEL_EVENTS
UserNameALTER_USERDDL_DATABASE_LEVEL_EVENTS
UserNameALTER_VIEWDDL_DATABASE_LEVEL_EVENTS
UserNameALTER_XML_SCHEMA_COLLECTIONDDL_DATABASE_LEVEL_EVENTS
UserNameBIND_DEFAULTDDL_DATABASE_LEVEL_EVENTS
UserNameBIND_RULEDDL_DATABASE_LEVEL_EVENTS
UserNameCREATE_APPLICATION_ROLEDDL_DATABASE_LEVEL_EVENTS
UserNameCREATE_ASSEMBLYDDL_DATABASE_LEVEL_EVENTS
UserNameCREATE_ASYMMETRIC_KEYDDL_DATABASE_LEVEL_EVENTS
UserNameCREATE_AUDITDDL_DATABASE_LEVEL_EVENTS
UserNameCREATE_BROKER_PRIORITYDDL_DATABASE_LEVEL_EVENTS
UserNameCREATE_CERTIFICATEDDL_DATABASE_LEVEL_EVENTS
UserNameCREATE_CONTRACTDDL_DATABASE_LEVEL_EVENTS
UserNameCREATE_DATABASE_AUDIT_SPECIFICATIONDDL_DATABASE_LEVEL_EVENTS
UserNameCREATE_DATABASE_ENCRYPTION_KEYDDL_DATABASE_LEVEL_EVENTS
UserNameCREATE_DEFAULTDDL_DATABASE_LEVEL_EVENTS
UserNameCREATE_EVENT_NOTIFICATIONDDL_DATABASE_LEVEL_EVENTS
UserNameCREATE_EXTENDED_PROPERTYDDL_DATABASE_LEVEL_EVENTS
UserNameCREATE_FULLTEXT_CATALOGDDL_DATABASE_LEVEL_EVENTS
UserNameCREATE_FULLTEXT_INDEXDDL_DATABASE_LEVEL_EVENTS
UserNameCREATE_FULLTEXT_STOPLISTDDL_DATABASE_LEVEL_EVENTS
UserNameCREATE_FUNCTIONDDL_DATABASE_LEVEL_EVENTS
UserNameCREATE_INDEXDDL_DATABASE_LEVEL_EVENTS
UserNameCREATE_MASTER_KEYDDL_DATABASE_LEVEL_EVENTS
UserNameCREATE_MESSAGE_TYPEDDL_DATABASE_LEVEL_EVENTS
UserNameCREATE_PARTITION_FUNCTIONDDL_DATABASE_LEVEL_EVENTS
UserNameCREATE_PARTITION_SCHEMEDDL_DATABASE_LEVEL_EVENTS
UserNameCREATE_PLAN_GUIDEDDL_DATABASE_LEVEL_EVENTS
UserNameCREATE_PROCEDUREDDL_DATABASE_LEVEL_EVENTS
UserNameCREATE_QUEUEDDL_DATABASE_LEVEL_EVENTS
UserNameCREATE_REMOTE_SERVICE_BINDINGDDL_DATABASE_LEVEL_EVENTS
UserNameCREATE_ROLEDDL_DATABASE_LEVEL_EVENTS
UserNameCREATE_ROUTEDDL_DATABASE_LEVEL_EVENTS
UserNameCREATE_RULEDDL_DATABASE_LEVEL_EVENTS
UserNameCREATE_SCHEMADDL_DATABASE_LEVEL_EVENTS
UserNameCREATE_SEARCH_PROPERTY_LISTDDL_DATABASE_LEVEL_EVENTS
UserNameCREATE_SEQUENCEDDL_DATABASE_LEVEL_EVENTS
UserNameCREATE_SERVICEDDL_DATABASE_LEVEL_EVENTS
UserNameCREATE_SPATIAL_INDEXDDL_DATABASE_LEVEL_EVENTS
UserNameCREATE_STATISTICSDDL_DATABASE_LEVEL_EVENTS
UserNameCREATE_SYMMETRIC_KEYDDL_DATABASE_LEVEL_EVENTS
UserNameCREATE_SYNONYMDDL_DATABASE_LEVEL_EVENTS
UserNameCREATE_TABLEDDL_DATABASE_LEVEL_EVENTS
UserNameCREATE_TRIGGERDDL_DATABASE_LEVEL_EVENTS
UserNameCREATE_TYPEDDL_DATABASE_LEVEL_EVENTS
UserNameCREATE_USERDDL_DATABASE_LEVEL_EVENTS
UserNameCREATE_VIEWDDL_DATABASE_LEVEL_EVENTS
UserNameCREATE_XML_INDEXDDL_DATABASE_LEVEL_EVENTS
UserNameCREATE_XML_SCHEMA_COLLECTIONDDL_DATABASE_LEVEL_EVENTS
UserNameDDL_APPLICATION_ROLE_EVENTSDDL_DATABASE_LEVEL_EVENTS
UserNameDDL_ASSEMBLY_EVENTSDDL_DATABASE_LEVEL_EVENTS
UserNameDDL_ASYMMETRIC_KEY_EVENTSDDL_DATABASE_LEVEL_EVENTS
UserNameDDL_AUTHORIZATION_DATABASE_EVENTSDDL_DATABASE_LEVEL_EVENTS
UserNameDDL_BROKER_PRIORITY_EVENTSDDL_DATABASE_LEVEL_EVENTS
UserNameDDL_CERTIFICATE_EVENTSDDL_DATABASE_LEVEL_EVENTS
UserNameDDL_CONTRACT_EVENTSDDL_DATABASE_LEVEL_EVENTS
UserNameDDL_CRYPTO_SIGNATURE_EVENTSDDL_DATABASE_LEVEL_EVENTS
UserNameDDL_DATABASE_AUDIT_EVENTSDDL_DATABASE_LEVEL_EVENTS
UserNameDDL_DATABASE_AUDIT_SPECIFICATION_EVENTSDDL_DATABASE_LEVEL_EVENTS
UserNameDDL_DATABASE_ENCRYPTION_KEY_EVENTSDDL_DATABASE_LEVEL_EVENTS
UserNameDDL_DATABASE_SECURITY_EVENTSDDL_DATABASE_LEVEL_EVENTS
UserNameDDL_DEFAULT_EVENTSDDL_DATABASE_LEVEL_EVENTS
UserNameDDL_EVENT_NOTIFICATION_EVENTSDDL_DATABASE_LEVEL_EVENTS
UserNameDDL_EXTENDED_PROPERTY_EVENTSDDL_DATABASE_LEVEL_EVENTS
UserNameDDL_FULLTEXT_CATALOG_EVENTSDDL_DATABASE_LEVEL_EVENTS
UserNameDDL_FULLTEXT_STOPLIST_EVENTSDDL_DATABASE_LEVEL_EVENTS
UserNameDDL_FUNCTION_EVENTSDDL_DATABASE_LEVEL_EVENTS
UserNameDDL_GDR_DATABASE_EVENTSDDL_DATABASE_LEVEL_EVENTS
UserNameDDL_INDEX_EVENTSDDL_DATABASE_LEVEL_EVENTS
UserNameDDL_MASTER_KEY_EVENTSDDL_DATABASE_LEVEL_EVENTS
UserNameDDL_MESSAGE_TYPE_EVENTSDDL_DATABASE_LEVEL_EVENTS
UserNameDDL_PARTITION_EVENTSDDL_DATABASE_LEVEL_EVENTS
UserNameDDL_PARTITION_FUNCTION_EVENTSDDL_DATABASE_LEVEL_EVENTS
UserNameDDL_PARTITION_SCHEME_EVENTSDDL_DATABASE_LEVEL_EVENTS
UserNameDDL_PLAN_GUIDE_EVENTSDDL_DATABASE_LEVEL_EVENTS
UserNameDDL_PROCEDURE_EVENTSDDL_DATABASE_LEVEL_EVENTS
UserNameDDL_QUEUE_EVENTSDDL_DATABASE_LEVEL_EVENTS
UserNameDDL_REMOTE_SERVICE_BINDING_EVENTSDDL_DATABASE_LEVEL_EVENTS
UserNameDDL_ROLE_EVENTSDDL_DATABASE_LEVEL_EVENTS
UserNameDDL_ROUTE_EVENTSDDL_DATABASE_LEVEL_EVENTS
UserNameDDL_RULE_EVENTSDDL_DATABASE_LEVEL_EVENTS
UserNameDDL_SCHEMA_EVENTSDDL_DATABASE_LEVEL_EVENTS
UserNameDDL_SEARCH_PROPERTY_LIST_EVENTSDDL_DATABASE_LEVEL_EVENTS
UserNameDDL_SEQUENCE_EVENTSDDL_DATABASE_LEVEL_EVENTS
UserNameDDL_SERVICE_EVENTSDDL_DATABASE_LEVEL_EVENTS
UserNameDDL_SSB_EVENTSDDL_DATABASE_LEVEL_EVENTS
UserNameDDL_STATISTICS_EVENTSDDL_DATABASE_LEVEL_EVENTS
UserNameDDL_SYMMETRIC_KEY_EVENTSDDL_DATABASE_LEVEL_EVENTS
UserNameDDL_SYNONYM_EVENTSDDL_DATABASE_LEVEL_EVENTS
UserNameDDL_TABLE_EVENTSDDL_DATABASE_LEVEL_EVENTS
UserNameDDL_TABLE_VIEW_EVENTSDDL_DATABASE_LEVEL_EVENTS
UserNameDDL_TRIGGER_EVENTSDDL_DATABASE_LEVEL_EVENTS
UserNameDDL_TYPE_EVENTSDDL_DATABASE_LEVEL_EVENTS
UserNameDDL_USER_EVENTSDDL_DATABASE_LEVEL_EVENTS
UserNameDDL_VIEW_EVENTSDDL_DATABASE_LEVEL_EVENTS
UserNameDDL_XML_SCHEMA_COLLECTION_EVENTSDDL_DATABASE_LEVEL_EVENTS
UserNameDENY_DATABASEDDL_DATABASE_LEVEL_EVENTS
UserNameDROP_APPLICATION_ROLEDDL_DATABASE_LEVEL_EVENTS
UserNameDROP_ASSEMBLYDDL_DATABASE_LEVEL_EVENTS
UserNameDROP_ASYMMETRIC_KEYDDL_DATABASE_LEVEL_EVENTS
UserNameDROP_AUDITDDL_DATABASE_LEVEL_EVENTS
UserNameDROP_BROKER_PRIORITYDDL_DATABASE_LEVEL_EVENTS
UserNameDROP_CERTIFICATEDDL_DATABASE_LEVEL_EVENTS
UserNameDROP_CONTRACTDDL_DATABASE_LEVEL_EVENTS
UserNameDROP_DATABASE_AUDIT_SPECIFICATIONDDL_DATABASE_LEVEL_EVENTS
UserNameDROP_DATABASE_ENCRYPTION_KEYDDL_DATABASE_LEVEL_EVENTS
UserNameDROP_DEFAULTDDL_DATABASE_LEVEL_EVENTS
UserNameDROP_EVENT_NOTIFICATIONDDL_DATABASE_LEVEL_EVENTS
UserNameDROP_EXTENDED_PROPERTYDDL_DATABASE_LEVEL_EVENTS
UserNameDROP_FULLTEXT_CATALOGDDL_DATABASE_LEVEL_EVENTS
UserNameDROP_FULLTEXT_INDEXDDL_DATABASE_LEVEL_EVENTS
UserNameDROP_FULLTEXT_STOPLISTDDL_DATABASE_LEVEL_EVENTS
UserNameDROP_FUNCTIONDDL_DATABASE_LEVEL_EVENTS
UserNameDROP_INDEXDDL_DATABASE_LEVEL_EVENTS
UserNameDROP_MASTER_KEYDDL_DATABASE_LEVEL_EVENTS
UserNameDROP_MESSAGE_TYPEDDL_DATABASE_LEVEL_EVENTS
UserNameDROP_PARTITION_FUNCTIONDDL_DATABASE_LEVEL_EVENTS
UserNameDROP_PARTITION_SCHEMEDDL_DATABASE_LEVEL_EVENTS
UserNameDROP_PLAN_GUIDEDDL_DATABASE_LEVEL_EVENTS
UserNameDROP_PROCEDUREDDL_DATABASE_LEVEL_EVENTS
UserNameDROP_QUEUEDDL_DATABASE_LEVEL_EVENTS
UserNameDROP_REMOTE_SERVICE_BINDINGDDL_DATABASE_LEVEL_EVENTS
UserNameDROP_ROLEDDL_DATABASE_LEVEL_EVENTS
UserNameDROP_ROLE_MEMBERDDL_DATABASE_LEVEL_EVENTS
UserNameDROP_ROUTEDDL_DATABASE_LEVEL_EVENTS
UserNameDROP_RULEDDL_DATABASE_LEVEL_EVENTS
UserNameDROP_SCHEMADDL_DATABASE_LEVEL_EVENTS
UserNameDROP_SEARCH_PROPERTY_LISTDDL_DATABASE_LEVEL_EVENTS
UserNameDROP_SEQUENCEDDL_DATABASE_LEVEL_EVENTS
UserNameDROP_SERVICEDDL_DATABASE_LEVEL_EVENTS
UserNameDROP_SIGNATUREDDL_DATABASE_LEVEL_EVENTS
UserNameDROP_SIGNATURE_SCHEMA_OBJECTDDL_DATABASE_LEVEL_EVENTS
UserNameDROP_STATISTICSDDL_DATABASE_LEVEL_EVENTS
UserNameDROP_SYMMETRIC_KEYDDL_DATABASE_LEVEL_EVENTS
UserNameDROP_SYNONYMDDL_DATABASE_LEVEL_EVENTS
UserNameDROP_TABLEDDL_DATABASE_LEVEL_EVENTS
UserNameDROP_TRIGGERDDL_DATABASE_LEVEL_EVENTS
UserNameDROP_TYPEDDL_DATABASE_LEVEL_EVENTS
UserNameDROP_USERDDL_DATABASE_LEVEL_EVENTS
UserNameDROP_VIEWDDL_DATABASE_LEVEL_EVENTS
UserNameDROP_XML_SCHEMA_COLLECTIONDDL_DATABASE_LEVEL_EVENTS
UserNameGRANT_DATABASEDDL_DATABASE_LEVEL_EVENTS
UserNameRENAMEDDL_DATABASE_LEVEL_EVENTS
UserNameREVOKE_DATABASEDDL_DATABASE_LEVEL_EVENTS
UserNameUNBIND_DEFAULTDDL_DATABASE_LEVEL_EVENTS
UserNameUNBIND_RULEDDL_DATABASE_LEVEL_EVENTS
UserNameUPDATE_STATISTICSDDL_DATABASE_LEVEL_EVENTS

Code samples for UserName property

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

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


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