I have been searching through the documentation for the UCCE and bumped into the following issue: the technical documentation presents a database schema and the database itself on the sandbox deployment is missing a lot of tables (for the agents/ historical or real-time).
Could you please provide some help?
Actually I found out that the tables have prefix in their name.
Still, I have a different question - why the real-time data is unavailable in the correspondent tables?
We do not have any traffic generators connected to the UCCX lab right now. There are traffic generators which may be able to achieve what you are looking for i.e camelot, but they are not integrated into the environment currently. Single shot calls are currently available.
It is not about any traffic generator. I make some calls to the contact center (UCCE) and I want to check the database information (live calls, agents status, historical data). Most of the information I am looking for is not present in tables.
Below are the few tables which will give complete data on your requirement,
For "Agent status" particularly you can refer table "Agent Real Time Data" under All Fields Real Time
For "Historical Data" you can refer "All Fields Historical"
For Live calls like, Calls in progress, Calls in Queue, Calls Abandon, you can refer "All Fields Real Time"