We have 4 different license types in our org. "Salesforce," "Force.com - One App," "Chatter Free" and "External Who"
We have a couple hundred users. I need to build a report that lists who has what license. Company Information gives me the Available vs Used, but I need to see the actual users.
Anyway to build a report to display this information?
For a bonus - I would love to be able to do this by feature license as well. To see which users are Marketing Users, Service Cloud User, Content User, Knowledge and Flow Users.
Attribution to: Salesforce Wizard
Possible Suggestion/Solution #1
You can get most of this from a standard report. Create a new report using Administrative Reports -> User as the report type. You can then add the following fields:
- Profile
- User Type (Standard seems to be regular Salesforce, CSN is Chatter External)
- Marketing User (checkbox)
- Offline User
- Sales Anywhere User
I'm not sure about Knowledge, Service Cloud or some of the others because we don't have those extras, but they'll probably be there under the Salesforce.com Information bucket in the Report Builder. You can also count the number of Active users to help determine how many licenses are in use.
Attribution to: Mike Chale
Possible Suggestion/Solution #2
If you are using SOQL, it's at [select id, profile.userlicense.name from User]
Attribution to: hemmeter
Possible Suggestion/Solution #3
Create a custom formula field with output of text and in the formula field, use this:
Profile.UserLicense.Name
You'll be able to report on the license types then.
Attribution to: William Nourse
This content is remixed from stackoverflow or stackexchange. Please visit https://salesforce.stackexchange.com/questions/311