techdioadmin

Techdio Admin

About Techdio Admin

This author has not yet filled in any details.
So far Techdio Admin has created 1 blog entries.

SQL Query to get Users last log-in date from MSCRM

2018-07-04T09:29:35+00:00

Execute this command against your MSCRM database (onpremise only) select us.FullName, max(a.CreatedOn) as LastLoginDate from Audit a inner join SystemUser us on a.ObjectId = us.SystemUserId where a.Operation = 4 and us.IsDisabled = 0 group by us.FullName

SQL Query to get Users last log-in date from MSCRM 2018-07-04T09:29:35+00:00