Live Discover Query - MAC address list

 REVIEWED by Sophos 

A simple one for listing the interfaces of devices and their MAC addresses. Potentially handy if you need to check DHCP logs, firewall logs, or update your WIFI MAC filtering list.

SELECT
    description "Desc",
    mac "MAC"
FROM interface_details
WHERE MAC >1;
/* This removes the loopback adapters and Microsoft tunnels  */

Should work on Windows, Mac, and Linux

Cheers,
AM