I would appreciate a solution to my following problem:
I have a relatively simple network: One cisco distribution switch (full layer-3), connected to two acess switches (layer-2 only).
For a particular vlan, I have grabbed the output from the cam tables for both access switches: So now I have a pretty table showing MAC address and the corresponding interface.
On the distro switch, is grabbed the output from the arp table for the same vlan, giving me another pretty table showing the MAC address and the IP address.
How do I go about correlating the two? It's too large for me to do manually. Both tables have a common element: The MAC address. I want to be able to spit out a spreadsheet (or similar) combining all three elements (IP address, MAC address, Interface).
I've tried using bash scripting (which I'm weak on) as well in MS-Excel (which I'm also pretty weak on). Any suggestions?
This is rather urgent so max point guaranteed for first working response!