CUCM 8.6 - SQL SELECT Devices with Video Capabilities.

[GarageLand42]

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"

       .   

[rommelfabro]

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.