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)

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Ray 1,537 on at

Like (1)

Report

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):

Was this reply helpful? Yes No
Chrys G 5 on at

Like (1)

Report

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.

Was this reply helpful? Yes No