Snippets

• DHCP Leases to CSV
• DHCP Server Lease last-seen comparison

DHCP Leases to CSV

CSV output of DHPC related items in RouterOS

Static DHCP leases to CSV output

{
    # process only static leases
    :local staticLeases [/ip dhcp-server lease find where dynamic=no]
    :foreach l in=$staticLeases do={
        :local lma [/ip dhcp-server lease get $l mac-address]
        :local la [/ip dhcp-server lease get $l address]
        :local lc [/ip dhcp-server lease get $l comment]
        :put "$lma,$la,\"$lc\""
    }
}

All DHCP leases to CSV output

{
    # process all leases
    :local staticLeases [/ip dhcp-server lease find]
    :foreach l in=$staticLeases do={
        :local lma [/ip dhcp-server lease get $l mac-address]
        :local la [/ip dhcp-server lease get $l address]
        :local lc [/ip dhcp-server lease get $l comment]
        :local ld [/ip dhcp-server lease get $l dynamic]
        :put "$lma,$la,$ld,\"$lc\""
    }
}

-end

DHCP Server Lease last-seen comparison

/ip dhcp-server lease print where last-seen > "30d"

/ip dhcp-server lease print where last-seen > "30d" && last-seen !="never"

/ip dhcp-server lease print where last-seen > "30d" && last-seen !="never" && server=dhcp-lan && comment~"^auto-static"