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

TextData in other namespaces

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

propertyClassOrigin
TextDataASSEMBLY_LOADASSEMBLY_LOAD
TextDataAUDIT_ADD_LOGIN_TO_SERVER_ROLE_EVENTAUDIT_ADD_LOGIN_TO_SERVER_ROLE_EVENT
TextDataAUDIT_ADD_MEMBER_TO_DB_ROLE_EVENTAUDIT_ADD_MEMBER_TO_DB_ROLE_EVENT
TextDataAUDIT_APP_ROLE_CHANGE_PASSWORD_EVENTAUDIT_APP_ROLE_CHANGE_PASSWORD_EVENT
TextDataAUDIT_BACKUP_RESTORE_EVENTAUDIT_BACKUP_RESTORE_EVENT
TextDataAUDIT_CHANGE_AUDIT_EVENTAUDIT_CHANGE_AUDIT_EVENT
TextDataAUDIT_CHANGE_DATABASE_OWNERAUDIT_CHANGE_DATABASE_OWNER
TextDataAUDIT_DATABASE_MANAGEMENT_EVENTAUDIT_DATABASE_MANAGEMENT_EVENT
TextDataAUDIT_DATABASE_OBJECT_ACCESS_EVENTAUDIT_DATABASE_OBJECT_ACCESS_EVENT
TextDataAUDIT_DATABASE_OBJECT_GDR_EVENTAUDIT_DATABASE_OBJECT_GDR_EVENT
TextDataAUDIT_DATABASE_OBJECT_MANAGEMENT_EVENTAUDIT_DATABASE_OBJECT_MANAGEMENT_EVENT
TextDataAUDIT_DATABASE_OBJECT_TAKE_OWNERSHIP_EVENTAUDIT_DATABASE_OBJECT_TAKE_OWNERSHIP_EVENT
TextDataAUDIT_DATABASE_OPERATION_EVENTAUDIT_DATABASE_OPERATION_EVENT
TextDataAUDIT_DATABASE_PRINCIPAL_IMPERSONATION_EVENTAUDIT_DATABASE_PRINCIPAL_IMPERSONATION_EVENT
TextDataAUDIT_DATABASE_PRINCIPAL_MANAGEMENT_EVENTAUDIT_DATABASE_PRINCIPAL_MANAGEMENT_EVENT
TextDataAUDIT_DATABASE_SCOPE_GDR_EVENTAUDIT_DATABASE_SCOPE_GDR_EVENT
TextDataAUDIT_DBCC_EVENTAUDIT_DBCC_EVENT
TextDataAUDIT_FULLTEXTAUDIT_FULLTEXT
TextDataAUDIT_LOGINAUDIT_LOGIN
TextDataAUDIT_LOGIN_CHANGE_PASSWORD_EVENTAUDIT_LOGIN_CHANGE_PASSWORD_EVENT
TextDataAUDIT_LOGIN_CHANGE_PROPERTY_EVENTAUDIT_LOGIN_CHANGE_PROPERTY_EVENT
TextDataAUDIT_LOGIN_FAILEDAUDIT_LOGIN_FAILED
TextDataAUDIT_SCHEMA_OBJECT_ACCESS_EVENTAUDIT_SCHEMA_OBJECT_ACCESS_EVENT
TextDataAUDIT_SCHEMA_OBJECT_GDR_EVENTAUDIT_SCHEMA_OBJECT_GDR_EVENT
TextDataAUDIT_SCHEMA_OBJECT_MANAGEMENT_EVENTAUDIT_SCHEMA_OBJECT_MANAGEMENT_EVENT
TextDataAUDIT_SCHEMA_OBJECT_TAKE_OWNERSHIP_EVENTAUDIT_SCHEMA_OBJECT_TAKE_OWNERSHIP_EVENT
TextDataAUDIT_SERVER_ALTER_TRACE_EVENTAUDIT_SERVER_ALTER_TRACE_EVENT
TextDataAUDIT_SERVER_OBJECT_GDR_EVENTAUDIT_SERVER_OBJECT_GDR_EVENT
TextDataAUDIT_SERVER_OBJECT_MANAGEMENT_EVENTAUDIT_SERVER_OBJECT_MANAGEMENT_EVENT
TextDataAUDIT_SERVER_OBJECT_TAKE_OWNERSHIP_EVENTAUDIT_SERVER_OBJECT_TAKE_OWNERSHIP_EVENT
TextDataAUDIT_SERVER_OPERATION_EVENTAUDIT_SERVER_OPERATION_EVENT
TextDataAUDIT_SERVER_PRINCIPAL_IMPERSONATION_EVENTAUDIT_SERVER_PRINCIPAL_IMPERSONATION_EVENT
TextDataAUDIT_SERVER_PRINCIPAL_MANAGEMENT_EVENTAUDIT_SERVER_PRINCIPAL_MANAGEMENT_EVENT
TextDataAUDIT_SERVER_SCOPE_GDR_EVENTAUDIT_SERVER_SCOPE_GDR_EVENT
TextDataBLOCKED_PROCESS_REPORTBLOCKED_PROCESS_REPORT
TextDataDATABASE_MIRRORING_STATE_CHANGEDATABASE_MIRRORING_STATE_CHANGE
TextDataERRORLOGERRORLOG
TextDataEVENTLOGEVENTLOG
TextDataEXCEPTIONEXCEPTION
TextDataEXECUTION_WARNINGSEXECUTION_WARNINGS
TextDataFT_CRAWL_STARTEDFT_CRAWL_STARTED
TextDataMISSING_COLUMN_STATISTICSMISSING_COLUMN_STATISTICS
TextDataMOUNT_TAPEMOUNT_TAPE
TextDataSHOWPLAN_XMLSHOWPLAN_XML
TextDataSHOWPLAN_XML_FOR_QUERY_COMPILESHOWPLAN_XML_FOR_QUERY_COMPILE
TextDataSHOWPLAN_XML_STATISTICS_PROFILESHOWPLAN_XML_STATISTICS_PROFILE
TextDataTRC_DEPRECATIONTRC_DEPRECATION
TextDataTRC_LOCKSTRC_LOCKS
TextDataTRC_OLEDBTRC_OLEDB
TextDataTRC_QUERY_NOTIFICATIONSTRC_QUERY_NOTIFICATIONS
TextDataTRC_STORED_PROCEDURESTRC_STORED_PROCEDURES
TextDataTRC_TSQLTRC_TSQL
TextDataTRC_USER_CONFIGURABLETRC_USER_CONFIGURABLE
TextDataUSER_ERROR_MESSAGEUSER_ERROR_MESSAGE

Code samples for TextData property

The class AUDIT_SERVER_SCOPE_GDR_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_SERVER_SCOPE_GDR_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_SERVER_SCOPE_GDR_EVENT")

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


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