Also very helpful, thanks for the examples! On Mon, Nov 28, 2016 at 1:09 PM, Alan Libbee <alan.lib...@umuc.edu> wrote:
> 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 <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 >> >> >
_______________________________________________ cisco-voip mailing list cisco-voip@puck.nether.net https://puck.nether.net/mailman/listinfo/cisco-voip