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

SessionLoginName in other namespaces

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

propertyClassOrigin
SessionLoginNameTRC_ALL_EVENTSTRC_ALL_EVENTS

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

propertyClassOrigin
SessionLoginNameASSEMBLY_LOADTRC_ALL_EVENTS
SessionLoginNameAUDIT_ADD_DB_USER_EVENTTRC_ALL_EVENTS
SessionLoginNameAUDIT_ADD_LOGIN_TO_SERVER_ROLE_EVENTTRC_ALL_EVENTS
SessionLoginNameAUDIT_ADD_MEMBER_TO_DB_ROLE_EVENTTRC_ALL_EVENTS
SessionLoginNameAUDIT_ADD_ROLE_EVENTTRC_ALL_EVENTS
SessionLoginNameAUDIT_ADDLOGIN_EVENTTRC_ALL_EVENTS
SessionLoginNameAUDIT_APP_ROLE_CHANGE_PASSWORD_EVENTTRC_ALL_EVENTS
SessionLoginNameAUDIT_BACKUP_RESTORE_EVENTTRC_ALL_EVENTS
SessionLoginNameAUDIT_CHANGE_AUDIT_EVENTTRC_ALL_EVENTS
SessionLoginNameAUDIT_CHANGE_DATABASE_OWNERTRC_ALL_EVENTS
SessionLoginNameAUDIT_DATABASE_MANAGEMENT_EVENTTRC_ALL_EVENTS
SessionLoginNameAUDIT_DATABASE_OBJECT_ACCESS_EVENTTRC_ALL_EVENTS
SessionLoginNameAUDIT_DATABASE_OBJECT_GDR_EVENTTRC_ALL_EVENTS
SessionLoginNameAUDIT_DATABASE_OBJECT_MANAGEMENT_EVENTTRC_ALL_EVENTS
SessionLoginNameAUDIT_DATABASE_OBJECT_TAKE_OWNERSHIP_EVENTTRC_ALL_EVENTS
SessionLoginNameAUDIT_DATABASE_OPERATION_EVENTTRC_ALL_EVENTS
SessionLoginNameAUDIT_DATABASE_PRINCIPAL_IMPERSONATION_EVENTTRC_ALL_EVENTS
SessionLoginNameAUDIT_DATABASE_PRINCIPAL_MANAGEMENT_EVENTTRC_ALL_EVENTS
SessionLoginNameAUDIT_DATABASE_SCOPE_GDR_EVENTTRC_ALL_EVENTS
SessionLoginNameAUDIT_DBCC_EVENTTRC_ALL_EVENTS
SessionLoginNameAUDIT_FULLTEXTTRC_ALL_EVENTS
SessionLoginNameAUDIT_LOGINTRC_ALL_EVENTS
SessionLoginNameAUDIT_LOGIN_CHANGE_PASSWORD_EVENTTRC_ALL_EVENTS
SessionLoginNameAUDIT_LOGIN_CHANGE_PROPERTY_EVENTTRC_ALL_EVENTS
SessionLoginNameAUDIT_LOGIN_FAILEDTRC_ALL_EVENTS
SessionLoginNameAUDIT_LOGIN_GDR_EVENTTRC_ALL_EVENTS
SessionLoginNameAUDIT_LOGOUTTRC_ALL_EVENTS
SessionLoginNameAUDIT_SCHEMA_OBJECT_ACCESS_EVENTTRC_ALL_EVENTS
SessionLoginNameAUDIT_SCHEMA_OBJECT_GDR_EVENTTRC_ALL_EVENTS
SessionLoginNameAUDIT_SCHEMA_OBJECT_MANAGEMENT_EVENTTRC_ALL_EVENTS
SessionLoginNameAUDIT_SCHEMA_OBJECT_TAKE_OWNERSHIP_EVENTTRC_ALL_EVENTS
SessionLoginNameAUDIT_SERVER_ALTER_TRACE_EVENTTRC_ALL_EVENTS
SessionLoginNameAUDIT_SERVER_OBJECT_GDR_EVENTTRC_ALL_EVENTS
SessionLoginNameAUDIT_SERVER_OBJECT_MANAGEMENT_EVENTTRC_ALL_EVENTS
SessionLoginNameAUDIT_SERVER_OBJECT_TAKE_OWNERSHIP_EVENTTRC_ALL_EVENTS
SessionLoginNameAUDIT_SERVER_OPERATION_EVENTTRC_ALL_EVENTS
SessionLoginNameAUDIT_SERVER_PRINCIPAL_IMPERSONATION_EVENTTRC_ALL_EVENTS
SessionLoginNameAUDIT_SERVER_PRINCIPAL_MANAGEMENT_EVENTTRC_ALL_EVENTS
SessionLoginNameAUDIT_SERVER_SCOPE_GDR_EVENTTRC_ALL_EVENTS
SessionLoginNameBITMAP_WARNINGTRC_ALL_EVENTS
SessionLoginNameBLOCKED_PROCESS_REPORTTRC_ALL_EVENTS
SessionLoginNameCPU_THRESHOLD_EXCEEDEDTRC_ALL_EVENTS
SessionLoginNameDATA_FILE_AUTO_GROWTRC_ALL_EVENTS
SessionLoginNameDATA_FILE_AUTO_SHRINKTRC_ALL_EVENTS
SessionLoginNameDATABASE_MIRRORING_STATE_CHANGETRC_ALL_EVENTS
SessionLoginNameDATABASE_SUSPECT_DATA_PAGETRC_ALL_EVENTS
SessionLoginNameDEADLOCK_GRAPHTRC_ALL_EVENTS
SessionLoginNameDEPRECATION_ANNOUNCEMENTTRC_ALL_EVENTS
SessionLoginNameDEPRECATION_FINAL_SUPPORTTRC_ALL_EVENTS
SessionLoginNameERRORLOGTRC_ALL_EVENTS
SessionLoginNameEVENTLOGTRC_ALL_EVENTS
SessionLoginNameEXCEPTIONTRC_ALL_EVENTS
SessionLoginNameEXCHANGE_SPILL_EVENTTRC_ALL_EVENTS
SessionLoginNameEXECUTION_WARNINGSTRC_ALL_EVENTS
SessionLoginNameFT_CRAWL_ABORTEDTRC_ALL_EVENTS
SessionLoginNameFT_CRAWL_STARTEDTRC_ALL_EVENTS
SessionLoginNameFT_CRAWL_STOPPEDTRC_ALL_EVENTS
SessionLoginNameHASH_WARNINGTRC_ALL_EVENTS
SessionLoginNameLOCK_DEADLOCKTRC_ALL_EVENTS
SessionLoginNameLOCK_DEADLOCK_CHAINTRC_ALL_EVENTS
SessionLoginNameLOCK_ESCALATIONTRC_ALL_EVENTS
SessionLoginNameLOG_FILE_AUTO_GROWTRC_ALL_EVENTS
SessionLoginNameLOG_FILE_AUTO_SHRINKTRC_ALL_EVENTS
SessionLoginNameMISSING_COLUMN_STATISTICSTRC_ALL_EVENTS
SessionLoginNameMISSING_JOIN_PREDICATETRC_ALL_EVENTS
SessionLoginNameMOUNT_TAPETRC_ALL_EVENTS
SessionLoginNameOBJECT_ALTEREDTRC_ALL_EVENTS
SessionLoginNameOBJECT_CREATEDTRC_ALL_EVENTS
SessionLoginNameOBJECT_DELETEDTRC_ALL_EVENTS
SessionLoginNameOLEDB_CALL_EVENTTRC_ALL_EVENTS
SessionLoginNameOLEDB_DATAREAD_EVENTTRC_ALL_EVENTS
SessionLoginNameOLEDB_ERRORSTRC_ALL_EVENTS
SessionLoginNameOLEDB_PROVIDER_INFORMATIONTRC_ALL_EVENTS
SessionLoginNameOLEDB_QUERYINTERFACE_EVENTTRC_ALL_EVENTS
SessionLoginNameQN__DYNAMICSTRC_ALL_EVENTS
SessionLoginNameQN__PARAMETER_TABLETRC_ALL_EVENTS
SessionLoginNameQN__SUBSCRIPTIONTRC_ALL_EVENTS
SessionLoginNameQN__TEMPLATETRC_ALL_EVENTS
SessionLoginNameSERVER_MEMORY_CHANGETRC_ALL_EVENTS
SessionLoginNameSHOWPLAN_ALL_FOR_QUERY_COMPILETRC_ALL_EVENTS
SessionLoginNameSHOWPLAN_XMLTRC_ALL_EVENTS
SessionLoginNameSHOWPLAN_XML_FOR_QUERY_COMPILETRC_ALL_EVENTS
SessionLoginNameSHOWPLAN_XML_STATISTICS_PROFILETRC_ALL_EVENTS
SessionLoginNameSORT_WARNINGSTRC_ALL_EVENTS
SessionLoginNameSP_CACHEINSERTTRC_ALL_EVENTS
SessionLoginNameSP_CACHEMISSTRC_ALL_EVENTS
SessionLoginNameSP_CACHEREMOVETRC_ALL_EVENTS
SessionLoginNameSP_RECOMPILETRC_ALL_EVENTS
SessionLoginNameSQL_STMTRECOMPILETRC_ALL_EVENTS
SessionLoginNameTRACE_FILE_CLOSETRC_ALL_EVENTS
SessionLoginNameTRC_CLRTRC_ALL_EVENTS
SessionLoginNameTRC_DATABASETRC_ALL_EVENTS
SessionLoginNameTRC_DEPRECATIONTRC_ALL_EVENTS
SessionLoginNameTRC_ERRORS_AND_WARNINGSTRC_ALL_EVENTS
SessionLoginNameTRC_FULL_TEXTTRC_ALL_EVENTS
SessionLoginNameTRC_LOCKSTRC_ALL_EVENTS
SessionLoginNameTRC_OBJECTSTRC_ALL_EVENTS
SessionLoginNameTRC_OLEDBTRC_ALL_EVENTS
SessionLoginNameTRC_PERFORMANCETRC_ALL_EVENTS
SessionLoginNameTRC_QUERY_NOTIFICATIONSTRC_ALL_EVENTS
SessionLoginNameTRC_SECURITY_AUDITTRC_ALL_EVENTS
SessionLoginNameTRC_SERVERTRC_ALL_EVENTS
SessionLoginNameTRC_STORED_PROCEDURESTRC_ALL_EVENTS
SessionLoginNameTRC_TSQLTRC_ALL_EVENTS
SessionLoginNameTRC_USER_CONFIGURABLETRC_ALL_EVENTS
SessionLoginNameUSER_ERROR_MESSAGETRC_ALL_EVENTS
SessionLoginNameUSERCONFIGURABLE_0TRC_ALL_EVENTS
SessionLoginNameUSERCONFIGURABLE_1TRC_ALL_EVENTS
SessionLoginNameUSERCONFIGURABLE_2TRC_ALL_EVENTS
SessionLoginNameUSERCONFIGURABLE_3TRC_ALL_EVENTS
SessionLoginNameUSERCONFIGURABLE_4TRC_ALL_EVENTS
SessionLoginNameUSERCONFIGURABLE_5TRC_ALL_EVENTS
SessionLoginNameUSERCONFIGURABLE_6TRC_ALL_EVENTS
SessionLoginNameUSERCONFIGURABLE_7TRC_ALL_EVENTS
SessionLoginNameUSERCONFIGURABLE_8TRC_ALL_EVENTS
SessionLoginNameUSERCONFIGURABLE_9TRC_ALL_EVENTS
SessionLoginNameXQUERY_STATIC_TYPETRC_ALL_EVENTS

Code samples for SessionLoginName property

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

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


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