List of Agent Groups in CMS Supervisor

[donov7]

I am trying to get a system wide list of all agents, and what agent groups they belong to. I can access that info either on a per agent, or per agent group, but not a master listing.

I tried to write a designer report but there was no database item for that.

Basically I would like a report that shows the agent, agent login ID and the agent group(s) they belong to.

Any suggestions?

Thanks!

Kerri

[shaikht]

Hi Kerri,

Below query can give you count of agents in agent group:

select item_name, count(*) from agroups where item_type="group" group by item_name order by 2 desc

Try with this or else please engage Avaya Professional services if they can design report for you.

I hope it helps.