Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
New Member

UCCX 7.0 Current Oldest Call

Does anyone know how to pull the 'Current Oldest' call in queue variable for real-time reporting. It is not a variable in the SQL database since it is live data.

Thanks,

Tom

5 REPLIES
VIP Super Bronze

Re: UCCX 7.0 Current Oldest Call

According to the Database Schema document that I'm looking at (CCX 7.0), the RtCSQsSummary table does include a field for convLongestWaitDuration that shows the "Longest wait duration in HH:MM:SS format".

Cisco Unified Contact Center Express Database Schema Guide, Release 7.0(1): http://cisco.com/en/US/docs/voice_ip_comm/cust_contact/contact_center/crs/express_7_0/user/guide/uccx70dbschema.pdf

If this is not what you are looking for, can you provide a little more detail?

New Member

Re: UCCX 7.0 Current Oldest Call

I see what you are looking at, but what I need is the 'Current Longest Call In Queue', or 'Current Oldest' as it displays in the Supervisor Desktop and the CAD reporting CSQ statistics.

I don't think this is a value that is pulled from the database, but is true 'real-time' data in memory on the UCCX server.

Thanks,

Tom

VIP Super Bronze

Re: UCCX 7.0 Current Oldest Call

Easy enough. Just retrieve two fields from the RtCSQsSummary table: callsWaiting and convOldestContact. CSD is just formatting these together for display purposes.

So [2 3:40:00] in CSD is really [callsWaiting convOldestContact] in SQL. You might want to use convLongestWaitDuration instead of convOldestContact though depending on whether you are assigning callers various priorities or not.

As for how "real-time" this is depends on the settings you have set within CCX Administration.

New Member

Re: UCCX 7.0 Current Oldest Call

Hi Guys,

Any idea how frequent I can query data from Rt* / other uccx tables so that I won't impact the existing uccx processes which are updating them at the same time?

Is querying them every 10 seconds an acceptable level?

Thanks!

-JT-

New Member

Re: UCCX 7.0 Current Oldest Call

I set my wallboard up to query every 10 seconds. I have not seen any negative impact in the few months that I have been using it.

843
Views
0
Helpful
5
Replies
CreatePlease to create content