need help! on run sql select ...

[Akatsukinix]

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

[Ayodeji Okanlawon]

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