Capture Logon Trigger Event Data

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)yesAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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:

<EVENT_INSTANCE>

<EventType>event_type</EventType>

<PostTime>post_time</PostTime>

<SPID>spid</SPID>

<ServerName>server_name</ServerName>

<LoginName>login_name</LoginName>

<LoginType>login_type</LoginType>

<SID>sid</SID>

<ClientHost>client_host</ClientHost>

<IsPooled>is_pooled</IsPooled>

</EVENT_INSTANCE>

<EventType>
Contains LOGON.

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

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

<ClientHost>
Contains the host name of the client from where the connection is made. The value is '<local_machine>' if the client and server name are the same. Otherwise, the value is the IP address of the client.

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