• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2300
  • Last Modified:

Export MAC addresses and ARP data from Cisco and/or 3Com switches/routers into mySQL?

I'd like to export MAC address and ARP data from Cisco and/or 3Com switches/routers into a  database to create an IP to port mapping.    I'd like to be able to automate the export via some type of scripting if possible.  Any ideas on how this might be accomplished would be appreciated.

0
pbeirne
Asked:
pbeirne
  • 2
  • 2
1 Solution
 
from_expCommented:
it is pretty easy:
you can get all macs and arps via snmp query using standard if-mib
you make snmp get of mac table, parse it and save into database
0
 
pbeirneAuthor Commented:
Would you please explain that in a little more detail?  What do I need to create the "snmp query using standard if-mib"  I am in a windows environment if it matters.
0
 
from_expCommented:
switches do maintain a table, called fdb - forward database, which contains mac-port pairs
if your switch is L3 and do routing it also has routing table with ip-mac pairs

to get that table out you need to snmp query tool like snmpview
if-mib is default standard mib for switches. it comes with snmpview.

as for example, how to do that, I came across perl script
http://www.perlmonks.org/?node_id=129534
0
 
pbeirneAuthor Commented:
Got me pointed in the right direction...thanks.
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now