User License type in report - Answers - Salesforce Trailblazer Community
Trailblazer Community
Ask Search:
Anas AlamourAnas Alamour 

User License type in report

How to show User License type in a report without create any new field in User object?
Best Answer chosen by Anas Alamour
Kiran KambleKiran Kamble
Hi Anas
You can't directly report on Report on License type of Users - "User License" ,  Please upvote this idea -
https://success.salesforce.com/ideaview?id=08730000000BqGHAA0

 you can use below if in case you want to go with customization option - 


1. Username>Setup>App Setup>Customize>Users>Fields>User Custom Fields>New button
2. Choose ‘Formula’, Next
3. Create a field label ‘User License’, select ‘Text’ as Formula Return Type, Next
4. Enter the following in the ‘User License Text’ field, then click ‘Check Syntax’ button, Next
Profile.UserLicense.Name
5. Select appropriate visibility setting, probably only Admins, Next
6. the default page layouts should be fine, Save