Tag Archives: Dynamics CRM 2015

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 →