For getting a list of all last login date and time for all CRM users on Dynamics CRM (On-Premises), run below SQL script using SQL Server Management Studio :
SELECT SU.FullName ,SU.DomainName ,SUO.LastAccessTime FROM SystemUser SU INNER JOIN [MSCRM_CONFIG].[dbo].[SystemUserOrganizations] SUO ON SUO.CrmUserId = SU.SystemUserId INNER JOIN [MSCRM_CONFIG].[dbo].[SystemUserAuthentication] SUA ON SUA.UserId = SUO.UserId ORDER BY SUO.LastAccessTime DESC
its blank...last access time.
ReplyDelete