I would like to be able to always have an updated list/spreadsheet/database/etc. that associates:
IP ADDRESS
MAC ADDRESS
HOSTNAME
COMMENT
MT-IDENTITY
I use a script now that utilizes:
Code: Select all
:local stringexec "/system iden print; :put \"\\r\\n\"; /ip cloud pri; :put \"\\r\\n\"; /ip dhcp-server lease pri det; :put \"\\r\\n\"; "
Code: Select all
name: 355hEX
ddns-enabled: yes
ddns-update-interval: none
update-time: yes
public-address: 69.202.xxx.xxx
dns-name: aaaaa.sn.mynetname.net
status: updated
warning: Router is behind a NAT. Remote connection might not
work.
Flags: X - disabled, R - radius, D - dynamic, B - blocked
0 address=192.168.0.176 mac-address=10:3D:0A:5E:4F:C2 address-lists=""
server=defconf dhcp-option="" status=bound expires-after=16h48m11s
last-seen=7h11m49s active-address=192.168.0.176
active-mac-address=10:3D:0A:5E:4F:C2 active-server=defconf
host-name="PearceLR"
1 address=192.168.0.174 mac-address=C4:3D:1A:D6:81:D9
client-id="1:c4:3d:1a:d6:81:d9" address-lists="" server=defconf
dhcp-option="" status=bound expires-after=15h9m45s last-seen=8h50m15s
active-address=192.168.0.174 active-mac-address=C4:3D:1A:D6:81:D9
active-client-id="1:c4:3d:1a:d6:81:d9" active-server=defconf
host-name="Beelink-Mini-S"
2 address=192.168.0.152 mac-address=94:E7:0B:29:30:E7
client-id="1:52:41:53:20:94:e7:b:29:30:e7:0:0:0:0:0:0" address-lists=""
server=defconf dhcp-option="" status=waiting last-seen=2w3h41m31s
host-name="Laptop-JRS-AN515-55"
3 address=192.168.0.151 mac-address=84:F3:EB:A1:39:FC address-lists=""
server=defconf dhcp-option="" status=bound expires-after=19h43m38s
last-seen=4h16m22s active-address=192.168.0.151
active-mac-address=84:F3:EB:A1:39:FC active-server=defconf
host-name="tankutility-84f3eba139fc"
4 address=192.168.0.193 mac-address=1C:1E:E3:8C:87:71 address-lists=""
server=defconf dhcp-option="" status=bound expires-after=23h31m33s
last-seen=28m27s active-address=192.168.0.193
active-mac-address=1C:1E:E3:8C:87:71 active-server=defconf
host-name="355BlueMBR"
5 address=192.168.0.125 mac-address=34:F1:50:6F:33:D0 address-lists=""
server=defconf dhcp-option="" status=bound expires-after=22h15m11s
last-seen=1h44m49s active-address=192.168.0.125
active-mac-address=34:F1:50:6F:33:D0 active-server=defconf
host-name="355BlueLR"
6 address=192.168.0.124 mac-address=E8:DB:84:9D:1C:7B address-lists=""
server=defconf dhcp-option="" status=waiting last-seen=7w5d12h14m5s
host-name="ESP_9D1C7B"
7 address=192.168.0.123 mac-address=98:F4:AB:21:19:F8
client-id="1:98:f4:ab:21:19:f8" address-lists="" server=defconf
dhcp-option="" status=bound expires-after=12h1m26s last-seen=11h58m34s
active-address=192.168.0.123 active-mac-address=98:F4:AB:21:19:F8
active-client-id="1:98:f4:ab:21:19:f8" active-server=defconf
host-name="Emporia"
8 address=192.168.0.122 mac-address=44:61:32:EB:34:04
client-id="ff:32:eb:34:4:0:3:0:1:44:61:32:eb:34:4" address-lists=""
server=defconf dhcp-option="" status=bound expires-after=16h52m19s
last-seen=7h7m41s active-address=192.168.0.122
active-mac-address=44:61:32:EB:34:04
active-client-id="ff:32:eb:34:4:0:3:0:1:44:61:32:eb:34:4"
active-server=defconf host-name="Shop"
The end goal is to be able to access this combined data and find (for example):
1) All devices with a mac address that starts with 3c, or
2) All devices with TH in the comment, or
3) All devices with an IP starting with 192.168.0
Anyone have any suggestions?
Thank you.