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

LoginSid in other namespaces

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

propertyClassOrigin
LoginSidASSEMBLY_LOADASSEMBLY_LOAD
LoginSidAUDIT_ADD_DB_USER_EVENTAUDIT_ADD_DB_USER_EVENT
LoginSidAUDIT_ADD_LOGIN_TO_SERVER_ROLE_EVENTAUDIT_ADD_LOGIN_TO_SERVER_ROLE_EVENT
LoginSidAUDIT_ADD_MEMBER_TO_DB_ROLE_EVENTAUDIT_ADD_MEMBER_TO_DB_ROLE_EVENT
LoginSidAUDIT_ADD_ROLE_EVENTAUDIT_ADD_ROLE_EVENT
LoginSidAUDIT_ADDLOGIN_EVENTAUDIT_ADDLOGIN_EVENT
LoginSidAUDIT_APP_ROLE_CHANGE_PASSWORD_EVENTAUDIT_APP_ROLE_CHANGE_PASSWORD_EVENT
LoginSidAUDIT_BACKUP_RESTORE_EVENTAUDIT_BACKUP_RESTORE_EVENT
LoginSidAUDIT_CHANGE_AUDIT_EVENTAUDIT_CHANGE_AUDIT_EVENT
LoginSidAUDIT_CHANGE_DATABASE_OWNERAUDIT_CHANGE_DATABASE_OWNER
LoginSidAUDIT_DATABASE_MANAGEMENT_EVENTAUDIT_DATABASE_MANAGEMENT_EVENT
LoginSidAUDIT_DATABASE_OBJECT_ACCESS_EVENTAUDIT_DATABASE_OBJECT_ACCESS_EVENT
LoginSidAUDIT_DATABASE_OBJECT_GDR_EVENTAUDIT_DATABASE_OBJECT_GDR_EVENT
LoginSidAUDIT_DATABASE_OBJECT_MANAGEMENT_EVENTAUDIT_DATABASE_OBJECT_MANAGEMENT_EVENT
LoginSidAUDIT_DATABASE_OBJECT_TAKE_OWNERSHIP_EVENTAUDIT_DATABASE_OBJECT_TAKE_OWNERSHIP_EVENT
LoginSidAUDIT_DATABASE_OPERATION_EVENTAUDIT_DATABASE_OPERATION_EVENT
LoginSidAUDIT_DATABASE_PRINCIPAL_IMPERSONATION_EVENTAUDIT_DATABASE_PRINCIPAL_IMPERSONATION_EVENT
LoginSidAUDIT_DATABASE_PRINCIPAL_MANAGEMENT_EVENTAUDIT_DATABASE_PRINCIPAL_MANAGEMENT_EVENT
LoginSidAUDIT_DATABASE_SCOPE_GDR_EVENTAUDIT_DATABASE_SCOPE_GDR_EVENT
LoginSidAUDIT_DBCC_EVENTAUDIT_DBCC_EVENT
LoginSidAUDIT_LOGINAUDIT_LOGIN
LoginSidAUDIT_LOGIN_CHANGE_PASSWORD_EVENTAUDIT_LOGIN_CHANGE_PASSWORD_EVENT
LoginSidAUDIT_LOGIN_CHANGE_PROPERTY_EVENTAUDIT_LOGIN_CHANGE_PROPERTY_EVENT
LoginSidAUDIT_LOGIN_GDR_EVENTAUDIT_LOGIN_GDR_EVENT
LoginSidAUDIT_LOGOUTAUDIT_LOGOUT
LoginSidAUDIT_SCHEMA_OBJECT_ACCESS_EVENTAUDIT_SCHEMA_OBJECT_ACCESS_EVENT
LoginSidAUDIT_SCHEMA_OBJECT_GDR_EVENTAUDIT_SCHEMA_OBJECT_GDR_EVENT
LoginSidAUDIT_SCHEMA_OBJECT_MANAGEMENT_EVENTAUDIT_SCHEMA_OBJECT_MANAGEMENT_EVENT
LoginSidAUDIT_SCHEMA_OBJECT_TAKE_OWNERSHIP_EVENTAUDIT_SCHEMA_OBJECT_TAKE_OWNERSHIP_EVENT
LoginSidAUDIT_SERVER_ALTER_TRACE_EVENTAUDIT_SERVER_ALTER_TRACE_EVENT
LoginSidAUDIT_SERVER_OBJECT_GDR_EVENTAUDIT_SERVER_OBJECT_GDR_EVENT
LoginSidAUDIT_SERVER_OBJECT_MANAGEMENT_EVENTAUDIT_SERVER_OBJECT_MANAGEMENT_EVENT
LoginSidAUDIT_SERVER_OBJECT_TAKE_OWNERSHIP_EVENTAUDIT_SERVER_OBJECT_TAKE_OWNERSHIP_EVENT
LoginSidAUDIT_SERVER_OPERATION_EVENTAUDIT_SERVER_OPERATION_EVENT
LoginSidAUDIT_SERVER_PRINCIPAL_IMPERSONATION_EVENTAUDIT_SERVER_PRINCIPAL_IMPERSONATION_EVENT
LoginSidAUDIT_SERVER_PRINCIPAL_MANAGEMENT_EVENTAUDIT_SERVER_PRINCIPAL_MANAGEMENT_EVENT
LoginSidAUDIT_SERVER_SCOPE_GDR_EVENTAUDIT_SERVER_SCOPE_GDR_EVENT
LoginSidBITMAP_WARNINGBITMAP_WARNING
LoginSidBLOCKED_PROCESS_REPORTBLOCKED_PROCESS_REPORT
LoginSidCPU_THRESHOLD_EXCEEDEDCPU_THRESHOLD_EXCEEDED
LoginSidERRORLOGERRORLOG
LoginSidEVENTLOGEVENTLOG
LoginSidEXCEPTIONEXCEPTION
LoginSidEXCHANGE_SPILL_EVENTEXCHANGE_SPILL_EVENT
LoginSidEXECUTION_WARNINGSEXECUTION_WARNINGS
LoginSidHASH_WARNINGHASH_WARNING
LoginSidMISSING_COLUMN_STATISTICSMISSING_COLUMN_STATISTICS
LoginSidMISSING_JOIN_PREDICATEMISSING_JOIN_PREDICATE
LoginSidSORT_WARNINGSSORT_WARNINGS
LoginSidTRC_DATABASETRC_DATABASE
LoginSidTRC_DEPRECATIONTRC_DEPRECATION
LoginSidTRC_LOCKSTRC_LOCKS
LoginSidTRC_OBJECTSTRC_OBJECTS
LoginSidTRC_OLEDBTRC_OLEDB
LoginSidTRC_PERFORMANCETRC_PERFORMANCE
LoginSidTRC_QUERY_NOTIFICATIONSTRC_QUERY_NOTIFICATIONS
LoginSidTRC_STORED_PROCEDURESTRC_STORED_PROCEDURES
LoginSidTRC_TSQLTRC_TSQL
LoginSidTRC_USER_CONFIGURABLETRC_USER_CONFIGURABLE
LoginSidUSER_ERROR_MESSAGEUSER_ERROR_MESSAGE

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

propertyClassOrigin
LoginSidDATA_FILE_AUTO_GROWTRC_DATABASE
LoginSidDATA_FILE_AUTO_SHRINKTRC_DATABASE
LoginSidDATABASE_MIRRORING_STATE_CHANGETRC_DATABASE
LoginSidDEADLOCK_GRAPHTRC_LOCKS
LoginSidDEPRECATION_ANNOUNCEMENTTRC_DEPRECATION
LoginSidDEPRECATION_FINAL_SUPPORTTRC_DEPRECATION
LoginSidLOCK_DEADLOCKTRC_LOCKS
LoginSidLOCK_DEADLOCK_CHAINTRC_LOCKS
LoginSidLOCK_ESCALATIONTRC_LOCKS
LoginSidLOG_FILE_AUTO_GROWTRC_DATABASE
LoginSidLOG_FILE_AUTO_SHRINKTRC_DATABASE
LoginSidOBJECT_ALTEREDTRC_OBJECTS
LoginSidOBJECT_CREATEDTRC_OBJECTS
LoginSidOBJECT_DELETEDTRC_OBJECTS
LoginSidOLEDB_CALL_EVENTTRC_OLEDB
LoginSidOLEDB_DATAREAD_EVENTTRC_OLEDB
LoginSidOLEDB_ERRORSTRC_OLEDB
LoginSidOLEDB_PROVIDER_INFORMATIONTRC_OLEDB
LoginSidOLEDB_QUERYINTERFACE_EVENTTRC_OLEDB
LoginSidQN__DYNAMICSTRC_QUERY_NOTIFICATIONS
LoginSidQN__PARAMETER_TABLETRC_QUERY_NOTIFICATIONS
LoginSidQN__SUBSCRIPTIONTRC_QUERY_NOTIFICATIONS
LoginSidQN__TEMPLATETRC_QUERY_NOTIFICATIONS
LoginSidSHOWPLAN_ALL_FOR_QUERY_COMPILETRC_PERFORMANCE
LoginSidSHOWPLAN_XMLTRC_PERFORMANCE
LoginSidSHOWPLAN_XML_FOR_QUERY_COMPILETRC_PERFORMANCE
LoginSidSHOWPLAN_XML_STATISTICS_PROFILETRC_PERFORMANCE
LoginSidSP_CACHEINSERTTRC_STORED_PROCEDURES
LoginSidSP_CACHEMISSTRC_STORED_PROCEDURES
LoginSidSP_CACHEREMOVETRC_STORED_PROCEDURES
LoginSidSP_RECOMPILETRC_STORED_PROCEDURES
LoginSidSQL_STMTRECOMPILETRC_TSQL
LoginSidUSERCONFIGURABLE_0TRC_USER_CONFIGURABLE
LoginSidUSERCONFIGURABLE_1TRC_USER_CONFIGURABLE
LoginSidUSERCONFIGURABLE_2TRC_USER_CONFIGURABLE
LoginSidUSERCONFIGURABLE_3TRC_USER_CONFIGURABLE
LoginSidUSERCONFIGURABLE_4TRC_USER_CONFIGURABLE
LoginSidUSERCONFIGURABLE_5TRC_USER_CONFIGURABLE
LoginSidUSERCONFIGURABLE_6TRC_USER_CONFIGURABLE
LoginSidUSERCONFIGURABLE_7TRC_USER_CONFIGURABLE
LoginSidUSERCONFIGURABLE_8TRC_USER_CONFIGURABLE
LoginSidUSERCONFIGURABLE_9TRC_USER_CONFIGURABLE
LoginSidXQUERY_STATIC_TYPETRC_TSQL

Code samples for LoginSid property

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

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


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