cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements

Community Helping Community

655
Views
0
Helpful
6
Replies
Enthusiast

Phone Button Template Device Count?

How/where can I get a count of how many devices is using each of the phone button templates on CUCM 9.1?  

I am well aware of the "Dependency" option when looking at a single phone button template, but that is going to take way to long to check each one.

Trying to avoid having to do a full export of all phones via BAT admin and was hoping there was another option.

Everyone's tags (2)
1 ACCEPTED SOLUTION

Accepted Solutions
Enthusiast

Thank you.  I ended up just

Thank you.  I ended up just doing an export of specific phone details and included the assigned phone button template. 

View solution in original post

6 REPLIES 6
Cisco Employee

Hi,

Hi,

If you need information about some specific Phone Model i can construct a query for the same, let me know the phone model.

JB

Cisco Employee

Hi,

Hi,

below is the list of common device and there ENUM

enum name
===== ======================
9 Cisco 7935
6 Cisco 7910
7 Cisco 7960
8 Cisco 7940
336 Third-party SIP Device (Basic)
374 Third-party SIP Device (Advanced)
115 Cisco 7941
119 Cisco 7971
20000 Cisco 7905
302 Cisco 7985
307 Cisco 7911
308 Cisco 7961G-GE
309 Cisco 7941G-GE
348 Cisco 7931
358 Cisco Unified Personal Communicator
365 Cisco 7921
369 Cisco 7906
375 Cisco TelePresence
30002 Cisco 7920
30006 Cisco 7970
30007 Cisco 7912
30008 Cisco 7902
30016 Cisco IP Communicator
30018 Cisco 7961
30019 Cisco 7936
404 Cisco 7962
412 Cisco 3951
431 Cisco 7937
434 Cisco 7942
435 Cisco 7945
436 Cisco 7965
437 Cisco 7975
446 Cisco 3911
550 Cisco ATA 187
621 Cisco 7821
580 Cisco E20
495 Cisco 6921
36042 Cisco DX80
540 Cisco 8961
681 Cisco ATA 190
683 Cisco 8841
547 Cisco 6901
592 Cisco 3905
585 Cisco 8945
684 Cisco 8851
623 Cisco 7861
537 Cisco 9951
493 Cisco 9971
36217 Cisco 8811
645 Universal Device Templateate
647 Cisco DX650
497 Cisco 6961
622 Cisco 7841
685 Cisco 8861
659 Cisco 8831
496 Cisco 6941
586 Cisco 8941
548 Cisco 6911
564 Cisco 6945

Above i have given you common Phone model and ENUM associated with them, for example you want to know what all phones have "Cisco IP Communicator" template, you can run the below sql query

run sql select name, description, tkmodel from device where tkmodel = '30016'

HTH

JB

Beginner

Re: Hi,

the tkmodel (enum) can be duplicated, I would use the pkid instead.

 

for example

image.png

 

Enthusiast

Thank you.  I ended up just

Thank you.  I ended up just doing an export of specific phone details and included the assigned phone button template. 

View solution in original post

Highlighted
Beginner

Re: Hi,

run sql select count(Device.name) Device_count, phonetemplate.name Device_Type from Device inner join phonetemplate on device.fkphonetemplate=phonetemplate.pkid group by phonetemplate.name

would give

image.png

Everyone's tags (1)
Beginner

Re: Hi,

that sql query

run sql select count(Device.name) Device_count, phonetemplate.name Device_Type from Device inner join phonetemplate on device.fkphonetemplate=phonetemplate.pkid group by phonetemplate.name

would give

image.png

CreatePlease to create content
Content for Community-Ad
FusionCharts will render here