Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

UCCX 8, Information for wallboard

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
New Member

Re: UCCX 8, Information for wallboard

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

New Member

Re: UCCX 8, Information for wallboard

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.

New Member

Re: UCCX 8, Information for wallboard

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.

New Member

Re: UCCX 8, Information for wallboard

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

New Member

UCCX 8, Information for wallboard

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

New Member

Re: UCCX 8, Information for wallboard

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

New Member

Re: UCCX 8, Information for wallboard

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

New Member

Re: UCCX 8, Information for wallboard

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.

New Member

Re: UCCX 8, Information for wallboard

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

New Member

Re: UCCX 8, Information for wallboard

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?

New Member

Re: UCCX 8, Information for wallboard

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?

New Member

Re: UCCX 8, Information for wallboard

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.

New Member

Re: UCCX 8, Information for wallboard

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?

New Member

Re: UCCX 8, Information for wallboard

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

New Member

Re: UCCX 8, Information for wallboard

Okay, hopefully last issue.  When on the Agent Statistics screen it shows negative time in status.  Why is that and is there any way I can fix?

Customer Service Representative Current Status Time in Status Benson MarshReady-1 days / 23:01:45 Britney ClementLogged Out0 days / 18:59:03 Elisa BalderasLogged Out0 days / 0:26:21 Hailey ArvidsonReady-1 days / 23:02:47 Isaac GowonNot Ready-1 days / 23:00:12 Kathy RiosReady-1 days / 23:00:51 Sofia OcampoLogged Out0 days / 18:58:53

New Member

Re: UCCX 8, Information for wallboard

Here's a better shot of the wrong data.  As you can see it shows 23 hours and -1 Days:

Agent Statistics

(click here to unhold page)


Customer Service Representative Current Status Time in Status
Benson MarshReady-1 days / 23:04:37
Britney ClementLogged Out0 days / 19:01:55
Elisa BalderasLogged Out0 days / 0:29:13
Hailey ArvidsonReady-1 days / 23:00:52
Isaac GowonReady-1 days / 23:01:25
Kathy RiosNot Ready-1 days / 23:02:05
Sofia OcampoLogged Out0 days / 19:01:45

This page will update every 10 seconds

New Member

Re: UCCX 8, Information for wallboard

Try to replace the intStatusSeconds in the CalculateStatusTime subroutine with this.

intStatusSeconds = DateDiff("s",EventHappenedDateTime,CurrentDateTime)

Sorry - Modified the orginal to fit our timezone, etc.

Also attached is the blink, just rename from .abc to .htc and place in your wallboard folder.

-B

New Member

Re: UCCX 8, Information for wallboard

Okay, I added the .htc file and made the change to the IntStatusSeconds.  It changed it a little bit, but still off 

What exactly does that IntStatusSeconds need to be set to?  Does it need to be set to seconds for the current date/time for my time zone?  I just hate to keep bothering you like this, but we are almost there.

Here's what it looks like now:

Agent Statistics

(click here to unhold page)


Customer Service Representative Current Status Time in Status
Benson MarshNot Ready-1 days / 18:14:23
Britney ClementReady-1 days / 18:01:13
Elisa BalderasLogged Out-1 days / 19:55:53
Hailey ArvidsonNot Ready-1 days / 18:01:11
Isaac GowonReady-1 days / 18:00:25
Kathy RiosReady-1 days / 18:00:07
Sofia OcampoLogged Out0 days / 14:28:25

New Member

Re: UCCX 8, Information for wallboard

You might want to put it back, and just change the .20833 until it fits the time your looking for.  Also, you might need to add time instead.

intStatusSeconds = DateDiff("s",(EventHappenedDateTime - .20833),CurrentDateTime)

-B

I believe the time is epoch and UTC, hope this helps a little to help find out what value you need.

New Member

Re: UCCX 8, Information for wallboard

Okay, I got the time correct by setting it to the following:

intStatusSeconds = DateDiff("s",(EventHappenedDateTime - 0.25000),CurrentDateTime)

Thank you for your help in getting this working.  Now I'll need to download one of the SQL Clients so I can take a look at the tables and see what additional things I can do

New Member

UCCX 8, Information for wallboard

I am having the same issue; and I am in PST... what would you change to get correct time?  When I have max day at 1 it does not display, I must change it to 2 in order for it to display.

Thanks

Re: UCCX 8, Information for wallboard

I'm very surprised you were able to retrieve Agent level detail in UCCX 8, considering the only table which should be readable are the two Real Time tables.

What user did you use to setup your DSN?

Anthony Holloway

Please use the star ratings to help drive great content to the top of searches.
New Member

Re: UCCX 8, Information for wallboard

I used the "uccxhruser".  Unfortunately, I don't know much about this and am just using what other people have suggested.

Re: UCCX 8, Information for wallboard

Oh, yeah, that would explain it.  I wonder how this is going to play out in the future, with Cisco moving to UCOS for the added security/restrictions, and people are finding loop holes every week.

Anthony Holloway

Please use the star ratings to help drive great content to the top of searches.
New Member

Re: UCCX 8, Information for wallboard

Not Sure if anyone is having or has had this issue with resetting the Wallboard after the switch from SQL to Informix. I have downloaded the newest Informix Driver and installed it on our Windows 2003 IIS Server. When I try to connect to the IPCC Server Via the IBM Informix ODBC Driver Setup I get:

IBM Informix ODBC Error Message-

Test connection was NOT successful, [Informix] [Informix ODBC Driver][Informix] Incorrect password or user uccxwallboard@servername.ad.com is not known on the database server.

For some reason no matter what username I put it appends the @servername.ad.com to the username and denies login.

Any help would be appreciated.

Thanks

New Member

Re: UCCX 8, Information for wallboard

Same issue here that Michael had

IBM Informix ODBC Error Message-

Test connection was NOT successful, [Informix] [Informix ODBC Driver][Informix] Incorrect password or user uccxwallboard@servername.ad.com is not known on the database server.

Any solution?  anyone? Beuller?

New Member

UCCX 8, Information for wallboard

Your username incorrect...

Reporting user :

uccxhruser


Wallboard user:

uccxwallboard


The password for the wallboard user that has been configured. You can change the password by going to Tools > Password Management submenu option from the Unified CCX Administration menu bar

New Member

UCCX 8, Information for wallboard

UCCX 8.0.2.SU3

user:uccxhruser

Hello, I am having issues getting the current agent state to show correctly.  I only see agents that have logged off, with the correct duration of time since they have logged off and one agent when she sets herself to not ready.  With agents in the CSQ's I don't see the talking states, working, etc.

All other aspects of the wallboard script is working correctly.  Does anybody have any suggests as to what I should be looking at?  The wallobard.asp file is pretty much as is with out customization. 

The only thing I can think of is that the select statement might be incorrect?

strSQL = "SELECT x.resourceName, t.eventType, x.datetime FROM (SELECT t1.resourceID, t1.resourceName, MAX(t2.eventDateTime) AS datetime FROM Resource AS t1 INNER JOIN AgentStateDetail AS t2 ON t2.agentID = t1.resourceID GROUP BY t1.resourceID, t1.resourceName ) AS x INNER JOIN AgentStateDetail AS t ON t.agentID = x.resourceID AND t.eventDateTime = x.datetime ORDER BY x.resourceName"

Thank you for any suggestions you might have.

New Member

UCCX 8, Information for wallboard

Hello!

I get error in START CALC STATUS TIME MODULE. On web page I see:

Microsoft VBScript runtime

error '800a0009'

Subscript out of range: '[number: 2]'

/wallboard.asp, line 539

As I understand - this mean error in:

EventHappenedDateTime = CDate(strArray(0) & " " & strArray(1) & " " & strArray(2))

Somebody had such problem? The same problem is described here

http://social.msdn.microsoft.com/Forums/en/vbgeneral/thread/667f6e02-e09f-461e-8bdf-702d229fe361

Might you help me to solve this problem?

18421
Views
0
Helpful
41
Replies