[otrs] Queue and Agent Overview

[Obee, Daniel]

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 at otrs.org [mailto:otrs-bounces at otrs.org] On Behalf Of
Clemens Zimmermann
Sent: Donnerstag, 3. Januar 2008 12:00
To: otrs at 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

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.otrs.org/pipermail/otrs/attachments/20080103/b8e609e7/attachment.html