Loading

Find users with permission set licenses

Date de publication: Apr 2, 2026
Description
When you are unable to find users who are using specific permission set licenses, you can use a query in the developer console to do so.
Résolution

Please follow the steps mentioned below :

  • 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"  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.

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

Ressources supplémentaires

Permission Set Licenses

Numéro d’article de la base de connaissances

000381153

 
Chargement
Salesforce Help | Article