[cisco-voip] How to find phones that.....

[Robert Singleton]

On Tue, 2006-11-14 at 16:58 -0500, Tim Reimers wrote:
> 
> Now for something a little more on-topic...
> 
> 
> Does anyone know how to find and export a list of phones that have
> their local SoftKey template set?

Easy with an SQL query...

SELECT Name from Device where fkSoftkeyTemplate IS NOT NULL

will list all the device names that have a Softkey Template set in the
device settings. Change the query to "IS NULL" to list those that do NOT
have one set there.

SELECT Device.Name,SoftkeyTemplate.Name from Device INNER JOIN
SoftkeyTemplate on Device.fkSoftkeyTemplate=SoftkeyTemplate.pkid WHERE
fkSoftkeyTemplate is not null

will list each device *and* the name of the Softkey template in use.

Robert