Q: How can I tell what kind of Salesforce License a User has?

A: The Salesforce License is found on the User’s Profile.

To see it from a User Record Page (or a User Report), create a Formula (Text) field on User with the following formula:

Profile.UserLicense.Name

It’s more useful than the standard User Type field: