cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Bookmark
|
Subscribe
|
764
Views
0
Helpful
1
Replies

CUCM 8.6 - SQL SELECT Devices with Video Capabilities.

GarageLand42
Level 1
Level 1

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"

       .   

1 Reply 1

rommelfabro
Level 1
Level 1

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.

Review Cisco Networking for a $25 gift card

Review Cisco Networking for a $25 gift card