Community discussions

MikroTik App
 
jonathandick
just joined
Topic Author
Posts: 18
Joined: Fri Feb 10, 2017 12:26 pm
Location: Kenya

ARP List to CSV

Tue Feb 14, 2017 10:56 am

We are trying to build a registry of all MAC addresses and associate with individual users. It would be great to be able to export the ARP list into a csv file we could load in a spreadsheet. Winbox will allow me to select all the arps in /ip arp but it will not let me copy and paste. Any ideas how to achieve this?

Thanks.
 
User avatar
cdiedrich
Forum Veteran
Forum Veteran
Posts: 997
Joined: Thu Feb 13, 2014 2:03 pm
Location: Basel, Switzerland // Bremen, Germany
Contact:

Re: ARP List to CSV

Tue Feb 14, 2017 11:21 am

/ip arp print file=arp.txt
-Chris
 
pe1chl
Forum Guru
Forum Guru
Posts: 10568
Joined: Mon Jun 08, 2015 12:09 pm

Re: ARP List to CSV

Tue Feb 14, 2017 11:45 am

To do things like this from another system, it is also possible to use SNMP. E.g.:
snmpbulkwalk -v2c -c public (router_ip_here) ip.ipNetToMediaTable.ipNetToMediaEntry.ipNetToMediaPhysAddress
 
jonathandick
just joined
Topic Author
Posts: 18
Joined: Fri Feb 10, 2017 12:26 pm
Location: Kenya

Re: ARP List to CSV

Tue Feb 14, 2017 3:30 pm

Thank you both!