Find Standard Salesforce User count

Modified on Thu, 15 Sep, 2016 at 11:47 AM

Please follow the below steps for executing the query.


1. Login to salesforce.

2. Open Developer console of salesforce.

3. Type the below query to Query Editor and click on Execute.

Select Count() From User Where IsActive = True And UserType = 'Standard'

Please refer below screenshot :


Below are the category of User License and types. Each UserType is associated with one or more UserLicense records. Each UserLicense is associated with one or more profiles. In API version 10.0 and later, valid values include:

  • Standard: User License. This user type also includes Salesforce Platform and Salesforce Platform One User Licenses. Label is Standard.
  • PowerPartner: PRM user whose access is limited because he or she is a partner and typically accesses the application through a partner portal. Label is Partner.
  • CSPLitePortal: User whose access is limited because he or she is an organization's customer and accesses the application through a Customer Portal. Label is High Volume Portal.
  • CustomerSuccess: User whose access is limited because he or she is an organization's customer and accesses the application through a Customer Portal. Label is Customer Portal User.
  • PowerCustomerSuccess: User whose access is limited because he or she is an organization's customer and accesses the application through a Customer Portal. Label is Customer Portal Manager. Users with this license type can view and edit data they directly own or data owned by or shared with users below them in the Customer Portal role hierarchy.
  • CsnOnly: User whose access to the application is limited to Chatter. This user type includes Chatter Free and Chatter moderator users. Label is Chatter Free.

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article