How many users have a specific permissionset - Answers - Salesforce Trailblazer Community
Trailblazer Community
Ask Search:
Tusar PanigrahiTusar Panigrahi 

How many users have a specific permissionset

Hello- we need to generate a report on users with specific permissionset? I know we can't report on permissionset. What are the other alternatives to address this?



 
Atul GuptaAtul Gupta
Yes you are right, you can't report on Permission Sets. There is an Idea (https://success.salesforce.com/ideaView?id=08730000000glw0AAA) for this you can vote on.

And here is a fantastic tool you can user to do what you are asking and more.

Let me know if you need any further help on this.
Tusar PanigrahiTusar Panigrahi
Thanks ..unfortunately this won't help us to create a dashboard in sf.
Pritam ShekhawatPritam Shekhawat
Take a look here Using SOQL to Determine Your Force.com User’s Permissions (https://developer.salesforce.com/blogs/engineering/2012/06/using-soql-to-determine-your-users-permissions-2.html)  Meanwhile you can promote and upvote this idea here Ability to report on Users' Permission Set Assignments (https://success.salesforce.com/ideaView?id=08730000000glw0AAA)  Or you can capture this information in some custom object and can run a report and also add dashboard for that if this information is important for you.
Atul GuptaAtul Gupta
Did you sort this out ?
John SzurleyJohn Szurley
You could export the data and report from Excel.  I used aside.io and used their data query tool with: 

SELECT Id, PermissionSetId, AssigneeId FROM PermissionSetAssignment

then I exported to .CSV

You may want to export the following: 

SELECT Id, Name, Label, Description FROM PermissionSet 

to link the ID to the name of the Permission Set.

Another tool to use is - dataloader.io   You don't need to know query language for that one, just the object names - PermissionSet and PermissionSetAssignment.

Good Luck!

John
Jane IsaacJane Isaac
You could also try this free app - it worked for me: https://appexchange.salesforce.com/appxListingDetail?listingId=a0N300000016a4jEAA (http://Profiles and Permission Sets Reports)
 
Sakthivel MadeshSakthivel Madesh
may be useful to others if they looking SOQL or APEX to achieve this count requirement,

http://theblogreaders.com/many-list-users-assigned-salesforce-permissionset/

Thanks & Regards,
Sakthivel Madesh