It’s time for the power of the command line. However, we can’t export this list from the GUI. Keep in mind – in most cases, the columns Address and Active Address, like MAC Address and Active MAC Address, will contain the same values. The most interesting columns are (Active) Address, (Active) MAC Address and Active Host Name. I chose the Leases tab.Īs you can see on this screenshot, we have the complete list of all active leases (and even reservations).
I opened WinBox and navigated to the DHCP Server window. I exported the whole list into the text file that can be later parsed in Excel.
To speed up this process, the customer asked me for the current DHCP leases list. After a while, the customer decided to move that DHCP to another host. In one productional network, I used the MikroTik router also as the DHCP server for their LAN.