The simpelest way would be via SQL:

**** Rolls - Groups - Permission ****

//-- Shows the essential permissions of the groups:

select Roles.name as Roll, groups.name as Group, PERMISSION_KEY as Permission
from roles, groups, GROUP_ROLE
where roles.id = role_id
and groups.id = Group_id
and permission_value = 1
and permission_key = any ('rw', 'move_into', 'create', 'ro')

//-- **** Groups - Queues ****

//-- Shows the Groups matching to the Queues incl. Validity.

select queue.id as QueueID, queue.name as Queue, queue.valid_id as QueueValid,
Groups.id as GroupID, Groups.name as GroupName, groups.valid_id as GroupValid

from queue, groups

where group_id = groups.id

//-- **** User -Rolls ****

//-- shows the roles of Users

select su.login, ru.user_id, ru.role_id, r.name from system_user su,
role_user ru, roles r
where su.id = ru.user_id
and ru.role_id = r.id
//-- and su.login like '%-admin'
order by su.login

You might wanna combine / change the statements, but that’s basically it.

Greetz,

Daniel

---

From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Clemens Zimmermann
Sent: Donnerstag, 3. Januar 2008 12:00
To: otrs@otrs.org
Subject: [otrs] Queue and Agent Overview

Hi,

I need an overview which agents are using what queues.

Could please anyone give me a hint  how to generate a list of all queues and the corresponding agents ?

Thanks

Clemens