web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Suggested Answer

Get a report of a user's roles and teams they're part of

(0) ShareShare
ReportReport
Posted on by 15

Hello, is there any way (via C#, advanced search, xrmtoolbox...) to get a report in an Excel spreadsheet format? The columns should be something like:

User fullname |  Email | Security role(s) | Teams they belong to 

Has anyone ever done this? A query would be enough, thanks.

I have the same question (0)
  • Suggested answer
    KK-365 Profile Picture
    1,010 on at

    Hello,

    Please follow the below process:

    1. Log in to https://admin.powerplatform.microsoft.com/

    2. Select the environment 

    3. Select Settings in top ribbon 

    4. Select the drop down of Users + Permissions

    5. Select Users

    6. Select Manage Users in Dynamics 365

    pastedimage1661778083239v1.png

    7. Select Run Report dropdown on the top ribbon.

    8. Select User Summary

    pastedimage1661778177501v2.png

    This will give you want you need.

    If you find this helpful, please mark this answer Verified.

  • Suggested answer
    Community Member Profile Picture
    on at

    Hi Anggie,

    Maybe you can try to use the following  xrmtoolboxs:

    1.Users, Team and Security Role Report

    View User's and Team's Security Roles and how they related to each other. 

    https://www.xrmtoolbox.com/plugins/Daggen.Xrm.UserTeamSecurityRoleReport/ 

    2.User Security Manager-User Security Report

    User Security Report allows us to generate reports for security roles and field security profile assigned to the user directly or through team for all the system users or the selected system users.

    https://nishantrana.me/user-guide-user-security-manager-xrmtoolbox-plugin-for-managing-users-security/ 

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 70 Super User 2025 Season 2

#2
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 33 Most Valuable Professional

#3
Daniyal Khaleel Profile Picture

Daniyal Khaleel 32 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans