Page 1 of 1

ARP List to CSV

Posted: Tue Feb 14, 2017 10:56 am
by jonathandick
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.

Re: ARP List to CSV

Posted: Tue Feb 14, 2017 11:21 am
by cdiedrich
/ip arp print file=arp.txt
-Chris

Re: ARP List to CSV

Posted: Tue Feb 14, 2017 11:45 am
by pe1chl
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

Re: ARP List to CSV

Posted: Tue Feb 14, 2017 3:30 pm
by jonathandick
Thank you both!