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

[Alan Libbee]

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.

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

> 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
>>>>
>>>>
>>>
>>
>
> _______________________________________________
> 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/3c53192a/attachment.html>