cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements

Cisco Community Designated VIP Class of 2020

318
Views
0
Helpful
1
Replies
Highlighted
Beginner

need help! on run sql select ...

Hi All,

I'm now trying to query the mapping of Device + PhoneTemplate + SoftkeyTemplate from cucm, but failed still.

Please anyone help me, what is the query statement to have this output from call manager CLI

It's so urgent I have to live the system very soon.

thanks

Everyone's tags (4)
1 REPLY 1
VIP Mentor

need help! on run sql select ...

Hi,

This query will return the device, description, the device template and the softkey template associated with the devices with description beginning with "lagos"

run sql select d.name as device, d.description, pt.name as PhoneTemplate, sk.name as Softkey from device as d inner join phonetemplate as pt on d.fkphonetemplate=pt.pkid inner join softkeytemplate as sk on d.fksoftkeytemplate=sk.pkid where d.description like 'lagos%' order by softkey

Hope this helps..

Please rate all useful posts

"'Nature is too thin a screen, the glory of the omnipresent God bursts through it everywhere"-Ralph Waldo Emerson

Please rate all useful posts
CreatePlease to create content
Content for Community-Ad
FusionCharts will render here