In general, we often requires to login CRM with multiple User accounts in multiple browser windows, also in parallel.Continue reading
Recently in Dynamics 365 On-premise Dev environment, accidentally System Admin user’s Business Unit changed and hence all the security roles lost along with System Administrator role.
In that Dev environment, we don’t have any other user with System Administrator security role.
So, followed the below steps and assigned the System Administrator role to the CRM System Admin user using SQL queries.
Note: Take the backup of CRM DB before following the below steps.
Step 1: Logged in SQL with CRM System Admin role and executed the below query and got the Default business unit GUID from the BusinessUnit Table.
PARENTBUSINESSUNITID IS NULL
Step 2: Executed the below query and got the CRM System Admin User GUID from the SystemUser table.
FULLNAME LIKE ‘%CRM ADMIN%’ — CRM ADMIN is the name of my System Admin’s Full name in the CRM dev organization.
Step 3: Updated the default business unit GUID for the System Admin user by using the below SQL Query.
BUSINESSUNITID = ‘6C9A857D-D43B-E411-93F9-000D3A800C9F’ — Refer Step 1.
WHERE SYSTEMUSERID=’F2368783-D43B-E411-93F9-000D3A800C9F’ — Refer Step 2.
Step 4: Executed the below query and got the below System Administrator Security role from Role Table.
NAME = ‘SYSTEM ADMINISTRATOR’ AND
CREATEDBY IS NULL
Step 5: Inserted the record in SystemUserRoles Table.
SYSTEMUSERROLES (SYSTEMUSERID, ROLEID)
–First Parameter is SYSTEMUSERID. Refer Step 2
–Second parameter is ROLEID. Refer Step 4
Step 6: Reset IIS. Logged in CRM with System Admin User and it worked.
Hope this article helped you and share your valuable feedback on this article.
Announcements in Dynamics CRM are used to broadcast the important news to all the system users in an Organization.
Use the below code to get the Dynamics CRM Version number using CRM SDK and Console Application C#.
RetrieveVersionRequest request = new RetrieveVersionRequest();
RetrieveVersionResponse response = (RetrieveVersionResponse)organizationService.Execute(request);Version version = new Version(response.Version);
This feature was released in Microsoft Dynamics CRM 2015 Online Update 1(v7.1) and will work perfectly in the below CRM versionsDynamics 365 (online), Dynamics 365 (on-premises), Dynamics CRM 2016,
Dynamics CRM Online
Run the below query to get all the users details under all the Teams available in CRMS.
Team.name [Team Name],
SysUser.Fullname [User Name],
SysUser.mobilephone [Mobile Phone],
SysUser.internalemailaddress [Primary Email]
on SysUser.Systemuserid = TeamMem.Systemuserid
Inner join dbo.FilteredTeam Team
on Team.TeamID = TeamMem.TeamID
–where Team.name in –Uncomment this where condition to specify the required Team names
order by Team.NAME