CUCM 8.6 - SQL SELECT Devices with Video Capabilities.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-16-2012 06:45 PM - edited 03-01-2019 10:37 AM
I am looking to run some kind if report that will give me all deivces that have - "Video Capabilities Enabled."
I am trying something
run sql select * from device where name = 'SEP######' which is given me what appears to everything I might need, but don't what field to focus on.
I've tried
run sql select name, description, tkmodel, tkstatus_builtinbridge, from device where tkstatus_builtinbridge = '1' and tkmodel = "3006"
.
- Labels:
-
Unified Computing System (UCS)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-01-2014 08:01 PM
Saw the post was 2 years ago and no solution update. This should help others who would need this kind of query for cucm 8.6:
run sql select device.name,device.description,device.tkmodel,device.pkid from device,devicexml4k where device.name like "%SEP%" and device.tkmodel=585 and device.pkid=devicexml4k.fkdevice and devicexml4k.xml like "%<videoCapability>1</videoCapability>%"
the query looks horrible and can be impoved but it gets the job done :). This seaches for device model Cisco 8945 specifically.
