We have a lot of 7914 add on module connected on 7960/7961 model of ip phones.
On ccm 4.X server,how can I know the count of number of 7914 add on modules in the cluster?
I tried through Device >> Phones >> find phones where Device Type...
But does'nt show 7914 expansion module.
The below query will summarise by device pool for you.
SELECT dp.Name, SUM(D.AddOnModules) AS 'Total Expansion Modules'
FROM Device as D, DevicePool as dp
WHERE D.NAME LIKE 'SEP%' and D.fkDevicePool = dp.pkid group by dp.Name;
Please rate useful posts.