cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
936
Views
20
Helpful
9
Replies
Enthusiast

Expansion module inventory report

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

1 ACCEPTED SOLUTION

Accepted Solutions

Here you go then:run sql

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

Aaron Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!

View solution in original post

9 REPLIES 9

HiYou want the 'configured'

Hi

You want the 'configured' expansion modules?

Or the 'actual' power up and registered modules?

Aaron

Aaron Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!
Enthusiast

The configured expansion

The configured expansion modules would be a good start.

Thanks

Here you go then:run sql

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

Aaron Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!

View solution in original post

Enthusiast

Thank you, much appreciated

Thank you, much appreciated

Highlighted
Beginner

Hi Aaron,

Hi Aaron,

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

Beginner

I figured it out.  Thanks

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

Good stuff... if it helps,

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

Aaron Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!
Beginner

Hi Aron. I ran this queries

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

Hi

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

Aaron Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!
CreatePlease to create content
Content for Community-Ad
August's Community Spotlight Awards