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

ClientProcessID in other namespaces

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

propertyClassOrigin
ClientProcessIDASSEMBLY_LOADASSEMBLY_LOAD
ClientProcessIDAUDIT_ADD_DB_USER_EVENTAUDIT_ADD_DB_USER_EVENT
ClientProcessIDAUDIT_ADD_LOGIN_TO_SERVER_ROLE_EVENTAUDIT_ADD_LOGIN_TO_SERVER_ROLE_EVENT
ClientProcessIDAUDIT_ADD_MEMBER_TO_DB_ROLE_EVENTAUDIT_ADD_MEMBER_TO_DB_ROLE_EVENT
ClientProcessIDAUDIT_ADD_ROLE_EVENTAUDIT_ADD_ROLE_EVENT
ClientProcessIDAUDIT_ADDLOGIN_EVENTAUDIT_ADDLOGIN_EVENT
ClientProcessIDAUDIT_APP_ROLE_CHANGE_PASSWORD_EVENTAUDIT_APP_ROLE_CHANGE_PASSWORD_EVENT
ClientProcessIDAUDIT_BACKUP_RESTORE_EVENTAUDIT_BACKUP_RESTORE_EVENT
ClientProcessIDAUDIT_CHANGE_AUDIT_EVENTAUDIT_CHANGE_AUDIT_EVENT
ClientProcessIDAUDIT_CHANGE_DATABASE_OWNERAUDIT_CHANGE_DATABASE_OWNER
ClientProcessIDAUDIT_DATABASE_OBJECT_GDR_EVENTAUDIT_DATABASE_OBJECT_GDR_EVENT
ClientProcessIDAUDIT_DATABASE_SCOPE_GDR_EVENTAUDIT_DATABASE_SCOPE_GDR_EVENT
ClientProcessIDAUDIT_DBCC_EVENTAUDIT_DBCC_EVENT
ClientProcessIDAUDIT_LOGINAUDIT_LOGIN
ClientProcessIDAUDIT_LOGIN_CHANGE_PASSWORD_EVENTAUDIT_LOGIN_CHANGE_PASSWORD_EVENT
ClientProcessIDAUDIT_LOGIN_CHANGE_PROPERTY_EVENTAUDIT_LOGIN_CHANGE_PROPERTY_EVENT
ClientProcessIDAUDIT_LOGIN_FAILEDAUDIT_LOGIN_FAILED
ClientProcessIDAUDIT_LOGIN_GDR_EVENTAUDIT_LOGIN_GDR_EVENT
ClientProcessIDAUDIT_LOGOUTAUDIT_LOGOUT
ClientProcessIDAUDIT_SCHEMA_OBJECT_ACCESS_EVENTAUDIT_SCHEMA_OBJECT_ACCESS_EVENT
ClientProcessIDAUDIT_SCHEMA_OBJECT_GDR_EVENTAUDIT_SCHEMA_OBJECT_GDR_EVENT
ClientProcessIDAUDIT_SERVER_OBJECT_GDR_EVENTAUDIT_SERVER_OBJECT_GDR_EVENT
ClientProcessIDAUDIT_SERVER_OBJECT_MANAGEMENT_EVENTAUDIT_SERVER_OBJECT_MANAGEMENT_EVENT
ClientProcessIDAUDIT_SERVER_PRINCIPAL_MANAGEMENT_EVENTAUDIT_SERVER_PRINCIPAL_MANAGEMENT_EVENT
ClientProcessIDAUDIT_SERVER_SCOPE_GDR_EVENTAUDIT_SERVER_SCOPE_GDR_EVENT
ClientProcessIDBITMAP_WARNINGBITMAP_WARNING
ClientProcessIDDATA_FILE_AUTO_GROWDATA_FILE_AUTO_GROW
ClientProcessIDDATA_FILE_AUTO_SHRINKDATA_FILE_AUTO_SHRINK
ClientProcessIDERRORLOGERRORLOG
ClientProcessIDEVENTLOGEVENTLOG
ClientProcessIDEXCEPTIONEXCEPTION
ClientProcessIDEXCHANGE_SPILL_EVENTEXCHANGE_SPILL_EVENT
ClientProcessIDEXECUTION_WARNINGSEXECUTION_WARNINGS
ClientProcessIDHASH_WARNINGHASH_WARNING
ClientProcessIDLOCK_DEADLOCKLOCK_DEADLOCK
ClientProcessIDLOCK_ESCALATIONLOCK_ESCALATION
ClientProcessIDLOG_FILE_AUTO_GROWLOG_FILE_AUTO_GROW
ClientProcessIDLOG_FILE_AUTO_SHRINKLOG_FILE_AUTO_SHRINK
ClientProcessIDMISSING_COLUMN_STATISTICSMISSING_COLUMN_STATISTICS
ClientProcessIDMISSING_JOIN_PREDICATEMISSING_JOIN_PREDICATE
ClientProcessIDMOUNT_TAPEMOUNT_TAPE
ClientProcessIDSORT_WARNINGSSORT_WARNINGS
ClientProcessIDTRC_DEPRECATIONTRC_DEPRECATION
ClientProcessIDTRC_OBJECTSTRC_OBJECTS
ClientProcessIDTRC_OLEDBTRC_OLEDB
ClientProcessIDTRC_PERFORMANCETRC_PERFORMANCE
ClientProcessIDTRC_QUERY_NOTIFICATIONSTRC_QUERY_NOTIFICATIONS
ClientProcessIDTRC_STORED_PROCEDURESTRC_STORED_PROCEDURES
ClientProcessIDTRC_TSQLTRC_TSQL
ClientProcessIDTRC_USER_CONFIGURABLETRC_USER_CONFIGURABLE
ClientProcessIDUSER_ERROR_MESSAGEUSER_ERROR_MESSAGE

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

propertyClassOrigin
ClientProcessIDDEPRECATION_ANNOUNCEMENTTRC_DEPRECATION
ClientProcessIDDEPRECATION_FINAL_SUPPORTTRC_DEPRECATION
ClientProcessIDOBJECT_ALTEREDTRC_OBJECTS
ClientProcessIDOBJECT_CREATEDTRC_OBJECTS
ClientProcessIDOBJECT_DELETEDTRC_OBJECTS
ClientProcessIDOLEDB_CALL_EVENTTRC_OLEDB
ClientProcessIDOLEDB_DATAREAD_EVENTTRC_OLEDB
ClientProcessIDOLEDB_ERRORSTRC_OLEDB
ClientProcessIDOLEDB_PROVIDER_INFORMATIONTRC_OLEDB
ClientProcessIDOLEDB_QUERYINTERFACE_EVENTTRC_OLEDB
ClientProcessIDQN__DYNAMICSTRC_QUERY_NOTIFICATIONS
ClientProcessIDQN__PARAMETER_TABLETRC_QUERY_NOTIFICATIONS
ClientProcessIDQN__SUBSCRIPTIONTRC_QUERY_NOTIFICATIONS
ClientProcessIDQN__TEMPLATETRC_QUERY_NOTIFICATIONS
ClientProcessIDSHOWPLAN_ALL_FOR_QUERY_COMPILETRC_PERFORMANCE
ClientProcessIDSHOWPLAN_XMLTRC_PERFORMANCE
ClientProcessIDSHOWPLAN_XML_FOR_QUERY_COMPILETRC_PERFORMANCE
ClientProcessIDSHOWPLAN_XML_STATISTICS_PROFILETRC_PERFORMANCE
ClientProcessIDSP_CACHEINSERTTRC_STORED_PROCEDURES
ClientProcessIDSP_CACHEMISSTRC_STORED_PROCEDURES
ClientProcessIDSP_CACHEREMOVETRC_STORED_PROCEDURES
ClientProcessIDSP_RECOMPILETRC_STORED_PROCEDURES
ClientProcessIDSQL_STMTRECOMPILETRC_TSQL
ClientProcessIDUSERCONFIGURABLE_0TRC_USER_CONFIGURABLE
ClientProcessIDUSERCONFIGURABLE_1TRC_USER_CONFIGURABLE
ClientProcessIDUSERCONFIGURABLE_2TRC_USER_CONFIGURABLE
ClientProcessIDUSERCONFIGURABLE_3TRC_USER_CONFIGURABLE
ClientProcessIDUSERCONFIGURABLE_4TRC_USER_CONFIGURABLE
ClientProcessIDUSERCONFIGURABLE_5TRC_USER_CONFIGURABLE
ClientProcessIDUSERCONFIGURABLE_6TRC_USER_CONFIGURABLE
ClientProcessIDUSERCONFIGURABLE_7TRC_USER_CONFIGURABLE
ClientProcessIDUSERCONFIGURABLE_8TRC_USER_CONFIGURABLE
ClientProcessIDUSERCONFIGURABLE_9TRC_USER_CONFIGURABLE
ClientProcessIDXQUERY_STATIC_TYPETRC_TSQL

Code samples for ClientProcessID property

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

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


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