Microsoft Dynamics CRM (Archived)

List of Users and Their Security Roles

(0) Share

Report

Posted on by JDMCRM

1,797

Hi,

How can I get a list of all the Users within a system with the Security Roles assigned to them in CRM 2011 On-Prem.

I can go through each User one by one, but was just seeing if there was a way to export an excel spreadsheet or something like that with the information.

*This post is locked for comments

All responses (6)

Answers (1)

Community Member on at

Like (0)

Report

RE: List of Users and Their Security Roles

Interesting info on the out of the box report.

harihar
JDMCRM 1,797 on at

Like (0)

Report

RE: List of Users and Their Security Roles

Thanks for the responses. Rajkumar that was what I was after, cheers.
Suggested answer

anilambadan 1,160 on at

Like (0)

Report

RE: List of Users and Their Security Roles

Please try the fetchXml below to get this.

<fetch mapping="logical" count="50" version="1.0">

<entity name="systemuser">

<attribute name="fullname" />

<link-entity name="systemuserroles" from="systemuserid" to="systemuserid">

<link-entity name="role" from="roleid" to="roleid">

<attribute name="name" />

</link-entity>

</link-entity>

</entity>

</fetch>
anilambadan 1,160 on at

Like (0)

Report

RE: List of Users and Their Security Roles

You can do it using advanced find. please see the screenshot below.

or please refer to the following link to do it with fetchXml

https://community.dynamics.com/crm/b/crmmitchmilam/archive/2010/07/20/creating-a-query-to-find-all-users-with-a-specified-security-role

thanks

Anil
Verified answer

Rajkumar Rajaraman on at

Like (1)

Report

RE: List of Users and Their Security Roles

JD,

Refer the following blog:

www.powerobjects.com/.../dynamics-crm-user-summary-report

community.dynamics.com/.../out-of-the-box-report-dynamics-crm-user-summary

Hope this helps.

Regards,

R.Rajkumar

"Please mark my answer as verified if you found it helpful"
stuart 2,080 on at

Like (0)

Report

RE: List of Users and Their Security Roles

Personally I'd just query the sql db using filteredsystemuser and filteredsystemuserroles