Query to find contacts talking to agents

[Elliot Dierksen]

I am working on a wallboard display and I am trying to show what the CSQ of a call for a talking agent. I am trying to replicate the Contact Service Queue column in the "Agents – Team State" display of CSD. If I can figure out a query that identifies talking agents, that is all I need. I can connect the rest of the dots from there.           

[asiddhu]

Hi

I guess you can get the desired result by using the " CCX real time reporting tool "

it shows the real time stats of agents, ( no of agent talking, logged in , CSQ name etc etc )

[Elliot Dierksen]

Yes, RTR does display that information. I was trying to get the same information for a customer wallboard application. Unfortunately there doesn't seem to be any way to get it. :-(

[asiddhu]

Hi

i guess you can display that on wallboard as well

RTR reads that data from 2 tables from UCCX ,

1: RtCSQsSummary table

2:RtICDSummary Table

these 2 tables provide , realtime data on UCCX.

so if you can read those two tables by creating a DSN connection from UCCX to your Wallboard , i think you should be able to display what you want.