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)

stuart 2,080 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Verified answer

Rajkumar Rajaraman on at

Like (1)

Report

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
anilambadan 1,160 on at

Like (0)

Report

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
Suggested answer

anilambadan 1,160 on at

Like (0)

Report

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
JDMCRM 1,799 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Interesting info on the out of the box report.

harihar

Was this reply helpful? Yes No