[SalesForce] Can you report or otherwise build list by User License Type

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.

Best Answer

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.