Looking for PowerObjects? Don’t worry, you’re in the right place! We’ve been part of HCL for several years, and we’ve now taken the final step in our acquisition journey: moving our website to the HCL domain. Nothing else is changing – we are still fanatically focused on Microsoft Business Applications!

PowerObjects Blog 

for Microsoft Business Applications


Out of the Box Report: Dynamics CRM User Summary

Post Author: Joe D365 |

One of the important tasks for Microsoft Dynamics CRM 2011 administrators is ensuring users have appropriate access to the system. One of the challenges of doing an efficient user audit is easily seeing a list of all the security roles each user belongs to. No worries! There is a report that allows you to conquer this challenge.

Microsoft Dynamics CRM 2011 has about 25 out-of-the-box reports. Most of the reports analyze your CRM data. However, there is one report for administrators: the Dynamics CRM User Summary report.

Let's take a look.

  1. In CRM, click on Workplace.
  2. Click on Reports.
  3. Double click on User Summary.
  4. The next screen allows you to filter the user list.
  5. Once you've set your filter criteria (you aren't required to filter your report), click on Run Report.
  6. The resulting report will display:
    1. Information about each User
    2. Users grouped by Business Unit
    3. A listing of all the security roles to which each User belongs

Dynamics CRM User Summary Report

Not only does the User Summary report give you a list of users, it allows you to see which security roles each user belongs to. The only other way to see if a user belongs to a specific security role is by accessing their user record. This can be time consuming especially for larger organizations. Another benefit is that you can access the User record directly from the report, making it easy to alter access levels. And it's just a great way to audit user access.

NOTE: This report does NOT show roles assigned to Teams.

That's all it takes!

Want to know more about security roles in Dynamics CRM? Take a look at this recent blog if you'd like to learn how to restrict how information can be taken out of your CRM system.

Happy CRM'ing!

Joe CRM
By Joe D365
Joe D365 is a Microsoft Dynamics 365 superhero who runs on pure Dynamics adrenaline. As the face of PowerObjects, Joe D365’s mission is to reveal innovative ways to use Dynamics 365 and bring the application to more businesses and organizations around the world.

2 comments on “Out of the Box Report: Dynamics CRM User Summary”

    1. Hi - Pls post teh error you are getting when exporting to excel. And what version of crm are you using ?

PowerObjects Recommends