#!rsc
# RouterOS script: collect-wireless-mac.local
# Copyright (c) 2013-2018 Christian Hesse <mail@eworm.de>
#
# collect wireless mac adresses in access list
#
# !! Do not edit this file, it is generated from template!

:global "identity";

:global CertificateAvailable;
:global SendNotification;

:local "place-before" [ / interface wireless access-list find where comment="--- collected above ---" disabled ];
:if ([ :len $"place-before" ] = 0) do={
  :error "Missing disabled access-list entry with comment '--- collected above ---'";
}

:foreach regtbl in=[ / interface wireless registration-table find ] do={
  :local mac [ / interface wireless registration-table get $regtbl mac-address ];
  :local acclst [ :pick [ / interface wireless access-list find where mac-address=$mac ] 0 ];
  :if ( [ :len $acclst ] = 0 ) do={
    :local hostname "no dhcp lease";
    :local address "no dhcp lease";
    :local lease [ / ip dhcp-server lease find where mac-address=$mac ];
    :if ( [ :len $lease ] > 0 ) do={
      :set hostname [ / ip dhcp-server lease get $lease host-name ];
      :set address [ / ip dhcp-server lease get $lease address ];
    }
    :if ( [ :len $hostname ] = 0 ) do={
      :set hostname "no hostname";
    }
    :if ( [ :len $address ] = 0 ) do={
      :set address "no address";
    }
    :local regentry [ / interface wireless registration-table find where mac-address=$mac ];
    :local interface [ / interface wireless registration-table get $regentry interface ];
    :local ssid [ / interface wireless get [ find where name=$interface ] ssid ];
    :local datetime ([ / system clock get date ] . " " . [ / system clock get time ]);
    :local vendor;
    :do {
      $CertificateAvailable "731d3d9cfaa061487a1d71445a42f67df0afca2a6c2d2f98ff7b3ce112b1f568";
      :set vendor ([ / tool fetch mode=https check-certificate=yes-without-crl \
         url=("https://api.macvendors.com/" . [ :pick $mac 0 8 ]) output=user as-value ]->"data");
    } on-error={
      :set vendor "unknown vendor";
    }
    :local message ("unknown MAC address " . $mac . " (" . $vendor . ", " . $hostname . ") " . \
      "first seen on " . $datetime . " connected to SSID " . $ssid . ", interface " . $interface);
    / log info $message;
    / interface wireless access-list add place-before=$"place-before" comment=$message mac-address=$mac disabled=yes;
    $SendNotification ($mac . " connected to " . $ssid) \
      ("A device with unknown MAC address connected to " . $ssid . " on " . $identity . ".\n\n" . \
        "Controller: " . $identity . "\n" . \
        "Interface:  " . $interface . "\n" . \
        "SSID:       " . $ssid . "\n" . \
        "MAC:        " . $mac . "\n" . \
        "Vendor:     " . $vendor . "\n" . \
        "Hostname:   " . $hostname . "\n" . \
        "Address:    " . $address . "\n" . \
        "Date:       " . $datetime);
  } else={
    :local comment [ / interface wireless access-list get $acclst comment ];
    :log debug ("MAC address " . $mac . " already known: " . $comment);
  }
}