[cisco-voip] Query or report to find devices that have video calling enabled?

[Nick Barnett]

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?



I wrote this AXL call that seems to list out exactly what I was looking
for. All of our CSF devices start with “UCCSF”



<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:ns="http://www.cisco.com/AXL/API/10.0">

   <soapenv:Header/>

   <soapenv:Body>

      <ns:executeSQLQuery sequence="?">

         <sql>

                                SELECT name, description FROM device

                                WHERE name LIKE 'UCCSF%'

                                 AND name IN

                                (SELECT device.name

                                 FROM devicexml4k INNER JOIN device ON
devicexml4k.fkdevice = device.pkid

                                 WHERE device.name LIKE 'UCCSF%'

                                  AND devicexml4k.xml LIKE
'%1</videoCapability>%')

                    </sql>

      </ns:executeSQLQuery>

   </soapenv:Body>

</soapenv:Envelope>

On Mon, Nov 28, 2016 at 12:19 PM, Brian Meade <bmeade90 at vt.edu> wrote:

> That's stored in the devicexml16k , devicexml8k, and devicexml4k tables.
>
> 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.
>
> On Mon, Nov 28, 2016 at 1:04 PM, Nick Barnett <nicksbarnett at gmail.com>
> wrote:
>
>> 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.
>>
>> 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.
>>
>> 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.
>>
>> 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 "Product Specific Configuration Layout" at the bottom of the
>> CSF device config is actually housed and how it is related to the actual
>> CSF device?
>>
>> Thanks,
>> Nick
>>
>> _______________________________________________
>> cisco-voip mailing list
>> cisco-voip at puck.nether.net
>> https://puck.nether.net/mailman/listinfo/cisco-voip
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20161128/16cfd688/attachment.html>