11-20-2007 08:01 PM - edited 03-15-2019 07:21 AM
Hi,
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.
Thanks
Kiran
Solved! Go to Solution.
11-21-2007 02:19 AM
Kiran,
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;
Regards,
Mark.
Please rate useful posts.
11-21-2007 12:30 AM
Use this query:
Go to Start-> Program-> Microsoft SQL Server-> Query Analyzer-> Select
local Windows Authetication-> From the drop down box of databases,
select CCM030x ( x is thelastest integer, If you have not upgraded the
Call Manager you will have CCM0300 database).
Paste this query and execute it. Heres the query
SELECT SUM(AddOnModules) AS 'Total Expansion Modules' FROM Device WHERE
NAME LIKE 'SEP%'
Actually the 7914 is not a Device type but a module, and in CCM DB is populated when you enable the Expansion Module 1 or 2 for the devices that support it.
11-21-2007 12:51 AM
Thanks for replying.
Tried running,but got error "Invalid object name 'Device'".
Also can I pull the count based on device pool ie i want number of 7914 expansion module per device pool.
Thanks
Kiran
11-21-2007 12:58 AM
that query should work
Select proper DB (CCMXXX) from drop down menu.
You can build your query based on the information above
11-21-2007 01:07 AM
Thanks.It worked.
Can you help me with the query to find number of add on modules per device pool?
Thanks
Kiran
11-21-2007 02:19 AM
Kiran,
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;
Regards,
Mark.
Please rate useful posts.
11-21-2007 02:51 AM
Tried the query and it works.
Thanks Mark
04-28-2010 05:07 PM
For UCM 7 try this at the command prompt (CLI)
Locate expansion modules (Cisco 7914 "Sidecar"):
run sql select D.description,TM.name,TC.name,DP.name from deviceaddonmodulemap as DAM, device as D, devicepool as DP, typemodel as TM, typeclass as TC where DAM.fkdevice=D.pkid and DAM.tkmodel=TM.enum and D.fkdevicepool=DP.pkid and TM.tkclass=TC.enum
04-07-2017 03:17 PM
I know this was answered already but if you run these commands in the CLI for the Publisher it'll return what you need if all you need is a device count.
run sql select * from DeviceAddonModuleMap
The command below is if you know the enumeration number, in this case the Cisco 7914 module was 124.
run sql select * from DeviceAddonModuleMap where tkmodel='124'
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