SELECT a.interface, a.address, d.mac FROM interface_addresses a JOIN interface_details d USING (interface) WHERE address not in ('127.0.0.1', '::1');

$ipInfo = Get-NetIPAddress -ErrorAction SilentlyContinue | Where-Object { $_.IPAddress -notin ('127.0.0.1','::1') } $adapters = Get-NetAdapter -ErrorAction SilentlyContinue | Select-Object ifIndex, MacAddress $results = foreach ($ip in $ipInfo) {
    $adapter = $adapters | Where-Object { $_.ifIndex -eq $ip.InterfaceIndex } | Select-Object -First 1
    [PSCustomObject]@{
        interface = $ip.InterfaceAlias
        address   = $ip.IPAddress
        mac       = if ($adapter) { $adapter.MacAddress } else { 'N/A' }
    }
} $results | Format-Table -AutoSize