Community discussions

MikroTik App
 
User avatar
hendry
Frequent Visitor
Frequent Visitor
Topic Author
Posts: 76
Joined: Sat Jan 18, 2014 9:59 am
Location: Cornwall, UK
Contact:

Mac to comment idea

Sun Oct 13, 2024 6:14 pm

Instead of EX:AM:PL:E0:00:01@wifi1 roamed to EX:AM:PL:E0:00:01@cap-wifi2, signal strength -81

I want: foobar@wifi1 roamed to foobar@cap-wifi2, signal strength -81


Where foobar would be a comment on EX:AM:PL:E0:00:01 via /ip/dhcp-server/lease


Has anyone done something like that? I know you can transform / enrich logs via https://vector.dev/ but that sounds drastic and it seems non-trivial to export /ip/dhcp-server/lease to csv https://vector.dev/highlights/2021-11-1 ... nrichment/
 
User avatar
patrikg
Member
Member
Posts: 366
Joined: Thu Feb 07, 2013 6:38 pm
Location: Stockholm, Sweden

Re: Mac to comment idea

Sun Oct 13, 2024 7:24 pm

Strange thing to request, but there are something you can enrich the mac address with is the vendor code translation to vendor name.

https://standards.ieee.org/products-programs/regauth/
 
kleshki
Member Candidate
Member Candidate
Posts: 285
Joined: Tue Mar 10, 2020 6:37 am

Re: Mac to comment idea

Sun Oct 13, 2024 8:22 pm

I saw somewhere script that does lookup logs for ipsec errors to block undesired connection attempts. You can try and do the same - make a script that looks up for whatever you want, extract MAC from the message, look for dhcp-lease with corresponding MAC, :log info $MAC . $AP with the format you want.

Since what you want is not a common request, I doubt this would be implemented, but with some effort you can make it on your own.