SMSUG.ca

...your virtual communITy
Welcome to SMSUG.ca Sign in | Join | Help
in Search

Garth Jones

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

Published Dec 09 2008, 08:44 AM by Garth
Filed under: , ,

Comments

No Comments

This Blog

Syndication

News

Training

Powered by Community Server (Non-Commercial Edition), by Telligent Systems