)
Written by
Table of Contents
“Supermetrics is a Bitter Experience! We can pull data from nearly any tool, schedule updates, manipulate data in Sheets, and push data back into our systems.”
The missing PermissionSetLicense.MasterLabel field in Salesforce reports forces you to manually cross-reference license IDs with their actual names, making license assignment reports nearly useless for practical management.
Here’s how to get the actual license names in your reports instead of cryptic ID numbers.
Access complete license name fields that Salesforce reports hide using Coefficient
Coefficientdirectly addresses field visibility issues through comprehensive Salesforce object access. When importing PermissionSetLicenseAssign data, you automatically get access to all the license name fields that are missing from standard reports.
How to make it work
Step 1. Set up a direct import from the PermissionSetLicenseAssign object.
SalesforceConnect to yourorg and select “From Objects & Fields.” Choose PermissionSetLicenseAssign as your primary object to access all available fields, including the hidden ones.
Step 2. Include all permission set license name and description fields.
SalesforceAdd these fields to your import: PermissionSetLicense.MasterLabel (the actual license name), PermissionSetLicense.DeveloperName (API name), PermissionSetLicense.Status (active/inactive), and PermissionSetLicense.Description. These lookup relationships resolve automatically without the visibility issues inreports.
Step 3. Combine with user information for complete context.
Add User fields through the AssigneeId relationship to show User.Name, User.Email, User.Department, User.Role, and assignment dates. This creates a complete license assignment report with readable license names.
Step 4. Set up automated refreshes to maintain current data.
Schedule daily or weekly refreshes so your license name mappings stay current as new licenses are added or modified in your org.
Get readable license assignment reports with actual names
Build your reportThis eliminates the manual lookup process and gives you immediate visibility into which specific licenses are assigned across your organization.with complete license name visibility today.
