Cisco Systems Switch port consumption report and capacity planning.

Bookmark this page:  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
Switch port consumption report and capacity planning. brickwalls19 07-14-06
Posted by brickwalls19 on July 14, 2006, 1:45 pm
Please log in for more thread options
I have taken the task to do some capacity planning in our server and
user environment.  I would need to take a total of all our Catalyst
switch ports and find the number of used and unused ports.  Is there a
perl script or app that will be able to help gather this information?
It seems tedious to log into every switch, get a 'show port status'
output, and export it to an Excel spreadsheet.  This report would
probably need to be done every month to track the changes in the server
and user environment.  Thanks.


Posted by Walter Roberson on July 14, 2006, 2:19 pm
Please log in for more thread options

If SNMP is available on the switches then you can do many useful
queries using SNMP.

But first you have to define what a "used" port is and an "unused
port" is. It turns out to be a difficult question, once you start
thinking about people turning off systems, people going on vacation,
systems that are plugged in but unusued, systems that simply
haven't had anything to say for awhile. The investigation gets
noticably harder if you have some hubs or unmanaged switches. If
your network staff doesn't already do the kind of tracking necessary
for the above, chances are usually fairly high that someone has
installed an unauthorized switch because ~$20 is a lot cheaper and
faster than getting another authorized jack installed.

Posted by brickwalls19 on July 20, 2006, 10:55 am
Please log in for more thread options
on the instance i do a 'show port status'

connected = used port
not connected = unused port

Walter Roberson wrote:


Posted by J on July 20, 2006, 4:56 pm
Please log in for more thread options
brickwalls19 wrote:

That's fine and dandy if you want stats for that exact moment in time,
say 09:00.  But what about the group of call center people that don't
come in until 13:00?  There's another couple of dozen ports that may be
disconnected when you check the status.  Don't forget about the
executive golf tournament, I mean business retreat that the upper crust
happen to be gone to this week.  There's another 4 dozen ports.  Is
there a bad case of flu going through the office?  There's another
large group of machines that are offline.  The point is port status
means very little if you aren't checking and logging the status of each
individual port over a lengthy period of time.  If you want to get
anything accurate you should instead look at port statistics.  Go
through your interface statistics and look for ports that actually have
carried Ethernet frames.  Any ports that have been used since your last
interface counter clearing will show that they've carried frames, even
if the ports are currently offline.  When you're done clear the
counters.  Do the same thing next week.  Note any changes.  This is as
close as you can get to accurate port counts.  Even this is not
fool-proof.  What about the extra ports in the conference room that are
only used once a quarter to hookup all the misc AV equipment for the
quarterly report, or the 3 dozen ports in the large storage room that
gets cleaned out once a year and used for 3 weeks worth of training?

J


Posted by Walter Roberson on July 20, 2006, 8:46 pm
Please log in for more thread options

Thanks, you saved me a lot of typing along the same vein ;-)

Similar ThreadsPosted
Switch port consumption report and capacity planning. July 14, 2006, 1:45 pm
Internet Bandwidth Capacity Planning November 24, 2006, 9:08 pm
Unused switch port report for 1/3 months September 3, 2008, 10:42 am
6509 power consumption January 24, 2006, 8:07 pm
877 adsl capacity April 2, 2006, 3:59 pm
WLAN Planning January 19, 2007, 2:02 pm
Port mirroring in HP 2626-pwr 24 port switch October 25, 2005, 5:01 am
Change routing port to switch port March 5, 2008, 4:53 am
How to get a report of VPN connections on a PIX July 25, 2007, 9:40 am
How to report bugs to Cisco October 25, 2009, 7:17 am
How to avoid filtered status report - PIX. June 20, 2005, 6:05 pm
Switch port December 14, 2005, 12:09 am
switch port going up and down on specific NIC October 12, 2006, 9:47 am
Problem with Cisco Switch Port Please Help August 23, 2005, 12:43 pm
Filter Switch Port Traffic? February 11, 2009, 10:00 pm
Latest PostsForumRSS
NEWS: Samsung takes on the Apple iPad with the 7 inch Galaxy... Wireless Networking
c3560 port configuration Cisco Systems
Broadband 2010: A Big Slowdown [telecom] General Telecommunications Forum
Control Hot Water Circ Pump With X10? General Home Automation
Official Course CCNP TSHOOT 642-832 / Foundation Learning Gu... Cisco Certification
Speedflow Communications Honored for Innovation Voice-Over-IP
USB _to_ RJ45 (not from) connection Ethernet LAN
FAQ: Maximizing cable modem or DSL speed Cable Modems
CASH FOR CISCO - I BUY USED AND NEW EQUIPMENT & LOTS MOR... Telecom Technical
FAQ: Maximizing cable modem or DSL speed Digital Subscriber Line
How to set up Meridian 1 to "provide clock" to a C... Nortel Networks
New Discovery about WDM LAN and Telecom Cabling
Control Hot Water Circ Pump With X10? Home Automation
Text file to automate restoring a dropped VPN connection. Virtual Private Networks
Home Theater Installation Home Theater
Re: The Turkic Languages in a Nutshell Fiber Optics
sip Video Conferencing
Residential Cabling Guide Home Cabling Guide

Finally, an instantly downloadable book that saves you thousands in home improvement dollars! Enjoy living in 21st century technology-advanced home while increasing its selling value and competitive advantage on the real estate market. Whether your cabling is for home office or high-tech leisure, you can wire your home yourself or learn "wirish" to speak with your cabling contractors in their language!

Click Here to learn more