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

[Brian Meade]

Different table sizes.  Most things would use the 4k.

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.

On Mon, Nov 28, 2016 at 2:18 PM, Nick Barnett <nicksbarnett at gmail.com>
wrote:

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