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 <[email protected]> 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 <[email protected]> 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 <[email protected]> >> 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 >>> [email protected] >>> https://puck.nether.net/mailman/listinfo/cisco-voip >>> >>> >> >
_______________________________________________ cisco-voip mailing list [email protected] https://puck.nether.net/mailman/listinfo/cisco-voip
