Loading
Salesforce now sends email only from verified domains. Read More
Manage Users and Data Access
Table of Contents
Filter by (0)Add
Select Filters

          No results
          No results
          Here are some search tips

          Check the spelling of your keywords.
          Use more general search terms.
          Select fewer filters to broaden your search.

            Search all of Salesforce Help
            Search all of Salesforce Help
            See User License Assignments with a Custom Report Type

            You are here:

            1. Salesforce Help
            2. Docs
            3. Manage Users and Data Access

            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

             
            Loading
            Salesforce Help | Article