SELECT DISTINCT
CS.Name0,
NAC.IPAddress0
FROM
dbo.v_FullCollectionMembership FCM,
dbo.v_GS_COMPUTER_SYSTEM CS,
dbo.v_GS_NETWORK_ADAPTER_CONFIGUR NAC
WHERE
CS.ResourceID = FCM.ResourceID
AND CS.ResourceID = NAC.ResourceID
AND NAC.IPAddress0 Is Not Null
AND FCM.CollectionID=’SMS00004′
ORDER BY
CS.Name0