Check users against MSCRM_CONFIG database for invalid user id error #sql #crm

orgquery.sql

use [ORGANIZATIONNAME_MSCRM];

select crm.FullName
from SystemUser crm
where crm.IsDisabled = 0
	and not exists
	(
		select crm.SystemUserId
		from MSCRM_CONFIG.dbo.SystemUserOrganizations config 
			join MSCRM_CONFIG.dbo.Organization org
				on org.Id = config.OrganizationId
		where crm.SystemUserId = config.CrmUserId
	)
order by crm.FullName asc