Find users with permission set licenses

This article explains how to find the users who are using a specific permission set license by running a SOQL query in the Developer Console.

Steps to Query Permission Set License Assignments

• Go to the Developer Console

To open the Developer Console from Salesforce Classic:

1. Click Your Name.
2. Click Developer Console.

To open the Developer Console from Lightning Experience:

1. Click the Setup gear icon.
2. Click Developer Console.

• Click the Query Editor tab towards the bottom left
• Copy and paste the following query in the Developer Console:

  SELECT Name, Id FROM User WHERE Id IN (SELECT AssigneeId FROM PermissionSetLicenseAssign WHERE PermissionSetLicense.MasterLabel ='NAME OF THE PERMISSION SET LICENSE') AND IsActive=true ORDER BY Name

  This query selects the Name and Id of every active User whose Id appears in the PermissionSetLicenseAssign junction object for the specified license, then sorts the results by name.

  Note: Make sure to change the phrase 'NAME OF THE PERMISSION SET LICENSE' value to the actual permission set name (i.e. Sales User) before executing the command in the Developer Console.

• Click Execute.

Additional Notes

This will display a list of every ACTIVE user along with their internal Id, who have that license. If you would want to view the assigned license(s) of INACTIVE users, you would need to replace the "IsActive=true" with "IsActive=false"

Note: If you are not sure about the name of the licenses, please get the name from under permission set license assigned from company information.

The steps on this article are only applicable and will only work for Organization that has API access. For more information see Salesforce Editions with API access.

PermissionSetLicenseAssign is the junction object that links a user to a Permission Set License.