How to pull bulk POE information from many switches?

[thenetstatman]

Hello all,

I am in an enviroment with hundreds of 3850's and 2960's that I need to pull and give a report on the number of POE ports in use per switch.

I essentially need to do "show power inline" on every switch and give a report on this.

We have Cisco Prime and PRTG. 

Any one have a clue how to do this? I am about to just run a script to do it, however that wont necessarily put everything in nice pretty report.

[mattjones03]

Hi,

I think the best option here would be to use a script. You could use a tool such as Manage Engine Device Expert to execute this against each of the switches you have. The output will likely be a text file that you would need to submit to an FTP server on your infrastructure.

Someone may be able to suggest a tool that could output this information into a report for you.

[Leo Laohoo]

If the PoE devices are sitting on their own "exclusive" IP address subnet then look at DHCP scope.

[Marvin Rhoads · Accepted solution]

Cisco Prime LMS used to have a "netshow" utility however Cisco hasn't seen fit to port that into Prime Infrastructure.

https://bst.cloudapps.cisco.com/bugsearch/bug/CSCuw21935

One contributor came up with a clever work around that may be useful:

https://supportforums.cisco.com/t5/network-management/netshow-in-cisco-prime-3-2-express-plus/td-p/3208164

On the other hand, it's a great excuse to learn one of the open source automation tools and get started with a problem at hand. Look into netmiko or similar tools and get started down the path to being a "full stack engineer".

[thenetstatman]

I figured this would be the general answer. I do have a PowerShell script that lets me execute commands on all my devices, but its not nearly as refined as that Netmiko. I am going to have fun with that! Thanks