SELECT login_name [Login] , MAX(login_time) AS [Last Login Time]
FROM sys.dm_exec_sessions
GROUP BY login_name;
Query this table:
sys.dm_exec_sessions
Info from https://stackoverflow.com/questions/47905406/sql-server-2016-how-to-get-last-logged-in-date-for-user
|