Jaa


Session Events Data Columns

The Session Events event category has the following event class:

  • Existing Connection class

The following table lists the data columns for this event class.

Existing Connection Event Class—Data Columns

Data Column Description

ConnectionID

Contains the unique connection ID associated with the existing connection event.

CurrentTime

Contains the current time of the existing connection event. For filtering, the formats are YYYY-MM-DD and YYYY-MM-DD HH:MM:SS.

NTUserName

Contains the Windows user name associated with the existing connection event.

SPID

Contains the server process ID (SPID) that uniquely identifies the user session associated with the existing connection event. The SPID directly corresponds to the session GUID used by XML for Analysis (XMLA).

StartTime

Contains the time (if available) at which the login event started. For filtering, the formats are YYYY-MM-DD and YYYY-MM-DD HH:MM:SS.

ApplicationName

Contains the name of the client application associated with the login event event.

ClientHostName

Contains the name of the computer at which the login event event occurred.

NTDomainName

Contains the Windows domain account associated with the login event.

See Also

Other Resources

Security Audit Event Category

Help and Information

Getting SQL Server 2005 Assistance