Computers in a certain collection and their IP address

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

Leave a Reply

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