7914 Expansion module count

Answered Question
Nov 20th, 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

Correct Answer by clotheyes about 9 years 3 months ago

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.

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (1 ratings)
Loading.
gogasca Wed, 11/21/2007 - 00:30

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 Wed, 11/21/2007 - 00:51

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 Wed, 11/21/2007 - 00:58

that query should work

Select proper DB (CCMXXX) from drop down menu.

You can build your query based on the information above

k.ms Wed, 11/21/2007 - 01:07

Thanks.It worked.

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

Thanks

Kiran

Correct Answer
clotheyes Wed, 11/21/2007 - 02:19

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 Wed, 11/21/2007 - 02:51

Tried the query and it works.

Thanks Mark

k6lw Wed, 04/28/2010 - 17:07

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

Actions

This Discussion