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 <bmead...@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 <nicksbarn...@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@puck.nether.net >> https://puck.nether.net/mailman/listinfo/cisco-voip >> >> >
_______________________________________________ cisco-voip mailing list cisco-voip@puck.nether.net https://puck.nether.net/mailman/listinfo/cisco-voip