Q:

Count() of active users from permission set

I have below query which fetching the Active users from the permission set. But I need a count() of active users.
Below is the query I am using :
SELECT Id, 
       AssigneeId,
       PermissionSet.Name 
 FROM PermissionSetAssignment 
 WHERE Assignee.isActive = false and permissionSet.Name='Test_Permission'

A:

SELECT count(Id) FROM PermissionSetAssignment WHERE Assignee.isActive = true and permissionSet.Name='Test_Permission'

If you want only the count, you can just use count(id) to get the count. But if you want other values you can go with the previous answer.
Thanks. Hope this helps!!

