Query all the queue a user belong

Question

How can I query all the queues to which a user belongs?

Note: Queues also contains public groups, role, role and subordinate and I need to loop through all these to find out if user is associated with these also.

Also I found out in user related list there is something called "queue membership" which contains all the queues that user associated with. Which object do I query for this?

Answer 1

The Sobject you should query is GroupMember. But it have the membership details of both Queue and Public Group. So you need to differentiate it using the Group type as 'Queue'.

Select Group.Name from GroupMember where UserOrGroupId = 'userid' and Group.Type = 'Queue'

Note: If the user is not added to the Queue directly this query won't work. Ex: If you add the user to Public Group and add this Public Group to the Queue, this query will return 0 results.

Hope it helps.

Answer 2

You may find this Github repo from Doug Ayers very helpful and pertinent.

As of this writing, Salesforce provides no way of reporting on who belongs to which queues.

The only workaround is to use SOQL to query users that belong to known groups by joining on groupmember object:

SELECT
    id, name, username, isActive
FROM
    user
WHERE
    id IN ( SELECT userOrGroupId FROM groupmember WHERE groupId = :groupId )
ORDER BY
    name