Does anyone have a CLI query string built for retrieving phone button template dependencies? I'd like to determine how many unused phone button templates there are, and how many phones use each template.
Forgive me if you already are aware of this option & looking for something more than that, but to know how many phones are using each phone button template, you can go to that template config page & on right top side, scroll down to " Dependancy Records " in the field " Related Links " & then click GO.
You should be able to see the phone count using that template.
There's the query I used to identify templates with "Individual". These templates are created when you modifiy the line appearance on the device. I had 599 templates I needed to delete or change to device type templates.
admin:run sql select device.name AS Device, phonetemplate.name AS PhoneTemplate from phonetemplate LEFT JOIN device ON device.fkphonetemplate = phonetemplate.pkid WHERE phonetemplate.name like '%ndividual%' order by device.name
Example Output - the devices showing NULL are the phone templates not assigned (no dependency). While the last template is assigned to the DEVICE - SEPAABBCCDDEEFF
SIP traces provide key information in troubleshooting SIP Trunks, SIP
endpoints and other SIP related issues. Even though these traces are in
clear text, these texts can be gibberish unless you understand fully
what they mean. This document attempts to br...
Please find the attached HTML document, download and open it on your PC.
This provides an easy to use form where you simply answer a few
questions and it will render the proper jabber-config.xml file for you
to copy/paste. There is built in logic to verif...
CUCM Database Replication is an area in which Cisco customers and
partners have asked for more in-depth training in being able to properly
assess a replication problem and potentially resolve an issue without
involving TAC. This document discusses the bas...