

- #Show mac address table cisco export to excel how to#
- #Show mac address table cisco export to excel Patch#
- #Show mac address table cisco export to excel software#
When you use the command, you have to go to each switch and run the command. With the command, you can figure out which MAC address is on which port. (The MAC address table is truncated for brevity.) Total Mac Addresses for this criterion: 5 Here is an example: switch# show mac-address-table The easiest way to see which Ethernet MAC address is on which port is to use the show mac-address-table command. If you know of any open source products that map switch ports, please post your recommendations in the article discussion. Note: My search didn’t turn up any free open-source products. The suite runs about $1,400, and the company offers a 30-day evaluation.


See the ManageEngine site for detailed pricing information. ManageEngine offers the Switch Port Mapper Tool, which handles multiple brands of switches and imports cable port mappings.The standalone price for the tool is $199, and there is 15-day free trial. It works with different brands of switches it shows VLAN assignments and it exports to a spreadsheet. Northwest Performance Software’s Managed Switch Port Mapping Tool uses SNMP to communicate with switches and to find out what is attached where.Here are a few that I think are worth checking out.
#Show mac address table cisco export to excel software#
There are a vast number of software applications out there to help you in this situation. This solution tries to solve three issues: (1) ports going unused (porttracker refers to this as port wastage) (2) reduce downtime and know “what is connected where” (3) identify at-risk ports. K.-based company offers a dedicated appliance called porttracker that maps your network for you. An appliance solutionĪt Interop 2007, I spotted an interesting solution from porttracker. Here are various solutions that may help you determine which device is connected to which port on your Cisco switch. If you could tell which MAC address is on which switch port, you could identify the PC and either shut down the switch port or go to the office where the PC is and shut it down.
#Show mac address table cisco export to excel Patch#
You know that the PC must be connected to any one of a few hundred Ethernet patch panel ports in the network room those switch ports go to ports on the Ethernet switch. Now you need to find the location of the PC. From the packet, you get the MAC address. From your protocol analyzer, you see that an IP address is flooding the network with unidentifiable traffic.

The first step is to fire up your network protocol analyzer and capture data off of the core switch. All the switch port lights are solid, and your only theory is that the network is under attack. Your network grinds to a screeching halt. David Davis discusses network analysis applications and switch port mapping tools that you want to have in place before you're in crisis mode. When your network is in crisis, it's important to know which device is connected to which switch port without having to run to the network room.
#Show mac address table cisco export to excel how to#
How to determine what device is on what port on your Cisco switch
