topic Re: UCCE Sandbox database missing tables in DevNet Sandbox

UCCE Sandbox database missing tables

shovalcohen — Tue, 04 Jun 2019 09:28:24 GMT

Hello,

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?

Re: UCCE Sandbox database missing tables

shovalcohen — Mon, 30 Jan 2017 11:02:14 GMT

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?

Re: UCCE Sandbox database missing tables

jokearns1 — Mon, 30 Jan 2017 13:22:12 GMT

Hi Shoval,

Can you specify what you mean by real time traffic? Are you looking for bulk call generation in this sandbox?

Thanks,

Joe

Re: UCCE Sandbox database missing tables

shovalcohen — Mon, 30 Jan 2017 14:36:21 GMT

Real-time traffic - calls that are in progress (in queue or picked up by agents) and agents status.

Re: UCCE Sandbox database missing tables

jokearns1 — Tue, 31 Jan 2017 17:11:40 GMT

Hi Shoval,

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.

Regards,

Joe

Re: UCCE Sandbox database missing tables

shovalcohen — Tue, 31 Jan 2017 20:02:33 GMT

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.

Re: UCCE Sandbox database missing tables

Gokul Kumaar — Fri, 03 Feb 2017 07:22:12 GMT

Hi Shoval,

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

Reference :Cisco Unified Contact Center Enterprise Reporting User Guide 10.5(1) - All Fields Real Time [Cisco Unified Contact Cent…

For "Historical Data" you can refer "All Fields Historical"

Reference : Cisco Unified Contact Center Enterprise Reporting User Guide 10.5(1) - All Fields Historical [Cisco Unified Contact Cen…

For Live calls like, Calls in progress, Calls in Queue, Calls Abandon, you can refer "All Fields Real Time"

Reference : Cisco Unified Contact Center Enterprise Reporting User Guide 10.5(1) - All Fields Real Time [Cisco Unified Contact Cent…

Regards,