cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
22613
Views
0
Helpful
41
Replies

UCCX 8, Information for wallboard

ninomartinez
Level 1
Level 1

Hi

We are developing our next generation wallboard. But I just can't seem to figure out how to get information like agent details and SLA levels, is it available through some of the soap api's (could'nt see it from the documentation)?

regards Nino

41 Replies 41

bburney
Level 1
Level 1

Attached is a wallboard that we got here from the forum a while back.  We modified it to work with v8 recently.  The only thing that was modified was the select statement, and added some additional variables on the parameters.cfg.  You'll want to use the uccxhruser because the wallboard user doesn't have access to the necessary tables.

You'll want to change the DB variables in the parameters.cfg to fit your environment as well as the DSN name in the select statement in the wallboard.asp.

You'll also have to install the Informix driver for your ODBC connection.

Hope this helps.

-B

Thanks. But our problem is that using uccxhruser is an unsupported setup from cisco AFAIK.

In our application, which also are a web solution (just on java), we're already looking into the Informix db. But since looking into other tables than Rtcsqssummary and RticdStatistics are not allowed I sort of susspected that there would be another supported way to grab data, for example via some of the SOAP interfaces. But I've been unable to see any possible way so far.

Dear All,

Does any one of them have a step by step procedure for configuring above mentioned wall board in uccx 8.0. if so kindly provide. unable to make it work getting a http forbidden error.

Dear all,

I am able to open the gui but it says it doesnt display any stats. I have an agent logged in and taking calls, Am i missing some thing here

Thanks for the info, now have a fully functional highly flexible system, you can make java drop in extensions etc.

However we are expiriencing that displaying agent status are impacting a huge load on the system (at least one of our customers). My guess are that it's because that we are searching using non indexed columns.. So the question are have any of you other guys had issues with performance?

rgards Nino

camdebuck_jus
Level 1
Level 1

What is a wallboard and how do you use this ASP file?

The wallboard just another way to display real-time stats and the asp page is just a webpage that you'll put on your webserver to view.

-B

Okay, I can get the wallboard.asp file installed in IIS.  However, I can't seem to get the database connection done

correctly.  I'm using Contanct Center Express v8.0.3 (which is a linux installed).

How do I find out the database information for CCX 8.x and connect to it.  I only have one ccx server and my windows 2008 server running IIS.  Any help is appreciated.  Thank you.

You'll have to install the IBM Informix ODBC driver, see this post:

https://supportforums.cisco.com/message/3191314#3191314

Just make sure to change the DSN name in the wallboard.asp to whatever you the name is that you create in the DSN.

-B

Okay, my ODBC is now working.  I am successfully able to click on the "Apply & Test Connect" without any issues.  I've also gone into the .asp file and changed the DSN in the three locations.  I also changed the .cfg file for the db info.

Unfortunately, when I go to my site it shows the following error:

An error occurred on the server when processing the URL. Please contact the system administrator.

If you are the system administrator please click here to find out more about this error.

CSQ Name Logged In Agents Available Agents Calls In Queue Calls Handled Total Calls Calls Abandoned Current Wait Time Longest Wait Time

I does look like it attempts to work as it does display something, but it doesn't want to run.  I'm running this on a windows 2008 server (64 bit).

The logs shows the following information.

#Software: Microsoft Internet Information Services 7.5
#Version: 1.0
#Date: 2010-10-06 16:46:53
#Fields: date time s-ip cs-method cs-uri-stem cs-uri-query s-port cs-username c-ip cs(User-Agent) sc-status sc-substatus sc-win32-status time-taken
2010-10-06 16:46:53 ::1 GET /wallboard/wallboard.asp Stats=CSQ|305|80004005|[Microsoft][ODBC_Driver_Manager]_Data_source_name_not_found_and_no_default_driver_specified 80 - ::1 Mozilla/4.0+(compatible;+MSIE+8.0;+Windows+NT+6.1;+WOW64;+Trident/4.0;+SLCC2;+.NET+CLR+2.0.50727;+.NET4.0C;+.NET4.0E;+.NET+CLR+3.5.30729;+.NET+CLR+3.0.30729) 500 0 0 41
2010-10-06 16:57:11 ::1 GET /wallboard/wallboard.asp Stats=CSQ|305|80004005|[Microsoft][ODBC_Driver_Manager]_Data_source_name_not_found_and_no_default_driver_specified 80 - ::1 Mozilla/4.0+(compatible;+MSIE+8.0;+Windows+NT+6.1;+WOW64;+Trident/4.0;+SLCC2;+.NET+CLR+2.0.50727;+.NET4.0C;+.NET4.0E;+.NET+CLR+3.5.30729;+.NET+CLR+3.0.30729) 500 0 0 37
2010-10-06 16:59:23 ::1 GET /wallboard/wallboard.asp Stats=CSQ 80 - ::1 Mozilla/4.0+(compatible;+MSIE+8.0;+Windows+NT+6.1;+WOW64;+Trident/4.0;+SLCC2;+.NET+CLR+2.0.50727;+.NET4.0C;+.NET4.0E;+.NET+CLR+3.5.30729;+.NET+CLR+3.0.30729) 200 0 0 10
2010-10-06 16:59:33 ::1 GET /wallboard/wallboard.asp Stats=Agent|158|80004005|[Microsoft][ODBC_Driver_Manager]_Data_source_name_not_found_and_no_default_driver_specified 80 - ::1 Mozilla/4.0+(compatible;+MSIE+8.0;+Windows+NT+6.1;+WOW64;+Trident/4.0;+SLCC2;+.NET+CLR+2.0.50727;+.NET4.0C;+.NET4.0E;+.NET+CLR+3.5.30729;+.NET+CLR+3.0.30729) 500 0 0 6
2010-10-06 17:03:47 ::1 GET /wallboard/wallboard.asp Stats=Agent|158|80004005|[Microsoft][ODBC_Driver_Manager]_Data_source_name_not_found_and_no_default_driver_specified 80 - ::1 Mozilla/4.0+(compatible;+MSIE+8.0;+Windows+NT+6.1;+WOW64;+Trident/4.0;+SLCC2;+.NET+CLR+2.0.50727;+.NET4.0C;+.NET4.0E;+.NET+CLR+3.5.30729;+.NET+CLR+3.0.30729) 500 0 0 16
2010-10-06 17:03:53 ::1 GET /wallboard/wallboard.asp - 80 - ::1 Mozilla/4.0+(compatible;+MSIE+8.0;+Windows+NT+6.1;+WOW64;+Trident/4.0;+SLCC2;+.NET+CLR+2.0.50727;+.NET4.0C;+.NET4.0E;+.NET+CLR+3.5.30729;+.NET+CLR+3.0.30729) 302 0 0 32
2010-10-06 17:04:03 ::1 GET /wallboard/wallboard.asp Stats=Agent|158|80004005|[Microsoft][ODBC_Driver_Manager]_Data_source_name_not_found_and_no_default_driver_specified 80 - ::1 Mozilla/4.0+(compatible;+MSIE+8.0;+Windows+NT+6.1;+WOW64;+Trident/4.0;+SLCC2;+.NET+CLR+2.0.50727;+.NET4.0C;+.NET4.0E;+.NET+CLR+3.5.30729;+.NET+CLR+3.0.30729) 500 0 0 6
2010-10-06 17:04:38 ::1 GET /wallboard/wallboard.asp Stats=Agent|158|80004005|[Microsoft][ODBC_Driver_Manager]_Data_source_name_not_found_and_no_default_driver_specified 80 - ::1 Mozilla/4.0+(compatible;+MSIE+8.0;+Windows+NT+6.1;+WOW64;+Trident/4.0;+SLCC2;+.NET+CLR+2.0.50727;+.NET4.0C;+.NET4.0E;+.NET+CLR+3.5.30729;+.NET+CLR+3.0.30729) 500 0 0 6
2010-10-06 17:04:46 ::1 GET /wallboard/wallboard.asp - 80 - ::1 Mozilla/4.0+(compatible;+MSIE+8.0;+Windows+NT+6.1;+WOW64;+Trident/4.0;+SLCC2;+.NET+CLR+2.0.50727;+.NET4.0C;+.NET4.0E;+.NET+CLR+3.5.30729;+.NET+CLR+3.0.30729) 302 0 0 10
2010-10-06 17:04:56 ::1 GET /wallboard/wallboard.asp Stats=Agent|158|80004005|[Microsoft][ODBC_Driver_Manager]_Data_source_name_not_found_and_no_default_driver_specified 80 - ::1 Mozilla/4.0+(compatible;+MSIE+8.0;+Windows+NT+6.1;+WOW64;+Trident/4.0;+SLCC2;+.NET+CLR+2.0.50727;+.NET4.0C;+.NET4.0E;+.NET+CLR+3.5.30729;+.NET+CLR+3.0.30729) 500 0 0 6
#Software: Microsoft Internet Information Services 7.5
#Version: 1.0
#Date: 2010-10-06 17:06:05
#Fields: date time s-ip cs-method cs-uri-stem cs-uri-query s-port cs-username c-ip cs(User-Agent) sc-status sc-substatus sc-win32-status time-taken
2010-10-06 17:06:05 ::1 GET /wallboard/wallboard.asp - 80 - ::1 Mozilla/4.0+(compatible;+MSIE+8.0;+Windows+NT+6.1;+WOW64;+Trident/4.0;+SLCC2;+.NET+CLR+2.0.50727;+.NET4.0C;+.NET4.0E;+.NET+CLR+3.5.30729;+.NET+CLR+3.0.30729) 302 0 0 11
2010-10-06 17:06:06 ::1 GET /wallboard/wallboard.asp Stats=CSQ|305|80004005|[Microsoft][ODBC_Driver_Manager]_Data_source_name_not_found_and_no_default_driver_specified 80 - ::1 Mozilla/4.0+(compatible;+MSIE+8.0;+Windows+NT+6.1;+WOW64;+Trident/4.0;+SLCC2;+.NET+CLR+2.0.50727;+.NET4.0C;+.NET4.0E;+.NET+CLR+3.5.30729;+.NET+CLR+3.0.30729) 500 0 0 7

It looks like it doesn't think the datasource driver isn't there.  Any ideas?

Okay, fixed one problem, but still no data.  I looks like I needed to create a "DSN" (I had created an ODBC).  I've created that and no longer have any errors.  Unfortunately, it doesn't show any information and rotates through the various screens.

Any ideas?

Do you have any agents logged in, or CSQ configured in UCCX?

Also, you need to configure the Real-time snapshot config from the Toos menu.

Yes, agents are logged in.  If I run the real time reporting it shows people, just not in the wallboard.

The real-time snapshot isn't configured currently.  In the snapshot config, what is the Wallboard Server Name and where should I point this?

We just have our webserver's IP.

Here is the admin guide, page 20-4 tells you how to set it up.

http://www.cisco.com/en/US/docs/voice_ip_comm/cust_contact/contact_center/crs/express_8_0/configuration/guide/uccx801ag.pdf

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: