Export users and roles to Excel

(0) Share

Report

Posted on by Mirsad1

Hello,

I am looking to export all the users and their roles in one simple overview (preferably in Excel). I have figured out how to export the users but I can't find the correct settings to export them with their roles in one file.

This is in Dynamics F&O.

Help would be much appreciated!

I have the same question (0)

All responses (13)

Answers (2)

Verified answer

GirishS 27,827 Moderator on at

Like (2)

Report

Hi Mirsad,

Run the report given in the below path and see whether its help you.

System administration > Inquiries > Security > Role to user assignments

Thanks,

Girish S.

Was this reply helpful? Yes No
Mirsad1 5 on at

Like (0)

Report

Thanks for the help! I got it in PDF. Any idea if it is possible to export it to excel?

Was this reply helpful? Yes No
Verified answer

GirishS 27,827 Moderator on at

Like (1)

Report

On the report screen - Top left corner there will be an export drop down button. Click on that and select excel.

Was this reply helpful? Yes No
Mirsad1 5 on at

Like (0)

Report

Got it! I had a different UI with the option to change destination. That's when it showed the same as your screenshot.

thank you Girish!

Was this reply helpful? Yes No
GirishS 27,827 Moderator on at

Like (1)

Report

Great!

Don't forget to mark the useful answers as verified, So that others can make use of the thread.

Its done by clicking "Did this answer your question >>Yes on the particular reply.

Thanks,

Girish S.

Was this reply helpful? Yes No
André Arnaud de Cal... 300,917 Super User 2025 Season 2 on at

Like (0)

Report

Hi Mirsad,

You can also use Open in Excel or Data management to get the users and role assignments in Excel. See also my blog: Move all user and security settings with data entities - Dynamicspedia

Was this reply helpful? Yes No
Ric-D on at

Like (0)

Report

Hi Girish,

How do I export a list of users that have D365 license assigned?

Thank you.

Was this reply helpful? Yes No
Suggested answer

GirishS 27,827 Moderator on at

Like (0)

Report

Hi Jupi,

Under System administration >> Inquiries >> License >> User License counts >> Ran this report and check whether it meets your required data - Make sure to check the "Show list of users per access license type" slider and also give the date value.

Thanks,

Girish S.

Was this reply helpful? Yes No
Suggested answer

Mohit Rampal 12,565 Moderator on at

Like (0)

Report

Hi Jupi, You can export data from 'User Licence Counts' report from System Administration-->Enquiries-->Licence-->User Licence Counts

Was this reply helpful? Yes No
Ric-D on at

Like (0)

Report

thanks, but this method is only in FinOps. I want to do in normal dynamcis 365 CRM. Don't have F&O

Was this reply helpful? Yes No