10-01-2010 05:52 AM - edited 03-14-2019 06:36 AM
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
10-01-2010 07:12 AM
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
10-05-2010 04:06 AM
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.
12-04-2010 01:33 AM
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.
12-04-2010 02:27 AM
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
01-11-2012 02:48 AM
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
10-02-2010 02:16 PM
What is a wallboard and how do you use this ASP file?
10-04-2010 09:42 AM
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
10-05-2010 08:05 PM
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.
10-06-2010 05:49 AM
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
10-06-2010 10:09 AM
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:
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?
10-06-2010 10:16 AM
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?
10-06-2010 11:25 AM
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.
10-06-2010 12:52 PM
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?
10-06-2010 01:00 PM
We just have our webserver's IP.
Here is the admin guide, page 20-4 tells you how to set it up.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide