The purpose of these scripts is to update the local DHCP lease table with a remote IP Address Management (IPAM) system.<\/p>\n\n\n\n
This little script is added to the scheduler and goes through the entire DHCP lease table and uploads each MAC address and IP address pair to a website.<\/p>\n\n\n\n
Change out the top three variables. May also need to change out the URL depending on how the website receives data.<\/p>\n\n\n\n
:local url \"upload.incredigeek.com\"\n:local username \"myapiuser\"\n:local password \"passwordforapiuserwebsite\"\n\n\/ip\/dhcp-server\/lease\/\n:foreach i in=[find] do={ :put ([get $i address].\" \".[get $i mac-address])\n:local ipaddress ([get $i address])\n:local macaddress ([get $i mac-address])\n\/tool fetch url=\"https:\/\/$url\/api\/v1\/network\/ipam\/dynamic_ip_assignment?ip_address=$ipaddress&mac_address=$macaddress&expired=0\" mode=https keep-result=no user=$username password=$password\n:delay 1s;\n}<\/pre>\n\n\n\n<\/p>\n\n\n\n
DHCP Script<\/h2>\n\n\n\n
This script is to be used on the DHCP server script. Can add it by going to DHCP Server -> DHCP -> Double Click Server -> Script <\/p>\n\n\n\n
Any time a new DHCP lease is obtained, this script is fired. Note that some of the variables like $leaseBound are specific to the script being used by the “DHCP server”<\/p>\n\n\n\n
Also helpful to note that the script only runs if a new lease is obtained, or a lease expires and it disappears from the leases page. A DHCP renew does not trigger the script. <\/p>\n\n\n\n
:local username \"myapiuser\"\n:global password \"myapipassword\"\n:global url \"upload.incredigeek.com\"\n\n# The maximum retries\n:local max 60\n:local attempts 0\n:local success 0\n:do {\n :set attempts ($attempts+1);\n :if ($leaseBound = 0) do {\n :do {\n \/tool fetch url=\"https:\/\/$url\/api\/v1\/network\/ipam\/dynamic_ip_assignment?ip_address=$leaseActIP&mac_address=$leaseActMAC&expired=1\" mode=https keep-result=no user=$username password=$password\n :set success 1;\n } on-error={\n :log error \"DHCP FAILED to send unassignment to $url on attempt $attempts out of $max for $leaseActMAC \/ $leaseActIP\";\n :delay 10s;\n }\n } else {\n :delay 1s;\n # see note below\n :local remoteID [\/ip dhcp-server lease get [find where address=$leaseActIP] agent-remote-id];\n :do {\n \/tool fetch url=\"https:\/\/$url\/api\/v1\/network\/ipam\/dynamic_ip_assignment?ip_address=$leaseActIP&mac_address=$leaseActMAC&expired=0\" mode=https keep-result=no user=$username password=$password\n :set success 1;\n } on-error={\n :log error \"DHCP FAILED to send assignment to $url on attempt $attempts out of $max for $leaseActMAC \/ $leaseActIP\";\n :delay 10s;\n }\n }\n :if ($success) do {\n :log info \"DHCP lease message successfully sent $leaseActMAC \/ $leaseActIP to $url\";\n :set attempts $max; # break out of the do..while loop\n }\n} while ( $attempts < $max )\n}<\/pre>\n","protected":false},"excerpt":{"rendered":"The purpose of these scripts is to update the local DHCP lease table with a remote IP Address Management (IPAM) system. Scheduler Script This little script is added to the scheduler and goes through the entire DHCP lease table and … Continue reading