Need some help with interface counters. I’m in somewhat of a Catch-22. Here’s my Scenario, so please bear with me for a moment. We have 50+ remote locations. We have regional techs that maintain and connect our PCs and other peripherals at these locations. In their daily haste, there are a lot of interfaces that are left connected on the switch from the patch panel, but no devices at the wall jacks. Inevitably, I will get a call that the switch is full, where in reality it was just a case of them not cleaning up the data cables during moves or removal of equipment.
I’ve written a Perl script that goes out to the switches that they want to clean up, gather the counters from all of the interfaces, and report on the ones that have zero Bytes-IN (OID 188.8.131.52.184.108.40.206.1.10.x) AND zero Bytes-OUT (OID 220.127.116.11.18.104.22.168.1.16.x) which gets sent to me in an E-mail that I forward to them. This tells them which interfaces have not been used. I also report on the switch uptime, so they can determine if it’s been unused for long enough. It’s a nice report which gets e-mailed in a concise format. The trouble is that I have to run the report for them. I realize there are methods to get them this report so they can run it by themselves, but we’re trying to encourage Orion NPM for this type of information.
Here’s what they get now from the Perl Script in an E-mail:
Mon Aug 24 17:38:46 2009
Ports with no Usage for Brookfield sw-21-01
WS-C3560-48PS-S S/N:555555555 (10.21.2.1)
System Uptime: 392 days, 22:29:57.33
FastEthernet0/15 Bytes In: 0 Bytes Out: 0
FastEthernet0/24 Bytes In: 0 Bytes Out: 0
FastEthernet0/46 Bytes In: 0 Bytes Out: 0
Ports with no Usage for Brookfield sw-21-02
WS-C3560-48PS-S S/N: 555555556 (10.21.2.2)
System Uptime: 392 days, 22:30:00.58
FastEthernet0/2 Bytes In: 0 Bytes Out: 0
FastEthernet0/5 Bytes In: 0 Bytes Out: 0
FastEthernet0/6 Bytes In: 0 Bytes Out: 0
FastEthernet0/9 Bytes In: 0 Bytes Out: 0
FastEthernet0/32 Bytes In: 0 Bytes Out: 0
FastEthernet0/45 Bytes In: 0 Bytes Out: 0
The Catch-22 is that I can report on the counters in Orion, but that means that I have to monitor all of the interfaces on all of the switches (over 8,000 interfaces). If I monitor all of the interfaces, I’ll be gathering a whole lot of unnecessary clutter that I really am not interested in. Not to mention the up/down status every time someone shuts down a PC as well as the unused ports that will be “down” at all times.
I would like to create a new UDP that will gather the interface counter information once a day and then I can generate a report for them to run with ONLY the unused (zero count) interfaces. Or what would be even better is I would like to present the information on a “View” for them to look at that shows ONLY the unused interfaces on a switch with uptime information.
Any advice or help creating this information would be appreciated.