How to find what Q and Team and Agent is a member of?

[DrVoIP]

If you have an Agent name, what is the fastest way to locate what Team and Q they are a member of?           

[Andrew Skelly]

Query the user in CCX App Admin.

[DrVoIP]

Andrew dont mean to be dense, but when I go to user management it only shows their capability, not there membership?

[Andrew Skelly · Accepted solution]

You want to go to Subsystem -> RmCm -> Resources.  That will show you their assigned skills as well as team.

If you want to see what agents are assigned to a specific queue, you can go RmCm -> Contact Service Queues.  From there choose the queue and when it comes up, click on Open Printable Report across the top.

[DrVoIP]

This is all correct, I was hoping for a more inclusive report.  Search for Agent ID and see all of this ono one screen, this is to much hunting around.  If you have 50 or more Q's, this is really cumbersom to open each and hunt to see if your Agent is a member! You are correct however. Thanks -

[Aaron Harrison]

Hi

This is what I use for migrating systems - connect to CCX with Putty, log printable output to text, and squirt this command in:

run uccx sql db_cra select s.skillname, rsm.competencelevel, r.resourceLoginID, r.extension, r.resourceFirstName, r.ResourceLastName,t.teamname from skill s inner join resourceskillmapping rsm on s.skillid = rsm.skillid inner join resource r on rsm.resourceskillmapid = r.resourceskillmapid join team t on r.assignedteamid = t.teamid where s.active = 't' and r.active = 't' order by s.skillname, competencelevel, resourceloginid

You can then load that into Excel or whatever you like.

Aaron