Customer experience | Sales, Customer Insights,...

How can I export (in a report/excel/csv/etc) Field Permissions of a Field Security Profile?

(0) Share

Report

Posted on by Chrys G

Hello everyone,

I have tried to export field security permissions per field security profile:

But it does not seem to be possible to do so by the standard product.
(Xrm toolbox User Security Manager, is a great tool but does provide only an overview of the users/teams under each profile but not the actual fields affected by the profile)

All responses (2)

Answers (0)

Chrys G 5 on at

Like (1)

Report

RE: How can I export (in a report/excel/csv/etc) Field Permissions of a Field Security Profile?

Thank you! I did it also another way actually, through exporting the solution and manipulating the XML with Power Query. But this is also essentially really helpful.
Suggested answer

Ray 1,480 on at

Like (1)

Report

RE: How can I export (in a report/excel/csv/etc) Field Permissions of a Field Security Profile?

There is an entity called Field Permission, this entity stores the info you want. Field Permission has a N : 1 relationship with Field Security File, so you can query the data with field security file id.

Here is a result screenshot in SQL 4 CDS (also a tool in XRMToolbox):