-
Recent Posts
Archives
Categories
Meta
Tag Archives: Login
How to find last login of users to Dynamics 365 On-Premise
SELECT ORG.FriendlyName as ‘Organization Name’, SU.Name as ‘User Name’ ,SUO.LastAccessTime as ‘Last Login’ FROM MSCRM_CONFIG.dbo.SystemUser SU INNER JOIN [MSCRM_CONFIG].[dbo].[SystemUserOrganizations] SUO ON SUO.UserId = SU.Id Inner Join [MSCRM_CONFIG].[dbo].[Organization] ORG on ORG.Id = SUO.OrganizationId INNER JOIN [MSCRM_CONFIG].[dbo].[SystemUserAuthentication] SUA ON SUA.UserId = SUO.UserId … Continue reading
Posted in CRM, Dynamics 365, Ms Dynamics CRM 2013, MS Dynamics CRM 2015, MS Dynamics CRM 2016
Tagged CRM, CRM 2016, Dynamics 365, Dynamics 365 Update 2, Dynamics CRM, Dynamics CRM 2015, Last Login, Last Login of User, Login, MS Dynamics, MS Dynamics 365, MS Dynamics CRM 2016, on-premise, SQL, SQL Server, User, Users
2 Comments