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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Clemens Zimmermann
Sent: Donnerstag, 3. Januar 2008 12:00
To: [email protected]
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
_______________________________________________
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Support or consulting for your OTRS system?
=> http://www.otrs.com/
