Find Users who are not assigned to a Permission Set #inSalesforce

on

Find Users who are not assigned to a Permission Set #inSalesforce


- Go to Salesforce Inspector, query and Export

Select AssigneeId, PermissionSet.isOwnedByProfile FROM PermissionSetAssignment Where PermissionSet.isOwnedByProfile=False

-Remove the duplicate records from the file generated in the above step in Excel by selecting the "Remove Duplicates" option under "Data".

- Query the Users in the Org and Export it

- Do a Vlookup between the files generated in the previous two steps to get the list of Users who are not assigned to a Permission Set.

Visual: https://www.youtube.com/watch?v=TWVtd0W0Lg4


Comments

Post a Comment