Can I report out which users have which license type ? - Answers - Salesforce Trailblazer Community
Trailblazer Community

Browse by categories

Ask Search:
ShowAll Questionssorted byDate Posted
Eric DreshfieldEric Dreshfield 

Can I report out which users have which license type ?

Is it possible to get a report of users by license type ?  

I need a listing of which users are "Salesforce" versus which are "Salesforce Platform".

I've tried a custom field on the user object:  TEXT(Profile.UserType)  
     but that only returns the following values: CsnOnly; Guest; Standard
and based upon the counts the "Standard" includes both my Salesforce and my Salesforce Platform users.

How can I break that out separately so I know which users hold which license ?
Best Answer chosen by Moderator (salesforce.com) 
Eric DreshfieldEric Dreshfield
I got it worked out....a custom formula field on the object that has this as the fomula:

Profile.UserLicense.Name

Thanks to @Nick_Whitney for replying to my tweet with this question !

All Answers

Subramanyam MeareSubramanyam Meare
Why are looking for Custom field on User object instead you can create a report on User object & add the Field User type to differentiate the license which each User have.

Regards,
Subbu.
Eric DreshfieldEric Dreshfield
I tried User Type....it does not break out Salesforce versus Salesforce Platform users...and that is the distinction I need to know.
Arijit MajeeArijit Majee
Hello Eric,

check this out
https://success.salesforce.com/questionDetail?qId=a1X30000000f53dEAA
Eric DreshfieldEric Dreshfield
I got it worked out....a custom formula field on the object that has this as the fomula:

Profile.UserLicense.Name

Thanks to @Nick_Whitney for replying to my tweet with this question !
This was selected as the best answer
Daniela SchmitzDaniela Schmitz

I had the same problem, and this worked just fine, great!!

Weird though that it is not possible to report on this standard field from the start....

@Eric, ow did you do it to find the correct field name to put in your formula?

I would like to do the same with the user checkbox "Service Cloud Checkbox", but am clueless on what the correct field name might be.
 
Eric DreshfieldEric Dreshfield
I had help finding it.... @Nick_Whitney replied to the twitter post from my original question. If you are on twitter try posting the link to this thread with the hashtag #askforce - sometimes that gets a faster answer than here.
Kris SpringerKris Springer
@Eric, I tried to add a Custom Field as you suggested, but then after I save it the Default value changes from $Profile.UserLicense.Name to $Profile.Name

How do you get this to work?  I'm about to give up on this.  There's got to be a better solution to this issue.
Eric DreshfieldEric Dreshfield
Kris - here's a screen shot of my custom field on the user object.  When I created the custom field, I switched to the Advanced Formula tab before keying in the formula of "Profile.UserLicense.Name" (with out the quotes...that's just here for separation.)  Then I clicked on Check Syntax and got no errors, so I proceeded to save the field.
User-added image

Hope that helps!  Good luck.
Kris SpringerKris Springer
Boom!!  That really helped.  I had the Data type wrong.  I needed to choose Formula.  Just to make everyone's life easier, here's the steps accomplish this.

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

Now you can view the new field by viewing any users account, and add the new ‘User License’ feild as a column in your custom user list views.  :-)
Eric DreshfieldEric Dreshfield
YEAH!!!  A picture is worth 1,000 words...I'm glad you got it working!
Paul RaytsenPaul Raytsen
Thanks @Kris and @Eric. EXACTLY what I need as well. Works like a charm.
Srinath ReddySrinath Reddy
Thanks @Eric and @Kris for  sharing this great workaround. Appreciate it.
Priya SontenamPriya Sontenam
Thanks @Eric and @Kris for sharing this! How can I pull out the profile and Role names on my reports instead of their Id's (Prodile_Id an Role_Id) ?
SFDC UserSFDC User
Thanks Eric for sharing it. I got it working within minutes.
Alan Thomas PayneAlan Thomas Payne
Used this today! Top stuff! Done in a jiffy! And just what the Dr. ordered!
Geraldine SykesGeraldine Sykes
I also used this and it worked perfectly, thank you!
Andrew DollengerAndrew Dollenger
Perfect! Just what I was looking for.
venugopal kapavenugopal kapa
Hi All, 

Now we have a new option to filter users by License type by just creating a custom report type, no need to create a formula field!!
Complete details here : https://help.salesforce.com/articleView?id=000230587&type=1

Hope this helps someone, who is looking at this page
Jessica EiselmanJessica Eiselman
The details on how to create a new license type worked great! Thanks for the tip to the link:  https://help.salesforce.com/articleView?id=000230587&type=1
 
Zachary Hoyer-LeitzelZachary Hoyer-Leitzel
eric - your posting of this solution is still helping people out 7 years later. thank you!
Charlene StewartCharlene Stewart
I have read the comments and tried to follow but I have no idea what I am doing. Can someone please help and talk to me like I am a 4 year old. (New employee) Help please....