Phone Button Template Device Count?

[magnum629]

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.

[Jitender Bhandari]

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

[Jitender Bhandari]

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

[lp.descamps]

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

for example

[magnum629 · Accepted solution]

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

[lp.descamps]

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

[lp.descamps]

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