[cisco-voip] UCCX Wallboard Query

[Brian Meade]

Are you just checking this by viewing the webpage?  Might be worth to use a
database browser to take a look at the raw data.  Something like RazorSQL
should work for that.


On Wed, Aug 20, 2014 at 10:45 AM, Matthew Collins <mcollins at block.co.uk>
wrote:

>  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] *On Behalf
> Of *Matthew Collins
> *Sent:* Wednesday, August 20, 2014 6:57 AM
> *To:* 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/7732792d/attachment.html>