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