How to query user license in salesforce


How to query users with Salesforce User License?

  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.

If what you want is the Users with a License Name of Salesforce than the following query can get them: List<User> usersWithSalesforceLicense = [ Select Id, Name, Profile.UserLicense.Name From User Where Profile.UserLicense.Name = ‘Salesforce’ ];Jan 3, 2014


How much does a Salesforce user license cost?

Salesforce pricing plans can cost from $25 per user per month, to over $300 per user per month — their monthly fee will vary depending on the needs and scale of each business.

What are the different types of Salesforce user licenses?

  • 2 Salesforce licenses.
  • 3 Salesforce Platform licenses.
  • 2 Salesforce CRM licenses.
  • 2 Salesforce Mobile licenses.
  • 5 Salesforce Partner licenses.
  • 10 Customer Portal Manager licenses.

How to query the number of used license in Salesforce?

  1. Active Users: to count all active users, the formula: RowCount
  2. License Remain: this is by calculating Total License – Active Users, the formula: User.Profile.UserLicense.TotalLicenses:SUM – RowCount You can add Conditional Highlighting to get user attention when remaining licenses reach …
  3. The Moment of Truth

How do I log into Salesforce?

How do I access Salesforce for the first time?

  • Check your email for your login information.
  • Click the link provided in the email. The link logs you in to the site automatically.
  • The site prompts you to set a password and choose a security question and answer to verify your identity in case you forget your password.

How do you check which users are using Salesforce license?

To view a list of the active user licenses in your Salesforce, simply click Your Name > Setup > Company Profile > Company Information > User Licenses.

How do I query a user’s license?

How to query users with Salesforce User License?Go to Setup –> Customize –> Users –> Fields –> Create New Field.Select “Formula” as the data type and “Text” as return type.Use “Profile.UserLicense.Name” in the formula editor.Save the formula field.Use the formula field in the report.

How do I query a feature license in Salesforce?

Use Developer Console:Open the Developer Console.Click Query Editor.Copy and paste the following query: Select Name, ID from User where UserPermissionsKnowledgeUser=true.Click Execute button to execute the query.

How do I manage a user’s license in Salesforce?

User LicensesAssign a Lightning Platform user license to Employee A. The Lightning Platform user license only supports standard object permissions for accounts and contacts, so Employee A can’t access cases.Assign a Salesforce user license to Employee B. Give “Read” access on cases to Employee B.

How do I query users in managed packages in Salesforce?

It’s not currently possible to report on Managed Package licenses assigned to users. To view and managed licenses go to Setup > Installed Packages and click Manage Licenses next to the package name, here you can see the names of the individual users assigned a license for the package.

How do I query managed package license in Salesforce?

Alternative solution: use SOQL, so we can extract the data easily.Query the Package Id. You need to know the Namespace Prefix of the package to get the Package Id. … Query User Package License object. SELECT Id, PackageLicenseId, CreatedById, CreatedDate, UserId FROM UserPackageLicense.

How do I check my license status in Salesforce?

View Your Organization’s Feature LicensesFrom Setup, enter Company Information in the Quick Find box, then select Company Information.See the Feature Licenses related list.

What is identity license in Salesforce?

The Identity license grants users access to Identity features. Salesforce Identity connects Salesforce users with external applications and services, while giving admins control over authentication and authorization for these users.

Can we change user license in Salesforce?

Go to: Your Name > Setup > Admin > Manage Users > User > Select the User Record > Click Edit > Change User license.

How many user licenses are there in Salesforce?

Each user must have one license. The users are assigned for the data access through their user-profile and optionally using one or more permission sets. The feature license authorizes the users to access additional features available in the salesforce that are not included in their user license, e.g., Marketing or WDC.

What are user licenses?

A user license is a legal agreement between the software provider and the purchaser that establishes the client’s right to use the software and which features they can access.

What are the licenses available in Salesforce?

Salesforce User License TypesSalesforce. Full access to standard CRM and functionality. … Salesforce Platform. … – One App. … App Subscription. … Knowledge Only User. … Identity. … Chatter Free. … ChatterExternal.More items…•

Create a Knowledge users list view

1. Navigate to View and Manage Users : From Setup, enter Users in the Quick Find box, then select Users.
2. Follow the corresponding steps provided in Custom Your Data View to create a new user list view with the filter criteria:

Use Developer Console

1. Open the Developer Console.
2. Click Query Editor.
3. Copy and paste the following query:


Leave a Comment