Salesforce Docs Portal

See User License Assignments with a Custom Report Type

Create a custom report type to report on which user licenses your users are assigned.

Required Editions

Available in: both Salesforce Classic and Lightning Experience
Available in: Essentials, Professional, Enterprise, Performance, Unlimited, and Developer Editions
User Permissions Needed
To create and update custom report types and to create, edit, and delete reports:
Legacy Folder Sharing
Create and Customize Reports

AND

Manage Custom Report Types

Enhanced Folder Sharing
Create and Customize Reports

AND

Manage Custom Report Types
To view license information: View Setup and Configuration

For a video walk-through of these steps, watch Watch Video DemoTrack your Salesforce Users and Licenses with Custom Report Types (English Only).

  1. Create a custom report type with Users as the primary object.
  2. To configure the field layout of reports created from this custom report type, click Edit Layout.
  3. Click Add fields related via lookup.
  4. Click Profile, then select User License. Click view related fields… and select any additional fields, such as Expiration Date, Status, Total Licenses, and Usage Type. Click OK.
  5. Click Save.
  6. Build a Report with the custom report type that you created.
  7. In the left panel, add the related fields that you want displayed in your report. To group by user license, under Group Rows, select the Profile: User License: Name field.
  8. In the left panel, under Filters, if you see a filter for Chatter Adoption Stage Modified Date, change the range to All Time.

We recommend that you filter out users that aren’t assigned a license, such as automated users.

You can see permission set license assignments on the Company Information page. For more information, see View and Manage Your Permission Set Licenses.

See Also