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

[Alan Libbee]

Actually, you can query and filter based on the xml data. I wrote some
sample queries for you, hope this helps.

-Alan

This will show you devices with an override for video enabled:
run sql select device.name, device.description, devicepool.name from device
inner join devicexml4k on device.pkid = devicexml4k.fkdevice inner join
devicepool on device.fkdevicepool = devicepool.pkid where devicexml4k.xml
like '%<videoCapability>1</videoCapability>%'

This will show you devices with an override for video disabled:
run sql select device.name, device.description, devicepool.name from device
inner join devicexml4k on device.pkid = devicexml4k.fkdevice inner join
devicepool on device.fkdevicepool = devicepool.pkid where devicexml4k.xml
like '%<videoCapability>0</videoCapability>%'

This will include the xml data if you like:
run sql select device.name, device.description, devicepool.name,
devicexml4k.xml from device inner join devicexml4k on device.pkid =
devicexml4k.fkdevice inner join devicepool on device.fkdevicepool =
devicepool.pkid where devicexml4k.xml like
'%<videoCapability>1</videoCapability>%'

On Mon, Nov 28, 2016 at 1: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
>>
>>
>
> _______________________________________________
> 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/4ff22bf4/attachment.html>