Expansion module inventory report

[Emad Wahba]

How can I generate a report of all phones with Expansion module attached in CUCM 9.1?

[Aaron Harrison]

Hi

You want the 'configured' expansion modules?

Or the 'actual' power up and registered modules?

Aaron

[Emad Wahba]

The configured expansion modules would be a good start.

Thanks

[Aaron Harrison · Accepted solution]

Here you go then:

run sql select d.name, 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

If you wanted to see which ones actually have a module working you'd need to get that directly from each phone, which is more difficult...
Aaron

[Emad Wahba]

Thank you, much appreciated

[Joe Bohelski]

Hi Aaron,

     From where does this get run?  Would it be the CLI on the pub or sub?

[Joe Bohelski]

I figured it out.  Thanks anyway, and to Emad for posting the original question.

[Aaron Harrison]

Good stuff... if it helps, please rate it :-)

[FPENTEADO]

Hi Aron. I ran this queries and everything worked fine. So, I'vee seen the Phines with Module. How can I run other queries in order to show me how of "theses" are with Module  working on?

Regards

[Aaron Harrison]

Hi

AXL only allows access to configuration information, not 'live' registration status.

For that you would need to look at the RIS API or check the phone's web server.

Aaron