Description
Retrieves user login activity, including attempts, sessions, application, and version.
Query :
Retrieves user login activity, including attempts, sessions, application, and version.
Query :
SELECT SU.UserName,UserRole,ClientName,Country,LoginAttempt,L.ActionStatus,L.LoginSessionId,LoginTimestampUTC,LastUsed,AppVersion,L.LoginSource FROM vwLoginActivityStatusList L inner join Security_User SU with (nolock) on L.userID = SU.UserID Where L.AppVersion <> '' and L.LoginAttempt >= '2026-07-01' and L.ClientId = '306' and SU.Username = 'JACOB.WINSTEAD@US.NESTLE.COM' order by L.LoginTimestampUTC asc