Report on permission sets and managed Packages - Answers - Salesforce Trailblazer Community
Trailblazer Community
Ask Search:
Clare HeathClare Heath 

Report on permission sets and managed Packages

HI All

Can any of you fab people tell me if it is possible to produce a report that shows which Permission Sets and managed packages a user has?

I am trying to find all users with a specific permission set and then identify the ones that are missing a specific Managed Package?

As we have over 100,000 users it is not something I want to do mannually if I can possible help it !!

Any thoughts?

Pritam ShekhawatPritam Shekhawat
No right now this is not possible. You can upvote this idea here Ability to report on Users' Permission Set Assignments
Amit TrivediAmit Trivedi
Hi Clare,

No not possible with report still you can use SOQL to find permission sets associated with user

How PermissionSet relates to User is illustrated in this User, Sharing, and Permission Objects ERD.

So for example, this SOQL will list all permission set assignments:

Select Assignee.Name, PermissionSet.Name from PermissionSetAssignment order by Assignee.Name, PermissionSet.Name

and this will list permission sets for a specific user:

Select PermissionSet.Name from PermissionSetAssignment where Assignee.Id = :userId order by PermissionSet.Name

It requires little programmsing knowledge, fire query in developer console

Amit Trivedi
Vinay ChaturvediVinay Chaturvedi
Hi Clare,
Both of them are not possible right now.
Vote for these two ideas:
Managed Package License Reporting
Ability to report on Users' Permission Set Assignments

For Permission sets,there is a workaround mentioned in here
Using SOQL to Determine Your User’s Permissions
MiglenaMiglena ( 
Hello Clare,

The community has provided you with some great suggestions and guidance. Please take a moment to mark the most helpful post as "Best Answer" to close off this string and help others in the community with similar questions. Should you require additional help, please do not hesitate to ask. Thank you all for your contribution to Success Community.