Actually, you can query and filter based on the xml data. I wrote some sample queries for you, hope this helps.
-Alan This will show you devices with an override for video enabled: run sql select device.name, device.description, devicepool.name from device inner join devicexml4k on device.pkid = devicexml4k.fkdevice inner join devicepool on device.fkdevicepool = devicepool.pkid where devicexml4k.xml like '%<videoCapability>1</videoCapability>%' This will show you devices with an override for video disabled: run sql select device.name, device.description, devicepool.name from device inner join devicexml4k on device.pkid = devicexml4k.fkdevice inner join devicepool on device.fkdevicepool = devicepool.pkid where devicexml4k.xml like '%<videoCapability>0</videoCapability>%' This will include the xml data if you like: run sql select device.name, device.description, devicepool.name, devicexml4k.xml from device inner join devicexml4k on device.pkid = devicexml4k.fkdevice inner join devicepool on device.fkdevicepool = devicepool.pkid where devicexml4k.xml like '%<videoCapability>1</videoCapability>%' On Mon, Nov 28, 2016 at 1: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
