How to Query Users with Salesforce User License?

Sample SOQL:

SELECT Id, Name FROM User WHERE Profile.UserLicense.Name = 'Salesforce'


Using Report:

1. Go to Setup --> Customize --> Users --> Fields --> Create New Field.

2. Select "Formula" as the data type and "Text" as return type.

3. Use "Profile.UserLicense.Name" in the formula editor.

4. Save the formula field.

5. Use the formula field in the report.


Follow Us

Posted By : Sudeer Kamat Date :

view_module Related

  • How To Find Duplicates Records In a Object In Salesforce Using SOQL?How To Find Duplicates Records In a Object In Salesforce Using SOQL?
  • How to Find Dashboards that are using a Report in Salesforce?How to Find Dashboards that are using a Report in Salesforce?
  • How To Get Picklist Values Using SOQL In Salesforce?How To Get Picklist Values Using SOQL In Salesforce?
  • How to Find Users Last Login Date and Time In SalesforceHow to Find Users Last Login Date and Time In Salesforce
  • How To Quickly Find Newly Created Fields In SalesforceHow To Quickly Find Newly Created Fields In Salesforce

label Labels

Comments 0