Microsoft Dynamics CRM (Archived)

List of Users and Their Security Roles

(0) Share

Report

Posted on by JDMCRM

1,799

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

I have the same question (0)

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

Was this reply helpful? Yes No
JDMCRM 1,799 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.

Was this reply helpful? Yes No
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>

Was this reply helpful? Yes No
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

Was this reply helpful? Yes No
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"

Was this reply helpful? Yes No
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

Was this reply helpful? Yes No