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

[Nick Barnett]

Also very helpful, thanks for the examples!

On Mon, Nov 28, 2016 at 1:09 PM, Alan Libbee <alan.libbee at umuc.edu> wrote:

> 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/a41cb84d/attachment.html>