Ability to report on Users' Permission Set Assignments - Ideas - Salesforce Trailblazer Community

All Ideas

Idea Details

Post an Idea
31,180  Points
Under Consideration
Idea is being considered for release, but development hasn't started. We post updates every three releases.

Ability to report on Users' Permission Set Assignments

Reports & Dashboards

Now that we have the great and wonderful Permission Set Assignments, we also need to be able to report on it. Just like we can already report on users' role and profile, we need the ability to report on permission set assignments too. For example, we could use this to see how many users are assigned to XYZ permission set, or to see the login history of users with XYZ permission set.

Merge Idea · Flag

Latest Comment from Salesforce

  • Belinda Wong - 1 year ago

    Sadly adding permission set assignments as either a Standard Report Type or available to configure into a custom report type is challenging since they are 'setup' or metadata objects.  In fact, the Profile and Roles objects themselves are not available in standard reporting.   Because profile & role assignment has a 1:1 relationship to the User and thus are fields on the User object, you can report on them directly via the user object.   Since Permission Set Assignment is a many to many relation, it is a separate junction object.   This junction is available in the Sobject API for anyone who is able run the queries using Data Loader or other SOQL tools.   See this blog for examples of how to run these queries:  https://developer.salesforce.com/blogs/engineering/2012/06/using-soql-to-determine-your-users-permissions-2.html

    The new Lightning UI is built on our public APIs and as I journey with my team into converting the User Management setup pages into Lighting, I will look to incorporate this reporting/analytics request into the Lighting UI designs.
  • Upvotes
  • Downvotes



from AppExchange


Help us to keep IdeaExchange clean by pointing out overlapping ideas. We'll investigate your suggestion and merge the ideas if it makes sense.



Thanks for your merge suggestion. We will review it shortly and merge the ideas if applicable.

Salesforce takes abuse situations very seriously. Examples of abuse include but are not limited to posting of offensive language or fraudulent statements. To help us process your request as quickly as possible, please fill out the form below describing the situation. For privacy and security reasons, the final outcome of an abuse case may not be revealed to the person who reported it.


Thank you for your feedback. We take abuse seriously and will investigate this issue and take appropriate action.