ads

Wednesday, 29 August 2018

Fetch users with Salesforce User License using SOQL Query

Using SOQL Query:


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

Using Salesforce Report :

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

2. Create a "Text" formula field.

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

4. Save the formula field.Use the formula field in the report.

No comments:

Post a Comment