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 support@ortooapps.com for any questions.

Was this information helpful?

The page cannot be found

The page you are looking for might have been removed, had its name changed, or is temporarily unavailable. Please make sure you spelled the page name correctly or use the search box.