IPCCX Wallboard Application

[richard.jackson]

Hi, I hope someone can point me in the correct direction.

I am working with our Dev time to write a wallboard application to connect to IPCCX 7.

Our connection string to the SQL database is working and we can get historical data such as calls for that day, however we are having difficulty getting the following live stats:-

Agents logging in

Agents ready

Calls in queue

Longest waiting in Queue

SLAs

Could someone point me to the correct tables in the SQL database or advise me where to find this data.

Kind regards

Richard

[Aaron Harrison · Accepted solution]

Hi Richard

Take a look at the DB Schema document: http://www.cisco.com/en/US/docs/voice_ip_comm/cust_contact/contact_center/crs/express_7_0/user/guide/uccx70dbschema.pdf

Agents Login/Ready - will be the latest events written to the AgentStateDetail table

Calls In Queue/Longest Waiting - will be in the RTCsqSummary tables

Service Level - best to calculate this from the data in other tables.

Regards

Aaron

Please rate helpful posts...

[richard.jackson]

that just what i needed