[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2256
  • 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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