<div dir="ltr">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.</div><div class="gmail_extra"><br><br>
<div class="gmail_quote">On Wed, Aug 20, 2014 at 10:45 AM, Matthew Collins <span dir="ltr"><<a href="mailto:mcollins@block.co.uk" target="_blank">mcollins@block.co.uk</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">






<div lang="EN-GB" link="blue" vlink="purple">
<div>
<p class="MsoNormal"><span style="color:#1f497d">Hi Neal, Brian,<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">If I change the command to </span>
<span style="color:#1f497d">Const SQL_Command = "select * from rtcsqssummary” it looks like it is only pulling the Data from the first CSQ.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<div>
<p class="MsoNormal"><span style="color:#1f497d">Regards<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">Matthew<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;color:#bcbec0"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="font-size:14.0pt;font-family:"Arial","sans-serif";color:#bcbec0">ǀ</span><span style="font-size:14.0pt;font-family:"HelveticaNeue LT 45 Light","sans-serif";color:#bcbec0">
</span><span style="font-size:14.0pt;font-family:"HelveticaNeue LT 45 Light","sans-serif";color:#e98300">BLOCK</span><span style="font-size:14.0pt;font-family:"HelveticaNeue LT 45 Light","sans-serif";color:#bcbec0">
</span><span style="font-size:14.0pt;font-family:"Arial","sans-serif";color:#bcbec0">ǀ</span><span style="font-size:14.0pt;font-family:"HelveticaNeue LT 45 Light","sans-serif";color:#1f497d"><u></u><u></u></span></p>

<p class="MsoNormal"><span style="font-size:10.0pt;color:#7f7f7f">Cisco UK&I Solution Innovation Partner of the Year FY15</span><span style="color:black"><u></u><u></u></span></p>
</div>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<div>
<div style="border:none;border-top:solid #b5c4df 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> Haas, Neal [mailto:<a href="mailto:nhaas@co.fresno.ca.us" target="_blank">nhaas@co.fresno.ca.us</a>]
<br>
<b>Sent:</b> 20 August 2014 15:12<br>
<b>To:</b> Matthew Collins; <a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a><br>
<b>Subject:</b> RE: UCCX Wallboard Query<u></u><u></u></span></p>
</div>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><span lang="EN-US" style="color:#1f497d">Does </span><span style="color:#1f497d">Const SQL_Command = "select * from rtcsqssummary” Work?</span><span lang="EN-US" style="color:#1f497d"><u></u><u></u></span></p>

<p class="MsoNormal"><span lang="EN-US" style="color:#1f497d"><u></u> <u></u></span></p>
<div>
<div style="border:none;border-bottom:solid windowtext 1.5pt;padding:0cm 0cm 1.0pt 0cm">
<p class="MsoNormal"><span lang="EN-US" style="color:#1f497d"><u></u> <u></u></span></p>
</div>
<p class="MsoNormal"><span lang="EN-US" style="color:#1f497d">Neal Haas<u></u><u></u></span></p>
</div>
<p class="MsoNormal"><span lang="EN-US" style="color:#1f497d"><u></u> <u></u></span></p>
<div>
<div style="border:none;border-top:solid #b5c4df 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span lang="EN-US" style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> cisco-voip
<a href="mailto:[mailto:cisco-voip-bounces@puck.nether.net]" target="_blank">[mailto:cisco-voip-bounces@puck.nether.net]</a>
<b>On Behalf Of </b>Matthew Collins<br>
<b>Sent:</b> Wednesday, August 20, 2014 6:57 AM<br>
<b>To:</b> <a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a><br>
<b>Subject:</b> [cisco-voip] UCCX Wallboard Query<u></u><u></u></span></p>
</div>
</div><div><div class="h5">
<p class="MsoNormal"><span lang="EN-US"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">Hi All,<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">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.<u></u><u></u></span></p>

<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">Const SQL_Command = "select * from rtcsqssummary where csqname like 'CSQ_IT_Support’"<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">I’m trying to change the line to report on all CSQ collectively but everything I try breaks it.<u></u><u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><span style="color:#1f497d">Thanks in advance<u></u><u></u></span></p>
</div></div></div>
</div>

</blockquote></div><br></div>