#MSSQL #Research #Users Check error log for last user login

last_user_login.sql

DECLARE @temp_error_log TABLE
(
 date datetime,
 process varchar(50) null,
 text varchar(MAX) null
)

INSERT INTO @temp_error_log
EXEC sp_readerrorlog 0, 1, 'Login'

SELECT DISTINCT MAX(date) as 'date', text as 'activity' FROM @temp_error_log
WHERE process = 'Logon'
GROUP BY text, process
ORDER BY MAX(date) desc