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.