Dynamics CRM Users

NOTE: The information in this article is not from an official Microsoft source. It is the result of my own research. I have not conclusively verified any of the content. The article is for reference only.

Organizations are stored in MSCRM_CONFIG.dbo.Organization

Tables in MSCRM_CONFIG

Table	Notes
SystemUser	Any user that has been added to any organization in the deployment.
SystemUserRoles	Has an entry for each users that is currently a deployment administrator. Links to the SecurityRole table with SecurityRoleId
SystemUserAuthentication	Any user that has been added to any organization in the deployment.
SystemUserOrganizations	Has an entry for each user/organization combination. Users are referenced by UserId (in SystemUserAuthentication) and CRMUserId (in each org db?)

SystemUser table

Column	Notes
DefaultOrganizationId	The value is 00000000-0000-0000-0000-000000000000 for users that are deployment administrators
Id	Unique identifier for the table
Name	Seems to be null except for deployment administrators

SystemUserAuthentication table

Column	Notes
Authinfo	SID for Windows Account
Id	Unique identifier for table
UserID	Links to SystemUser, SystemUserOrganizations

Use

wmic useraccount get name, sid

at the command prompt to retrieve SIDs

Tables in Org_MSCRM

Table	Notes
SystemUserBase	Any user that has been added to any organization. The SystemUserId column maps to CRMUserId in MSCRM_CONFIG.dbo.SystemUserOrganizations. Curiously there is a field named ActiveDirectoryGuid (MSCRMCONFIG.dbo.SystemUserAuthentication has SID details)

Add Multiple Users

Select Authentication Provider

• Active Directory

• Federated Identity Provider