Solved: 7914 Expansion module count

k.ms · ‎11-20-2007

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

clotheyes · ‎11-21-2007

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.

View solution in original post

gogasca · ‎11-21-2007

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.

k.ms · ‎11-21-2007

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

gogasca · ‎11-21-2007

that query should work

Select proper DB (CCMXXX) from drop down menu.

You can build your query based on the information above

k.ms · ‎11-21-2007

Thanks.It worked.

Can you help me with the query to find number of add on modules per device pool?

Thanks

Kiran

clotheyes · ‎11-21-2007

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.

k.ms · ‎11-21-2007

Tried the query and it works.

Thanks Mark

k6lw · ‎04-28-2010

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

leopoldoruelas · ‎04-07-2017

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'