Switch Port Availability - Network Summary

Question:

How do you classify a port as used or unused? It can be based on:

1. Current interface status - Assume all down to be unused
2. No traffic seen on the interface for x number of days
3. Interface configuration defaulted

Great Question.  For auditing purposes I'd chooose a port that hasnt seen any activity in 90 days. Or is Admin adown.  I really just want a summary count of available switchports by device.

NPM cannot provide such report. If you have engineer's toolset or other SNMP tools, you can try to automate the procedure explained here:

OTOH, if you have NCM installed, it is much easier to pull out automatic report. Others have created SQL reports to automate this. For instance:

Note that this relies on the inventory collection, so make sure you run the inventory job frequent enough to get an accurate report.