{"id":6258,"date":"2020-04-29T17:44:41","date_gmt":"2020-04-29T23:44:41","guid":{"rendered":"http:\/\/gregsowell.com\/?p=6258"},"modified":"2020-04-29T17:46:18","modified_gmt":"2020-04-29T23:46:18","slug":"mikrotik-script-to-add-cpe-names-to-switch-ports","status":"publish","type":"post","link":"https:\/\/gregsowell.com\/?p=6258","title":{"rendered":"Mikrotik Script To Add CPE Names To Switch Ports"},"content":{"rendered":"

In one of my new build MDUs, the cabling got all scrambled so my in room Mikrotik routers got all scrambled up. I needed a way to go through each switch and update the interface comment to match what room it is associated with.<\/p>\n

Each CPE is named Room101, Room225, etc. If I connect to the switch and issue a “\/ip neighbor print detail” I get:<\/p>\n

[admin@IDF1-Sw1] > ip neighbor print de\r\n 0 interface=ether1,bridge1 mac-address=B8:69:F4:CC:63:E1 identity="Room216" platform="MikroTik" version="6.46.5 (stable)" unpack=none \r\n   age=47s interface-name="bridge1\/ether1" system-description="MikroTik RouterOS 6.46.5 (stable) RBD52G-5HacD2HnD" \r\n   system-caps=bridge,wlan-ap,router system-caps-enabled=bridge,wlan-ap,router \r\n\r\n 1 interface=ether1,bridge1 mac-address=B8:69:F4:CC:63:E6 identity="Room216" platform="MikroTik" version="6.46.5 (stable)" unpack=none \r\n   age=47s uptime=2d2h56m23s software-id="W3J3-TN8Y" board="RBD52G-5HacD2HnD" ipv6=no interface-name="bridge1\/ether1" system-caps="" \r\n   system-caps-enabled="" \r\n\r\n 2 interface=ether2,bridge1 mac-address=B8:69:F4:CC:64:0B identity="Room260" platform="MikroTik" version="6.46.5 (stable)" unpack=none \r\n   age=41s interface-name="bridge1\/ether1" system-description="MikroTik RouterOS 6.46.5 (stable) RBD52G-5HacD2HnD" \r\n   system-caps=bridge,wlan-ap,router system-caps-enabled=bridge,wlan-ap,router \r\n\r\n 3 interface=ether2,bridge1 mac-address=B8:69:F4:CC:64:10 identity="Room260" platform="MikroTik" version="6.46.5 (stable)" unpack=none \r\n   age=41s uptime=2d2h55m26s software-id="7FC3-R521" board="RBD52G-5HacD2HnD" ipv6=no interface-name="bridge1\/ether1" system-caps="" \r\n   system-caps-enabled=""<\/code><\/pre>\n
I’m connecting these hAPac^2s to a CRS328 switch(an awesome combo!).  I need to write a script that will list the neighbor table, filter on just ether interfaces and also filter to make sure the identity of the remote device starts with “Room”.<\/p>\n
The script itself.<\/p>\n
:local cpes [\/ip neighbor print detail as-value where interface~"ether" and identity~"Room"];\r\n:foreach cpe in=$cpes do={\r\n    \/interface set [\/interface find name=[:pick ($cpe->"interface") 0 [:find ($cpe->"interface") "b"]]] comment=($cpe->"identity");\r\n}<\/code><\/pre>\n
The script in terminal copy\/paste form:<\/p>\n
\/system script\r\nadd dont-require-permissions=no name=interface-comments owner=admin policy=\\\r\n    ftp,reboot,read,write,policy,test,password,sniff,sensitive,romon source=":local cpes [\/ip neighbor print detail as-value where interf\\\r\n    ace~\\"ether\\" and identity~\\"Room\\"];\\r\\\r\n    \\n:foreach cpe in=\\$cpes do={\\r\\\r\n    \\n    \/interface set [\/interface find name=[:pick (\\$cpe->\\"interface\\") 0 [:find (\\$cpe->\\"interface\\") \\"b\\"]]] comment=(\\$cpe->\\"i\\\r\n    dentity\\");\\r\\\r\n    \\n}"<\/code><\/pre>\n
Here’s an example of it alllllll compiled into one line for use with Ansible:<\/p>\n
:local cpes [\/ip neighbor print detail as-value where interface~"ether" and identity~"Room"]; :foreach cpe in=$cpes do={\/interface set [\/interface find name=[:pick ($cpe->"interface") 0 [:find ($cpe->"interface") "b"]]] comment=($cpe->"identity");}<\/code><\/pre>\n
Speaking of ansible you can find the playbook here<\/a>.<\/p>\n
Completion of the script looks like this:<\/p>\n
[admin@IDF1-Sw1] \/interface> print\r\nFlags: D - dynamic, X - disabled, R - running, S - slave \r\n #     NAME                                TYPE       ACTUAL-MTU L2MTU  MAX-L2MTU MAC-ADDRESS      \r\n 0  RS ;;; Room216\r\n       ether1                              ether            1500  1592      10218 CC:2D:E0:63:4F:20\r\n 1  RS ;;; Room260\r\n       ether2                              ether            1500  1592      10218 CC:2D:E0:63:4F:21\r\n 2  RS ;;; Room270\r\n       ether3                              ether            1500  1592      10218 CC:2D:E0:63:4F:22\r\n 3  RS ;;; Room258\r\n       ether4                              ether            1500  1592      10218 CC:2D:E0:63:4F:23\r\n 4  RS ;;; Room272\r\n       ether5                              ether            1500  1592      10218 CC:2D:E0:63:4F:24\r\n 5  RS ;;; Room266\r\n       ether6                              ether            1500  1592      10218 CC:2D:E0:63:4F:25\r\n 6  RS ;;; Room256\r\n       ether7                              ether            1500  1592      10218 CC:2D:E0:63:4F:26\r\n 7  RS ;;; Room264\r\n       ether8                              ether            1500  1592      10218 CC:2D:E0:63:4F:27<\/code><\/pre>\n
In the above scripts you can edit the interface~”ether” and identity~”Room” to be more tailored to your needs.<\/p>\n
Good luck and automate all the things with Ansible!<\/p>\n","protected":false},"excerpt":{"rendered":"
In one of my new build MDUs, the cabling got all scrambled so my in room Mikrotik routers got all scrambled up. I needed\u2026<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[49,6,8],"tags":[],"class_list":["post-6258","post","type-post","status-publish","format-standard","hentry","category-ansible","category-mikrotik","category-networking"],"_links":{"self":[{"href":"https:\/\/gregsowell.com\/index.php?rest_route=\/wp\/v2\/posts\/6258","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gregsowell.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gregsowell.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gregsowell.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/gregsowell.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=6258"}],"version-history":[{"count":4,"href":"https:\/\/gregsowell.com\/index.php?rest_route=\/wp\/v2\/posts\/6258\/revisions"}],"predecessor-version":[{"id":6262,"href":"https:\/\/gregsowell.com\/index.php?rest_route=\/wp\/v2\/posts\/6258\/revisions\/6262"}],"wp:attachment":[{"href":"https:\/\/gregsowell.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=6258"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gregsowell.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=6258"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gregsowell.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=6258"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}