[cisco-voip] UCCX Wallboard Query

[Matthew Collins]

Hi Neal, Brian,

If I change the command to Const SQL_Command = "select * from rtcsqssummary” it looks like it is only pulling the Data from the first CSQ.



Regards

Matthew

ǀ BLOCK ǀ
Cisco UK&I Solution Innovation Partner of the Year FY15

From: Haas, Neal [mailto:nhaas at co.fresno.ca.us]
Sent: 20 August 2014 15:12
To: Matthew Collins; cisco-voip at puck.nether.net
Subject: RE: UCCX Wallboard Query

Does Const SQL_Command = "select * from rtcsqssummary” Work?


Neal Haas

From: cisco-voip [mailto:cisco-voip-bounces at puck.nether.net]<mailto:[mailto:cisco-voip-bounces at puck.nether.net]> On Behalf Of Matthew Collins
Sent: Wednesday, August 20, 2014 6:57 AM
To: cisco-voip at puck.nether.net<mailto:cisco-voip at puck.nether.net>
Subject: [cisco-voip] UCCX Wallboard Query

Hi All,

I’ve got a wallboard running but its only reporting on a specific queue per website, I can change the CSQ its reports on by changing name of the CSQ in the below line of code.

Const SQL_Command = "select * from rtcsqssummary where csqname like 'CSQ_IT_Support’"

I’m trying to change the line to report on all CSQ collectively but everything I try breaks it.


Thanks in advance
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20140820/b7a9f2ec/attachment.html>