Cannot Verify Service Users in Salesforce Reports

Because standard reports cannot filter users with Service licenses, use the Developer Console to verify the assignment.

Follow the steps below to execute a SOQL query and retrieve the list of users:

1. Click the gear icon in the upper right corner of the Salesforce screen and select Developer Console.

2. In the Developer Console, click File > Open Resource from the menu.

3. Enter "User.obj" in the search field and click Open.

4. Click the Query Editor tab at the bottom of the screen and enter the following query:

   SQL

    

   SELECT FirstName, LastName, Id, UserPermissionsSupportUser, IsActive FROM User WHERE UserPermissionsSupportUser = True
   

5. Click Execute.

Users with true in the UserPermissionsSupportUser column in the query results are those assigned a Service license.