Microsoft Dynamics CRM (Archived)

User name and their roles

(0) Share

Report

Posted on by sandeepc

5,494

How to get an User name (first and last) and their roles within CRM. where i have only read only access in prod CRM

*This post is locked for comments

I have the same question (0)

All responses (18)

Answers (6)

sandeepc 5,494 on at

Like (0)

Report

RE: User name and their roles

i need an security role

Was this reply helpful? Yes No
Akanksha Ranjan 460 on at

Like (1)

Report

RE: User name and their roles

Hi,

If you are using D365, you can use User Summary report to see users and their respective security role.

Sale- > Reports

Select User Summary report and run the report.

Click on Export and choose the format you want to export the report.

Please mark the Answer verified if find helpful.

Thanks !

Was this reply helpful? Yes No
Suggested answer

Nithya Gopinath 17,078 on at

Like (1)

Report

RE: User name and their roles

Hi,

In XrmToolBox, there is a plugin called User, Team and Security Role Report.

In this plugin, Load Data and Check All users and security roles selected as shown below. Now select Generate Report.

Give a specific location for the report. When the report gets saved in the location, the data for the users and their security roles are also saved as a CSV file in the same location.

Hope this helps you.

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (1)

Report

RE: User name and their roles

select user.fullname, user.DomainName,role.Name

from SystemUser uers left join SystemUserRoles userrole on user.SystemUserId = userrole.SystemUserId

inner join Role role on role.RoleId = userrole.RoleId

where

user.IsDisabled = 0

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (1)

Report

RE: User name and their roles

The following query gives the name and Role

select user.fullname, user.DomainName,role.Name

from SystemUser uers left join SystemUserRoles userrole on us.SystemUserId = userrole.SystemUserId

inner join Role role on role.RoleId = userrole.RoleId

where

user.IsDisabled = 0

Caution:- this needs access to Database.

Was this reply helpful? Yes No
sandeepc 5,494 on at

Like (0)

Report

RE: User name and their roles

ok understood very near what would be the query could you pls help me out. will make as verified

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (1)

Report

RE: User name and their roles

Hi

I believe the best idea is to reach out to the support guys.... If your setup is on-prem they must be able to provide you the data with one sql query.

If it is online some work is needed where they might have to build a app in C# to do the same.

Since it's production please don't go with installing any other solutions if you are not confident.

Thanks

Phanidhar

Was this reply helpful? Yes No
sandeepc 5,494 on at

Like (0)

Report

RE: User name and their roles

ok, it is showing my security role how to find everyones under single spreadsheet

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

RE: User name and their roles

This is how you can navigate to security roles once you open CRM

1) Open the user record

2) Next to the name (which is on middle at the top) on top there will a arrow button.

3) Once you click this the related entities will be shown where you can find security roles

4) If you click on the security roles you will be able to see the roles associated with specific user.

Thanks

Phanidhar

Was this reply helpful? Yes No
sandeepc 5,494 on at

Like (0)

Report

RE: User name and their roles

then how can i check arround 370 users and their roles in my company

Was this reply helpful? Yes No