How would I filter a 'user licence' in 'user list view'? - Answers - Salesforce Trailblazer Community
Trailblazer Community
Ask Search:
Karthikeyan ChandranKarthikeyan Chandran 

How would I filter a 'user licence' in 'user list view'?

I can't filter the field 'user licence' in user listview Why.?

Phoebe LynnPhoebe Lynn
Unfortunately that does not seem to be a feature.  You may want to use 'User Type'?  At least that filters out Chatter free users etc.
DhanshyamDhanshyam (salesforce.com) 
Hi Karthikeyan,

I would like to try and help here.I have investigated further and unfortunately this feature is currently not customizable to the extent you require -

I have included a direct link to the IdeaExchange, a Salesforce forum for new feature ideas and voting on requests:

Make the Service Cloud User field available for User List Views
https://success.salesforce.com/ideaView?id=08730000000XloJAAS

We would recommend you and your users to vote, (or 'promote') the Idea, - if there is enough support for an idea (as voted by other Salesforce users), it will be included in the next release.

All feature requests go into a formal process that includes:
- Documenting and submitting your request to the review teams
- Prioritizing and reviewing each recommendation
- Assigning a scheduled release date, if appropriate

We value each and every request submitted by our customers and make all efforts to include your request in future releases.


And also there are few workarounds what might be of some help to you as of now.

Workaround No:1
You can get most of this from a standard report. Create a new report using Administrative Reports -> Users 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

Workaround No:2
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.

Workaround No:3
If you are using SOQL, it's at [select id, profile.userlicense.name from User].

I hope this information has been helpful.  If the above information resolved this issue, please make sure to take a moment to share the resolution and mark the post as "Best Answer" to assist others in the community with similar questions.  Thank you.

In case if you need additional help please revert back with your inputs.

Regards,
Dhanshyam
Ronak @ Xenogenix LtdRonak @ Xenogenix Ltd
Workaround No:2
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.

Is the best option, worked a treat!