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

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

property	Class	Origin
UserName	DDL_DATABASE_LEVEL_EVENTS	DDL_DATABASE_LEVEL_EVENTS

…

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

property	Class	Origin
UserName	ADD_ROLE_MEMBER	DDL_DATABASE_LEVEL_EVENTS
UserName	ADD_SIGNATURE	DDL_DATABASE_LEVEL_EVENTS
UserName	ADD_SIGNATURE_SCHEMA_OBJECT	DDL_DATABASE_LEVEL_EVENTS
UserName	ALTER_APPLICATION_ROLE	DDL_DATABASE_LEVEL_EVENTS
UserName	ALTER_ASSEMBLY	DDL_DATABASE_LEVEL_EVENTS
UserName	ALTER_ASYMMETRIC_KEY	DDL_DATABASE_LEVEL_EVENTS
UserName	ALTER_AUDIT	DDL_DATABASE_LEVEL_EVENTS
UserName	ALTER_AUTHORIZATION_DATABASE	DDL_DATABASE_LEVEL_EVENTS
UserName	ALTER_BROKER_PRIORITY	DDL_DATABASE_LEVEL_EVENTS
UserName	ALTER_CERTIFICATE	DDL_DATABASE_LEVEL_EVENTS
UserName	ALTER_DATABASE_AUDIT_SPECIFICATION	DDL_DATABASE_LEVEL_EVENTS
UserName	ALTER_DATABASE_ENCRYPTION_KEY	DDL_DATABASE_LEVEL_EVENTS
UserName	ALTER_EXTENDED_PROPERTY	DDL_DATABASE_LEVEL_EVENTS
UserName	ALTER_FULLTEXT_CATALOG	DDL_DATABASE_LEVEL_EVENTS
UserName	ALTER_FULLTEXT_INDEX	DDL_DATABASE_LEVEL_EVENTS
UserName	ALTER_FULLTEXT_STOPLIST	DDL_DATABASE_LEVEL_EVENTS
UserName	ALTER_FUNCTION	DDL_DATABASE_LEVEL_EVENTS
UserName	ALTER_INDEX	DDL_DATABASE_LEVEL_EVENTS
UserName	ALTER_MASTER_KEY	DDL_DATABASE_LEVEL_EVENTS
UserName	ALTER_MESSAGE_TYPE	DDL_DATABASE_LEVEL_EVENTS
UserName	ALTER_PARTITION_FUNCTION	DDL_DATABASE_LEVEL_EVENTS
UserName	ALTER_PARTITION_SCHEME	DDL_DATABASE_LEVEL_EVENTS
UserName	ALTER_PLAN_GUIDE	DDL_DATABASE_LEVEL_EVENTS
UserName	ALTER_PROCEDURE	DDL_DATABASE_LEVEL_EVENTS
UserName	ALTER_QUEUE	DDL_DATABASE_LEVEL_EVENTS
UserName	ALTER_REMOTE_SERVICE_BINDING	DDL_DATABASE_LEVEL_EVENTS
UserName	ALTER_ROLE	DDL_DATABASE_LEVEL_EVENTS
UserName	ALTER_ROUTE	DDL_DATABASE_LEVEL_EVENTS
UserName	ALTER_SCHEMA	DDL_DATABASE_LEVEL_EVENTS
UserName	ALTER_SEARCH_PROPERTY_LIST	DDL_DATABASE_LEVEL_EVENTS
UserName	ALTER_SEQUENCE	DDL_DATABASE_LEVEL_EVENTS
UserName	ALTER_SERVICE	DDL_DATABASE_LEVEL_EVENTS
UserName	ALTER_SYMMETRIC_KEY	DDL_DATABASE_LEVEL_EVENTS
UserName	ALTER_TABLE	DDL_DATABASE_LEVEL_EVENTS
UserName	ALTER_TRIGGER	DDL_DATABASE_LEVEL_EVENTS
UserName	ALTER_USER	DDL_DATABASE_LEVEL_EVENTS
UserName	ALTER_VIEW	DDL_DATABASE_LEVEL_EVENTS
UserName	ALTER_XML_SCHEMA_COLLECTION	DDL_DATABASE_LEVEL_EVENTS
UserName	BIND_DEFAULT	DDL_DATABASE_LEVEL_EVENTS
UserName	BIND_RULE	DDL_DATABASE_LEVEL_EVENTS
UserName	CREATE_APPLICATION_ROLE	DDL_DATABASE_LEVEL_EVENTS
UserName	CREATE_ASSEMBLY	DDL_DATABASE_LEVEL_EVENTS
UserName	CREATE_ASYMMETRIC_KEY	DDL_DATABASE_LEVEL_EVENTS
UserName	CREATE_AUDIT	DDL_DATABASE_LEVEL_EVENTS
UserName	CREATE_BROKER_PRIORITY	DDL_DATABASE_LEVEL_EVENTS
UserName	CREATE_CERTIFICATE	DDL_DATABASE_LEVEL_EVENTS
UserName	CREATE_CONTRACT	DDL_DATABASE_LEVEL_EVENTS
UserName	CREATE_DATABASE_AUDIT_SPECIFICATION	DDL_DATABASE_LEVEL_EVENTS
UserName	CREATE_DATABASE_ENCRYPTION_KEY	DDL_DATABASE_LEVEL_EVENTS
UserName	CREATE_DEFAULT	DDL_DATABASE_LEVEL_EVENTS
UserName	CREATE_EVENT_NOTIFICATION	DDL_DATABASE_LEVEL_EVENTS
UserName	CREATE_EXTENDED_PROPERTY	DDL_DATABASE_LEVEL_EVENTS
UserName	CREATE_FULLTEXT_CATALOG	DDL_DATABASE_LEVEL_EVENTS
UserName	CREATE_FULLTEXT_INDEX	DDL_DATABASE_LEVEL_EVENTS
UserName	CREATE_FULLTEXT_STOPLIST	DDL_DATABASE_LEVEL_EVENTS
UserName	CREATE_FUNCTION	DDL_DATABASE_LEVEL_EVENTS
UserName	CREATE_INDEX	DDL_DATABASE_LEVEL_EVENTS
UserName	CREATE_MASTER_KEY	DDL_DATABASE_LEVEL_EVENTS
UserName	CREATE_MESSAGE_TYPE	DDL_DATABASE_LEVEL_EVENTS
UserName	CREATE_PARTITION_FUNCTION	DDL_DATABASE_LEVEL_EVENTS
UserName	CREATE_PARTITION_SCHEME	DDL_DATABASE_LEVEL_EVENTS
UserName	CREATE_PLAN_GUIDE	DDL_DATABASE_LEVEL_EVENTS
UserName	CREATE_PROCEDURE	DDL_DATABASE_LEVEL_EVENTS
UserName	CREATE_QUEUE	DDL_DATABASE_LEVEL_EVENTS
UserName	CREATE_REMOTE_SERVICE_BINDING	DDL_DATABASE_LEVEL_EVENTS
UserName	CREATE_ROLE	DDL_DATABASE_LEVEL_EVENTS
UserName	CREATE_ROUTE	DDL_DATABASE_LEVEL_EVENTS
UserName	CREATE_RULE	DDL_DATABASE_LEVEL_EVENTS
UserName	CREATE_SCHEMA	DDL_DATABASE_LEVEL_EVENTS
UserName	CREATE_SEARCH_PROPERTY_LIST	DDL_DATABASE_LEVEL_EVENTS
UserName	CREATE_SEQUENCE	DDL_DATABASE_LEVEL_EVENTS
UserName	CREATE_SERVICE	DDL_DATABASE_LEVEL_EVENTS
UserName	CREATE_SPATIAL_INDEX	DDL_DATABASE_LEVEL_EVENTS
UserName	CREATE_STATISTICS	DDL_DATABASE_LEVEL_EVENTS
UserName	CREATE_SYMMETRIC_KEY	DDL_DATABASE_LEVEL_EVENTS
UserName	CREATE_SYNONYM	DDL_DATABASE_LEVEL_EVENTS
UserName	CREATE_TABLE	DDL_DATABASE_LEVEL_EVENTS
UserName	CREATE_TRIGGER	DDL_DATABASE_LEVEL_EVENTS
UserName	CREATE_TYPE	DDL_DATABASE_LEVEL_EVENTS
UserName	CREATE_USER	DDL_DATABASE_LEVEL_EVENTS
UserName	CREATE_VIEW	DDL_DATABASE_LEVEL_EVENTS
UserName	CREATE_XML_INDEX	DDL_DATABASE_LEVEL_EVENTS
UserName	CREATE_XML_SCHEMA_COLLECTION	DDL_DATABASE_LEVEL_EVENTS
UserName	DDL_APPLICATION_ROLE_EVENTS	DDL_DATABASE_LEVEL_EVENTS
UserName	DDL_ASSEMBLY_EVENTS	DDL_DATABASE_LEVEL_EVENTS
UserName	DDL_ASYMMETRIC_KEY_EVENTS	DDL_DATABASE_LEVEL_EVENTS
UserName	DDL_AUTHORIZATION_DATABASE_EVENTS	DDL_DATABASE_LEVEL_EVENTS
UserName	DDL_BROKER_PRIORITY_EVENTS	DDL_DATABASE_LEVEL_EVENTS
UserName	DDL_CERTIFICATE_EVENTS	DDL_DATABASE_LEVEL_EVENTS
UserName	DDL_CONTRACT_EVENTS	DDL_DATABASE_LEVEL_EVENTS
UserName	DDL_CRYPTO_SIGNATURE_EVENTS	DDL_DATABASE_LEVEL_EVENTS
UserName	DDL_DATABASE_AUDIT_EVENTS	DDL_DATABASE_LEVEL_EVENTS
UserName	DDL_DATABASE_AUDIT_SPECIFICATION_EVENTS	DDL_DATABASE_LEVEL_EVENTS
UserName	DDL_DATABASE_ENCRYPTION_KEY_EVENTS	DDL_DATABASE_LEVEL_EVENTS
UserName	DDL_DATABASE_SECURITY_EVENTS	DDL_DATABASE_LEVEL_EVENTS
UserName	DDL_DEFAULT_EVENTS	DDL_DATABASE_LEVEL_EVENTS
UserName	DDL_EVENT_NOTIFICATION_EVENTS	DDL_DATABASE_LEVEL_EVENTS
UserName	DDL_EXTENDED_PROPERTY_EVENTS	DDL_DATABASE_LEVEL_EVENTS
UserName	DDL_FULLTEXT_CATALOG_EVENTS	DDL_DATABASE_LEVEL_EVENTS
UserName	DDL_FULLTEXT_STOPLIST_EVENTS	DDL_DATABASE_LEVEL_EVENTS
UserName	DDL_FUNCTION_EVENTS	DDL_DATABASE_LEVEL_EVENTS
UserName	DDL_GDR_DATABASE_EVENTS	DDL_DATABASE_LEVEL_EVENTS
UserName	DDL_INDEX_EVENTS	DDL_DATABASE_LEVEL_EVENTS
UserName	DDL_MASTER_KEY_EVENTS	DDL_DATABASE_LEVEL_EVENTS
UserName	DDL_MESSAGE_TYPE_EVENTS	DDL_DATABASE_LEVEL_EVENTS
UserName	DDL_PARTITION_EVENTS	DDL_DATABASE_LEVEL_EVENTS
UserName	DDL_PARTITION_FUNCTION_EVENTS	DDL_DATABASE_LEVEL_EVENTS
UserName	DDL_PARTITION_SCHEME_EVENTS	DDL_DATABASE_LEVEL_EVENTS
UserName	DDL_PLAN_GUIDE_EVENTS	DDL_DATABASE_LEVEL_EVENTS
UserName	DDL_PROCEDURE_EVENTS	DDL_DATABASE_LEVEL_EVENTS
UserName	DDL_QUEUE_EVENTS	DDL_DATABASE_LEVEL_EVENTS
UserName	DDL_REMOTE_SERVICE_BINDING_EVENTS	DDL_DATABASE_LEVEL_EVENTS
UserName	DDL_ROLE_EVENTS	DDL_DATABASE_LEVEL_EVENTS
UserName	DDL_ROUTE_EVENTS	DDL_DATABASE_LEVEL_EVENTS
UserName	DDL_RULE_EVENTS	DDL_DATABASE_LEVEL_EVENTS
UserName	DDL_SCHEMA_EVENTS	DDL_DATABASE_LEVEL_EVENTS
UserName	DDL_SEARCH_PROPERTY_LIST_EVENTS	DDL_DATABASE_LEVEL_EVENTS
UserName	DDL_SEQUENCE_EVENTS	DDL_DATABASE_LEVEL_EVENTS
UserName	DDL_SERVICE_EVENTS	DDL_DATABASE_LEVEL_EVENTS
UserName	DDL_SSB_EVENTS	DDL_DATABASE_LEVEL_EVENTS
UserName	DDL_STATISTICS_EVENTS	DDL_DATABASE_LEVEL_EVENTS
UserName	DDL_SYMMETRIC_KEY_EVENTS	DDL_DATABASE_LEVEL_EVENTS
UserName	DDL_SYNONYM_EVENTS	DDL_DATABASE_LEVEL_EVENTS
UserName	DDL_TABLE_EVENTS	DDL_DATABASE_LEVEL_EVENTS
UserName	DDL_TABLE_VIEW_EVENTS	DDL_DATABASE_LEVEL_EVENTS
UserName	DDL_TRIGGER_EVENTS	DDL_DATABASE_LEVEL_EVENTS
UserName	DDL_TYPE_EVENTS	DDL_DATABASE_LEVEL_EVENTS
UserName	DDL_USER_EVENTS	DDL_DATABASE_LEVEL_EVENTS
UserName	DDL_VIEW_EVENTS	DDL_DATABASE_LEVEL_EVENTS
UserName	DDL_XML_SCHEMA_COLLECTION_EVENTS	DDL_DATABASE_LEVEL_EVENTS
UserName	DENY_DATABASE	DDL_DATABASE_LEVEL_EVENTS
UserName	DROP_APPLICATION_ROLE	DDL_DATABASE_LEVEL_EVENTS
UserName	DROP_ASSEMBLY	DDL_DATABASE_LEVEL_EVENTS
UserName	DROP_ASYMMETRIC_KEY	DDL_DATABASE_LEVEL_EVENTS
UserName	DROP_AUDIT	DDL_DATABASE_LEVEL_EVENTS
UserName	DROP_BROKER_PRIORITY	DDL_DATABASE_LEVEL_EVENTS
UserName	DROP_CERTIFICATE	DDL_DATABASE_LEVEL_EVENTS
UserName	DROP_CONTRACT	DDL_DATABASE_LEVEL_EVENTS
UserName	DROP_DATABASE_AUDIT_SPECIFICATION	DDL_DATABASE_LEVEL_EVENTS
UserName	DROP_DATABASE_ENCRYPTION_KEY	DDL_DATABASE_LEVEL_EVENTS
UserName	DROP_DEFAULT	DDL_DATABASE_LEVEL_EVENTS
UserName	DROP_EVENT_NOTIFICATION	DDL_DATABASE_LEVEL_EVENTS
UserName	DROP_EXTENDED_PROPERTY	DDL_DATABASE_LEVEL_EVENTS
UserName	DROP_FULLTEXT_CATALOG	DDL_DATABASE_LEVEL_EVENTS
UserName	DROP_FULLTEXT_INDEX	DDL_DATABASE_LEVEL_EVENTS
UserName	DROP_FULLTEXT_STOPLIST	DDL_DATABASE_LEVEL_EVENTS
UserName	DROP_FUNCTION	DDL_DATABASE_LEVEL_EVENTS
UserName	DROP_INDEX	DDL_DATABASE_LEVEL_EVENTS
UserName	DROP_MASTER_KEY	DDL_DATABASE_LEVEL_EVENTS
UserName	DROP_MESSAGE_TYPE	DDL_DATABASE_LEVEL_EVENTS
UserName	DROP_PARTITION_FUNCTION	DDL_DATABASE_LEVEL_EVENTS
UserName	DROP_PARTITION_SCHEME	DDL_DATABASE_LEVEL_EVENTS
UserName	DROP_PLAN_GUIDE	DDL_DATABASE_LEVEL_EVENTS
UserName	DROP_PROCEDURE	DDL_DATABASE_LEVEL_EVENTS
UserName	DROP_QUEUE	DDL_DATABASE_LEVEL_EVENTS
UserName	DROP_REMOTE_SERVICE_BINDING	DDL_DATABASE_LEVEL_EVENTS
UserName	DROP_ROLE	DDL_DATABASE_LEVEL_EVENTS
UserName	DROP_ROLE_MEMBER	DDL_DATABASE_LEVEL_EVENTS
UserName	DROP_ROUTE	DDL_DATABASE_LEVEL_EVENTS
UserName	DROP_RULE	DDL_DATABASE_LEVEL_EVENTS
UserName	DROP_SCHEMA	DDL_DATABASE_LEVEL_EVENTS
UserName	DROP_SEARCH_PROPERTY_LIST	DDL_DATABASE_LEVEL_EVENTS
UserName	DROP_SEQUENCE	DDL_DATABASE_LEVEL_EVENTS
UserName	DROP_SERVICE	DDL_DATABASE_LEVEL_EVENTS
UserName	DROP_SIGNATURE	DDL_DATABASE_LEVEL_EVENTS
UserName	DROP_SIGNATURE_SCHEMA_OBJECT	DDL_DATABASE_LEVEL_EVENTS
UserName	DROP_STATISTICS	DDL_DATABASE_LEVEL_EVENTS
UserName	DROP_SYMMETRIC_KEY	DDL_DATABASE_LEVEL_EVENTS
UserName	DROP_SYNONYM	DDL_DATABASE_LEVEL_EVENTS
UserName	DROP_TABLE	DDL_DATABASE_LEVEL_EVENTS
UserName	DROP_TRIGGER	DDL_DATABASE_LEVEL_EVENTS
UserName	DROP_TYPE	DDL_DATABASE_LEVEL_EVENTS
UserName	DROP_USER	DDL_DATABASE_LEVEL_EVENTS
UserName	DROP_VIEW	DDL_DATABASE_LEVEL_EVENTS
UserName	DROP_XML_SCHEMA_COLLECTION	DDL_DATABASE_LEVEL_EVENTS
UserName	GRANT_DATABASE	DDL_DATABASE_LEVEL_EVENTS
UserName	RENAME	DDL_DATABASE_LEVEL_EVENTS
UserName	REVOKE_DATABASE	DDL_DATABASE_LEVEL_EVENTS
UserName	UNBIND_DEFAULT	DDL_DATABASE_LEVEL_EVENTS
UserName	UNBIND_RULE	DDL_DATABASE_LEVEL_EVENTS
UserName	UPDATE_STATISTICS	DDL_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

WUtils.com

Includes&Samples