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