Port Inactivity Report

[JM]

Hi Michael,
I noticed you have a script for portusage, I'm unable to download it but was wondering if you could explain how yours works. I'm new to perl so this is going to be interesting to say the least. I noticed the ifdescription, iflastchange, ifadminstatus, ifoperstatus would give me what i need. If i was able to provide a txt file with all the switch ip's and dump the results to an excel sheet, i could filter through what i need. Any help or point in the right direction would be appreciated.

Thank you.

[Michael McNamara]

I've never published the complete script...

In short I use a Perl script to walk the ifIndex table and check the ifInOctets on every port on every switch. I then compare the ifInOctets count from the time the script was previously run, if the number (ifInOctets) hasn't changed it's safe to assume there's been no activity on the port. If you run the script for 30 days, then after 30 days you'll be able to tell which ports have been active and which have been idle (the ifInOctets count hasn't changed in 30 days). I'm just using 30 days as an example, you can use however long you feel comfortable with.

Good Luck!

[Andy]

Hi Michael,

Im interested in viewing your portreport.pl script from your blog, but the link seems to missing. Has it been taken down for any reason?

Thanks
Andy

[Michael McNamara]

Hi Andy and welcome to the forums!

Hmmm... I think I just never got a chance to completely sanitize it. If you give me a day I can probably clean it up and publish a link.

Let me know if you are interested.

Cheers!

[Andy]

That would be great!

thanks
Andy

[Michael McNamara]

Let me clean it up (sanitize it) and I'll post it up.

Cheers!

[Michael McNamara]

Here you go...

http://www.michaelfmcnamara.com/files/scripts/portcount.pl.txt

Enjoy!

[martaz]

Hi Michael
I came across this script and I am interested to explore this how I can use to gather statistic on my switches. Can you tell me how should I execute this scripts of yours?
Sorry I am abit ignorance on scripting.

[Michael McNamara]

Hi Michael
I came across this script and I am interested to explore this how I can use to gather statistic on my switches. Can you tell me how should I execute this scripts of yours?
Sorry I am abit ignorance on scripting.

Hi martaz and welcome to the forums!

You would need a Linux (or Windows) server with Perl and the Net-SNMP modules installed. The Perl script makes calls to the switch equipment utilizing SNMP and then records the ifInOctets for each port. If the number doesn't increase over time then the port is idle. After a variable number of idle days you can physically go reclaim the port.

Good Luck!