sys.dm_exec_sessions

It fires in response to LOGON events of SQL Server is raised .

A LOGON Triggers can be useful in may ways, such as to restrict number of connection made by a Login or to prevent a user from logging-in outside .