NIC PNP Devices

SELECT DISTINCT
PNP.DeviceID0,
PNP.Name0,
PNP.PNPDeviceID0
FROM
dbo.v_GS_NETWORK_ADAPTER NA,
dbo.v_GS_PNP_DEVICE_DRIVER PNP
WHERE
NA.Name0 = PNP.Name0
AND NA.MACAddress0 Is Not Null

Leave a Reply

Your email address will not be published. Required fields are marked *