<div dir="ltr">Glad you got something to work for you. I have never seen anything in the 8k or 16k tables. My guess is that they are going to be used in the future. <br></div><div class="gmail_extra"><br><div class="gmail_quote">On Mon, Nov 28, 2016 at 2:25 PM, Brian Meade <span dir="ltr"><<a href="mailto:bmeade90@vt.edu" target="_blank">bmeade90@vt.edu</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Different table sizes. Most things would use the 4k.<div><br></div><div>I don't remember if it's just certain phone models that have more options that would end up in the 8k and 16k or if it's just based on how many non-default options you have configured that bumps it up into the next level.</div></div><div class="HOEnZb"><div class="h5"><div class="gmail_extra"><br><div class="gmail_quote">On Mon, Nov 28, 2016 at 2:18 PM, Nick Barnett <span dir="ltr"><<a href="mailto:nicksbarnett@gmail.com" target="_blank">nicksbarnett@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span><div dir="ltr"><p class="MsoNormal" style="font-size:12.8px"><span style="font-size:11pt;font-family:calibri,sans-serif">This is incredibly helpful. Thank you. I didn’t find any data in the 16k and 8k tables, but 4k has a LOT. Do you know what the 8k and 16k tables are actually used for?</span></p><p class="MsoNormal" style="font-size:12.8px"><span style="font-size:11pt;font-family:calibri,sans-serif"> </span></p><p class="MsoNormal" style="font-size:12.8px"><span style="font-size:11pt;font-family:calibri,sans-serif">I wrote this AXL call that seems to list out exactly what I was looking for. All of our CSF devices start with “UCCSF”</span></p><p class="MsoNormal" style="font-size:12.8px"><span style="font-size:11pt;font-family:calibri,sans-serif"> </span></p><p class="MsoNormal" style="font-size:12.8px"><span style="font-size:11pt;font-family:calibri,sans-serif"><soapenv:Envelope xmlns:soapenv="<a href="http://schemas.xmlsoap.org/soap/envelope/" target="_blank">http://schemas.<wbr>xmlsoap.org/soap/envelope/</a>" xmlns:ns="<a href="http://www.cisco.com/AXL/API/10.0" target="_blank">http://www.cisco.com<wbr>/AXL/API/10.0</a>"></span></p><p class="MsoNormal" style="font-size:12.8px"><span style="font-size:11pt;font-family:calibri,sans-serif"> <soapenv:Header/></span></p><p class="MsoNormal" style="font-size:12.8px"><span style="font-size:11pt;font-family:calibri,sans-serif"> <soapenv:Body></span></p><p class="MsoNormal" style="font-size:12.8px"><span style="font-size:11pt;font-family:calibri,sans-serif"> <ns:executeSQLQuery sequence="?"></span></p><p class="MsoNormal" style="font-size:12.8px"><span style="font-size:11pt;font-family:calibri,sans-serif"> <sql></span></p><p class="MsoNormal" style="font-size:12.8px"><span style="font-size:11pt;font-family:calibri,sans-serif"> <wbr> SELECT name, description FROM device</span></p><p class="MsoNormal" style="font-size:12.8px"><span style="font-size:11pt;font-family:calibri,sans-serif"> <wbr> WHERE name LIKE 'UCCSF%'</span></p><p class="MsoNormal" style="font-size:12.8px"><span style="font-size:11pt;font-family:calibri,sans-serif"> <wbr> AND name IN</span></p><p class="MsoNormal" style="font-size:12.8px"><span style="font-size:11pt;font-family:calibri,sans-serif"> (SELECT <a href="http://device.name/" target="_blank">device.name</a></span></p><p class="MsoNormal" style="font-size:12.8px"><span style="font-size:11pt;font-family:calibri,sans-serif"> <wbr> FROM devicexml4k INNER JOIN device ON devicexml4k.fkdevice = device.pkid</span></p><p class="MsoNormal" style="font-size:12.8px"><span style="font-size:11pt;font-family:calibri,sans-serif"> <wbr> WHERE <a href="http://device.name/" target="_blank">device.name</a> LIKE 'UCCSF%'</span></p><p class="MsoNormal" style="font-size:12.8px"><span style="font-size:11pt;font-family:calibri,sans-serif"> <wbr> AND devicexml4k.xml LIKE '%1</videoCapability>%')</span></p><p class="MsoNormal" style="font-size:12.8px"><span style="font-size:11pt;font-family:calibri,sans-serif"> </sql></span></p><p class="MsoNormal" style="font-size:12.8px"><span style="font-size:11pt;font-family:calibri,sans-serif"> </ns:executeSQLQuery></span></p><p class="MsoNormal" style="font-size:12.8px"><span style="font-size:11pt;font-family:calibri,sans-serif"> </soapenv:Body></span></p><p class="MsoNormal" style="font-size:12.8px"><span style="font-size:11pt;font-family:calibri,sans-serif"></soapenv:Envelope></span></p></div></span><div class="gmail_extra"><br><div class="gmail_quote"><span>On Mon, Nov 28, 2016 at 12:19 PM, Brian Meade <span dir="ltr"><<a href="mailto:bmeade90@vt.edu" target="_blank">bmeade90@vt.edu</a>></span> wrote:<br></span><div><div class="m_3253216179105533367h5"><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">That's stored in the devicexml16k , devicexml8k, and devicexml4k tables.<br><div><br></div><div>Only non-default values are stored there. It's in XML so can't make a query to check for a certain item. You have to use some post-processing to pull out the values you care about.</div></div><div class="gmail_extra"><br><div class="gmail_quote"><div><div class="m_3253216179105533367m_3456092827792365809h5">On Mon, Nov 28, 2016 at 1:04 PM, Nick Barnett <span dir="ltr"><<a href="mailto:nicksbarnett@gmail.com" target="_blank">nicksbarnett@gmail.com</a>></span> wrote:<br></div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div class="m_3253216179105533367m_3456092827792365809h5"><div dir="ltr">Hello. We are a Cisco phone shop, but use Lync/Skype for IM&P. We also use cucilync. In order to reduce confusion with end users, we've elected to disable video calling from CSF devices and let them do video calls inside Lync/Skype. <div><br></div><div>I batched in a change to all CSF devices to disable video calling. The batch job reports as successful with no errors. Every now and then I come across a CSF device that still has video calling enabled.<div><br></div><div>I was poking around in the informix trying to find a query to run that will list all CSF devices that still have video calling enabled, but I'm striking out. It seems that this information is not housed in the "device" table. I also went through the data dictionary to no avail.</div><div><br></div><div>Maybe there is an easier way to do this, but I just need a report, or query that will show these improperly configured devices. Does anyone know where the "<span style="background-color:rgb(248,248,248);color:rgb(0,0,0);font-family:verdana;font-size:11.2px;font-weight:bold">Product Specific Configuration Layout" </span><span style="background-color:rgb(248,248,248);color:rgb(0,0,0);font-family:verdana;font-size:11.2px">at the bottom of the CSF device config is actually housed and how it is related to the actual CSF device?</span></div><div><span style="background-color:rgb(248,248,248);color:rgb(0,0,0);font-family:verdana;font-size:11.2px"><br></span></div><div><span style="background-color:rgb(248,248,248);color:rgb(0,0,0);font-family:verdana;font-size:11.2px">Thanks,</span></div><div><span style="background-color:rgb(248,248,248);color:rgb(0,0,0);font-family:verdana;font-size:11.2px">Nick</span></div></div></div>
<br></div></div>______________________________<wbr>_________________<br>
cisco-voip mailing list<br>
<a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a><br>
<a href="https://puck.nether.net/mailman/listinfo/cisco-voip" rel="noreferrer" target="_blank">https://puck.nether.net/mailma<wbr>n/listinfo/cisco-voip</a><br>
<br></blockquote></div><br></div>
</blockquote></div></div></div><br></div>
</blockquote></div><br></div>
</div></div><br>______________________________<wbr>_________________<br>
cisco-voip mailing list<br>
<a href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a><br>
<a href="https://puck.nether.net/mailman/listinfo/cisco-voip" rel="noreferrer" target="_blank">https://puck.nether.net/<wbr>mailman/listinfo/cisco-voip</a><br>
<br></blockquote></div><br></div>