CUIC UCCX 9.0.1 Real Time reports

[davor.vragovic]

Hi, I have a problem with importing Real time reports.

Release notes state that appropriate Data source should be configured before importing Real Time report templetes.

CUIC user guide  states that UCCE Historical and UCCE Real Time data sources exist by  default upon fresh installation. However, in my case, there are only CUIC and UCCX datasouces configured by default (UCCX pointing to db_cra). Should I create a UCCE Real Time Data source? What database/user should it use? 

I'm running CUIC as a part of UCCX, not on standalone server.

Kind Regards,

Davor

[Gergely Szabo]

Hi,

why do you want to integrate your CUIC with UCCE if you don't have UCCE? Can you please give us more details.

G.

[davor.vragovic]

Hi,

I don't want to integrate it wiith CCE, but it is the only thing that I found in CUIC documentation related to my problem.

Basically, what I want to do is use Real time reporting capability of CUIC to set up a wallboard for our Call Centar. If I understood correctly, this is possible (Plase correct me if I'm wrong).  Since there were no Real Time reporting templates available in CUIC when I initially installed it, i figured I could download report templates from cisco site and install them, but now that we're talking about them, they are CCE templates actually (there were no CCX templates available for download). So perhaps the main question is can I use CUIC for real time reporting if I have CCX?

[Aaron Harrison]

Hi Davor

My understanding is that the ability to auto-refresh reports (i.e for a wallboard or any other realtime type thing) isn't in 9.0, but will be in a future release.

Aaron

[Gergely Szabo]

Hi,

well, you can certainly integrate CUIC with UCCX, but why would you do that. I mean, the UCCX database schema is available and documented, and you can easily create your wallboard solution without CUIC, just by talking to the UCCX database.

G.

[davor.vragovic]

Hi,

I am aware of that but I'm not that good at coding. Also, I figured that if  real time reports already exist for CUIC and you can configure them  with permalinks etc. it would be better to use something that already exists rather than something you need to develop.

Still can I configure them on CCX? I would cetainly like to set them up if it is possible, regardless of auto-refresh disability.

[Gergely Szabo]

Hi,

well, never did that, but technically, yes, it might be possible. I mean, CUIC can talk to an Informix database, and UCCX is sitting on a top of an Informix database, so... well, yes, but I might be wrong. Aaron, Anthony, your opinion, please.

A quick search returned this thread: https://supportforums.cisco.com/message/3426248#3426248 but there isn't a yes or no either.

G.

[Aaron Harrison]

Hi Gergely

I think what the OP is getting at is that in 9.x they have introduced CUIC as a built in feature to replace the legacy HRC app with UCCX.

I've not personally played with CUIC, but I believe if you want something other than the canned reports you must purchase the lab (customer) or NFR (partner) CUIC Premium for $100 or whatever it is - you then built reports on that, export, and import to UCCX CUIC.

If the realtime stuff isn't in what Cisco provide, then that's probably what you need to do.

And the realtime 'stuff' is basically two tables - rtcsqssummary and rticdstatistics that are in db_cra, so if you are attached to that you should be able to query those as you do anything else.

In future with some sort of auto-refresh capability you might be able to build a pretty effective, on-box wallboard.

Aaron

[davor.vragovic]

Yes, I was reffering to CUIC as a built in feature of UCCX. In the meantime I installed CUIC as a standalone server on ESX. Data sources which I mentioned in first post (UCCE Historical and UCCE Real Time) exist by default as documentation stated but they are not configured and type of connection cannnot be changed - they are set up for SQL, not Informix.

I set up new data source with the following configuration:

database name: db_cra

user id: uccxhruser

pass: password I set up in UCCX->Tools->Password Management for Historical Reporting user

Connection to database was ok, data source was marked online but import of Real time reports template failed. I also tried using uccxwallboard user instead of uccxhruser but without success.

[davor.vragovic]

In the meantime I got information from TAC that Real Time reports are not available for CUIC with UCCX 9.x. It is planned to be supported in UCCX 10.

[Graham Old · Accepted solution]

You have to create your report on a premium version of CUIC, you can then export it and import it into CCX.

Are you trying to create a wallboard type display? this is from my lab system not a customer.

If you import the attached zip you will be able to create this display. This reads the rtCSQssummary table so remember to enable it it in "Real Time Snapshot Config"

Graham

[davor.vragovic]

Hi Graham,

This is what I was looking for. Thank you!

I was trying to create a wallboard type display. So if I got this right, if I don't have a premium version I can't create report definitions? Was this created from the scratch or you used avaliable template from cisco site and modified it?

[Graham Old]

That is correct you can only create a report definition (SQL) using the premium version.

This was created from scratch on a premium CUIC and then exported.

You can get a 60 day trial license of the premium version from the usual licensing web site.

Graham

[rcrumm_2]

HI,

I have enhanced licensing and tried to import this zip file but it failed.

Import could not be completed: 1 Report failed to import. Please check  the logs - Query validation failed - The specified table (rtcsqssummary)  is not in the database.

Is this because i do not have premium licensing?

I am using UCCX 9.0.2

Thanks,

Randall

[sarbarnes]

Hi Graham, I have downloaded your wallboard zip file, and whilst it works in our lab great, when I have imported it into the customer enviroment, the QueueName is blank andthe refresh list does not work!

Any ideas?