Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

CUCM 6.1 => Phone Button Template Dependencies

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. 

CUCM 6.1 (or any other version)

Thanks,

Beau

Everyone's tags (4)
3 REPLIES
Cisco Employee

CUCM 6.1 => Phone Button Template Dependencies

Beau,

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.

GP.

Pls rate helpful posts !!

New Member

CUCM 6.1 => Phone Button Template Dependencies

Yes, I'm aware of this option.

I'm looking for a CLI SQL query to capture enough detail to determine which templates are not in use, or in limited use.  A similar string would be from this post:

https://supportforums.cisco.com/message/3541921#3541921

Thanks,

Beau

New Member

Re: CUCM 6.1 => Phone Button Template Dependencies

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

device                               phonetemplate                           

===============          ========================================

NULL                                NotAssigned-SCCP-Individual Template    

NULL                                SEPFFEEDDCCBBAA-SCCP-Individual Template

SEPAABBCCDDEEFF       SEPAABBCCDDEEFF-SCCP-Individual Template

779
Views
5
Helpful
3
Replies