UCCX 8, Information for wallboard

[ninomartinez]

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

[Przemyslaw Zawadzki]

The following instructions are solving the problem.

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

  ' get the current date and time

  CurrentDateTime = CDate(Date() & " " & Time())

  ' calculate the difference between current date/time and date/time of the last event change

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

  intStatusSeconds = intStatusSeconds - 7200

[Muhammad Fahad Raza]

Apply SU2 and ciscouccx.851SU2COPtwo.cop.sgn

After applying these patces, everything will be ok

[Jason Ward]

Hi guys,

I'm playing around with this wallboard and I'm trying to work something out. The Agent Stats page isn't loading for me, and when I run the SQL query (

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) I'm seeing multiple entries for each Agent (up to 10 or 12 in some instances).

Is this what everyone else is seeing? I have a feeling that the page isn't displaying because of all of the double ups, and the fact that the query is taking around 10 seconds to run.

Any feedback would be very much appreciated

Jason

[Tristan Blackburn]

I use the following query which also gives me additional agent information such as number of calls handled, average ring time, average talk time, max talk time (on UCCX8.5):

"SELECT x.resourceName, t.eventType, x.assignedTeamID, x.datetime, s.handled, s.avring, s.avtalk, s.maxtalk FROM (SELECT t1.resourceID, t1.resourceName, t1.assignedTeamID, MAX(t2.eventDateTime) AS datetime FROM Resource AS t1 INNER JOIN AgentStateDetail AS t2 ON t2.agentID = t1.resourceID and t1.dateInactive is null GROUP BY t1.resourceID, t1.resourceName, t1.assignedTeamID ) AS x INNER JOIN AgentStateDetail AS t ON t.agentID = x.resourceID AND t.eventDateTime = x.datetime INNER JOIN (select resourceid, count(resourceid) as handled, AVG(ringtime) as avring, AVG(talktime) as avtalk, MAX(talktime) as maxtalk from agentconnectiondetail WHERE (startdatetime + INTERVAL(11) HOUR TO HOUR) > TODAY GROUP BY resourceid) AS s ON s.resourceid = x.resourceID WHERE x.assignedTeamID = '22' ORDER BY s.handled DESC, x.assignedTeamID, x.resourceName"

Runs really nicely.

[ausjustin]

Hi Tristan

That’s really great !!!

Can you share your UCCX8 wallboard files to me ?

Many thanks

Justin

[ninomartinez]

No performance issues with the query?

[lmp]

Hello - we are new cisco users and I am trying to set up the wallboard.  I have tried the older wallboard and recieve the following message.

Data source name not found and no default driver specified - even thoug the dsn is set up correctly and I can do queries with the connect test program

When I try a new version of the gila-wallboard - it churns until it times out with the screen displaying 2'COLOR=">

Does anyone have any thoughts?  Our webserver is win 2003 64 bit.

Thank you

[joeharb]

I am having the same issue, did you ever get a fix for this issue?

[michael-rose]

I have this up and running, but the CSQ page shows no data. All other pages show data and I'm using the uccxhruser to poll the database. I have the DSN setup and it shows agent and ICD information, just not the CSQ info.

Looking at the .asp file I do notice the Protocol for the d-base dip is onsoctcp where the DSN uses oslotcp. Is this an issue? The other dips work fine so I'm stumped.

Thanks in advnace.

[michael-rose]

NVM. Triple checked UCCX and I missed a checkbox in the snapshot config page.

[lapkei2]

Any idea on to control the average of Wait and Talk Duration only in last one hour?

What is the default formular of convavgtalkduration and convavgwaitduration?  Average of one day?

The real-time snapshot data writing for these tables is enabled through the Unified CCX Administration pages (Tools > Real-time snapshot configuration menu option). The current updating frequency is configured as 15s

Thanks Bro

[Gergely Szabo]

Bro,

first of all, please share vital information with us. Can you tell us your UCCX version. Can you tell us what do you mean by "control the average of Wait and Talk Duratoin in last one hour"? Do you mean the last completed "calendar" hour or the sliding window 60 minutes interval? For an Agent? For a CSQ?

Thanks.

G.

P.S.: Resurrecting old threads is strongly discouraged.