Genesys CTI User Forum

Hi.
My customer want a report that list of all the agent but group by agent group. I had set up the agents and agent groups information in the cfg manager. Is anyone out there did this kind of reports before ?

I have check out the OBJ_TO_OBJ table, it is blank. How to set this up.

(I have set up some agent groups with agents in CME)

Is it possible for you to explain it a little bit more?

eva

Hi,

there are more ways to create a agent repot group by agent groups.

1. You can create an Agent Report in the DMA.
Select the Agent Group "Agent Group_ABC" instead of "All
Agents".
So you have a group by the Agent Group_ABC.

2. You can work wiht Views in your DB.
Create a View which select all Agents they belong to the Agent
Group_ABC.

select a.object_id,
a.object_name,
a.presentation_name,
o.add_time as add_time_agent,
o.delete_time as delete_time_agent,
oto.add_time as add_time_group,
oto.delete_time as delete_time_group
from o_agent_day a, object o, obj_to_obj oto
where a.object_id = oto.child_id AND
o.object_id = oto.parent_id AND
o.object_name in ('Agent Group_ABC')

If it´s helpful, I can send you an Report where we have group agents by agent groups. (Brio)

Eva