topic Re: Getting the Phone button template for Product using SQL in Management

Getting the Phone button template for Product using SQL

AR7 — Mon, 20 Aug 2018 05:25:34 GMT

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.

Re: Getting the Phone button template for Product using SQL

derek.fraser — Mon, 20 Aug 2018 20:05:07 GMT

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'

Re: Getting the Phone button template for Product using SQL

AR7 — Tue, 21 Aug 2018 04:29:00 GMT

Thanks, that worked for me.