Getting the Phone button template for Product using SQL

[AR7]

I am trying to construct the SQL for getting the Phone button template name for a particular product. The following is my query:

select p.name from phonetemplate as p inner join p.tkmodel=typemodel.pkid where typemodel.name="Cisco 6961"

But it's not working. Where am i making the mistake.

[derek.fraser · Accepted solution]

I've struggled with this one before as well.  Not sure what CUCM version you're running but on 11.5 the phonetemplate table uses tkmodel as the identifier for phone button templates which is stored as a numeric value instead of a string.

To view Cisco's defined correlation between numeric value/models you can query the typeproduct table:

select name,tkmodel from typeproduct

The enum value exists in the phonetemplate table as tkmodel so you can inner join on that value:

select p.name from phonetemplate as p inner join typemodel as tm on p.tkmodel=tm.enum where tm.name='Cisco 6961'

[AR7]

Thanks, that worked for me.