Helpful Queries – License Related Queries:

on

Helpful Queries – License Related Queries:


Get count of User License (used,remaining):

SELECT MasterLabel, Name, Status, TotalLicenses, UsedLicenses, UsedLicensesLastUpdated FROM UserLicense


Get count of Permission Set License (used,remaining):

SELECT MasterLabel, ExpirationDate, TotalLicenses, UsedLicenses FROM PermissionSetLicense


Get count of some Feature License Queries:

Service User: Select count() From User where UserPermissionsSupportUser=true and isActive=true

Chatter Answers User: Select count() From User where UserPermissionsChatterAnswersUser=true and isActive=true

Flow User: Select count() From User where UserPermissionsInteractionUser=true and isActive=true

Knowledge User: Select count() From User where UserPermissionsKnowledgeUser=true and isActive=true

Marketing User: Select count() From User where UserPermissionsMarketingUser=true and isActive=true

Offline User: Select count() From User where UserPermissionsOfflineUser=true and isActive=true

Salesforce CRM Content User: Select count() From User where UserPermissionsSFContentUser=true and isActive=true



Reference(s): https://help.salesforce.com/

Comments

Post a Comment