Capture Logon Trigger Event Data

To capture XML data about LOGON events for use inside logon triggers, use the EVENTDATA function. The LOGON event returns the following event data schema:













Contains LOGON.


Contains the time when a session is requested to be established.


Contains the base 64-encoded binary stream of the security identification number (SID) for the specified login name.


Contains the host name of the client from where the connection is made. The value is '&lt;local_machine&gt;' if the client and server name are the same. Otherwise, the value is the IP address of the client.


Is 1 if the connection is reused by using connection pooling. Otherwise, the value is 0.

Community Additions