Find your content:

Search form

You are here

Can you report or otherwise build list by User License Type?


We have 4 different license types in our org. "Salesforce," " - 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:

  1. Profile
  2. User Type (Standard seems to be regular Salesforce, CSN is Chatter External)
  3. Marketing User (checkbox)
  4. Offline User
  5. 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 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, 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:


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

My Block Status

My Block Content