Export non-DHCP devices

RouterOS Scripting
1

In another thread ( http://forum.mikrotik.com/t/why-is-this-so-hard/172569/21 ) I sought and received helped that allowed me to create a script to export all DHCP leases with comment, in CSV.

I then used a Windows Powershell script to concatenate and clean up the files from the individual MT devices.

I can now open this file directly into Excel. Here is just one page of it:

.
Screenshot 2024-01-11 113202.png
.

Can someone suggest how to go about collecting non-DHCP-IP-assigned devices? (To be clear, I mean devices where the IP is set on the device; the DHCP server has no clue about them.)

I thought about using the output from IP-scan or packetsniff or arp, but not sure which would be smarter.

There would also be the need to bring along with the IP address any associated info such as MAC-address, host-name, DNS-name.

Thank you.

2

Do I ask too much?

3

Hire someone, it’s a job, not a command to explain…

4

It can be done by comparing arp table with DHCP table. But you will not see IP that do not communicate with or trough the router.

5

Thank you guys.

/ip/arp/print detail does not show hostname (or bridge port).

6

In Winbox
Bridge → Hosts

In Cli
/interface/bridge/host/print

You will see MAC, Interface, Bridge and VLAN for each device.
Then you can mix that together with the \ip\arp\print to get IP for the mac.

7

Thank you.

What I really need is:

MAC
IP
HOSTNAME

Would be nice to also have:
DNS-name
Bridge Port

Is there a single table available that includes all of these?