Finding the number of Q-assign Licenses and unique Assignment Group Members
Licenses are based on the total number of unique members of a Q-assign Assignment Group, including users and queues, plus any users that are not members of an Assignment Group but need access to Q-assign – e.g. managers and admins. Please note that a Q-assign license cannot be assigned directly to a queue, but as it is a member of Assignment Group, Q-assign will add it in the total count.
Following are the steps to find the Q-assign licensed Users:
To find the users that are unique members of the Q-assign Assignment Groups
Select count(id) from ortoo_qra__assignment_group_member__C where ortoo_qra__Owner_Type__c = 'User' group by ortoo_qra__User__c
To find the Queues that are added as members of the Q-assign Assignment Groups
Select count(id) from ortoo_qra__assignment_group_member__C where ortoo_qra__Owner_Type__c = 'Queue' group by ortoo_qra__Queue__c
To find the users that have Q-assign license but are not part of an Assignment Group
SELECT UserId FROM UserPackageLicense
WHERE PackageLicenseId in (SELECT Id FROM PackageLicense where NamespacePrefix = 'ortoo_qra')
AND UserId NOT IN (Select ortoo_qra__User__c from ortoo_qra__Assignment_Group_Member__c where ortoo_qra__Owner_Type__c = 'User')
Please contact us at firstname.lastname@example.org for any questions.