Tuesday, June 19, 2018

How To Check Active Users in a Permission Set Using SOQL Query

If you want find How many Active Users in a Permission Set using SOQL query
use the Below simple query it fetches active users in Permission Set.
Query:
SELECT Count(AssigneeId) FROM PermissionSetAssignment WHERE Assignee.isActive = true AND PermissionSet.Name='<Permission set API Name>'
it gives the result in the form of Count.
Ex: if the count is Four, means 4 active users are in Permission Set.
Please Check Screen Shot for more details.

Please let us Know If you have any Queries.
Happy Learning!!

1 comment: