SELECT DISTINCT PNP.DeviceID0, PNP.Name0, PNP.PNPDeviceID0FROM dbo.v_GS_NETWORK_ADAPTER NA, dbo.v_GS_PNP_DEVICE_DRIVER PNPWHERE NA.Name0 = PNP.Name0 AND NA.MACAddress0 Is Not Null