08-19-2018 10:25 PM
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.
Solved! Go to Solution.
08-20-2018 01:05 PM
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'
08-20-2018 01:05 PM
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'
08-20-2018 09:29 PM
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide