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
Member discussion