Get IP Address for Entire Collection
This tip requires a limited knowledge of SQL Management Studio. Open Management Studio and paste this SQL query:
SELECT COLL.Name,IP.IP_Addresses0
FROM v_CM_RES_COLL_<collection ID> COLL,v_RA_System_IPAddresses IP
WHERE COLL.ResourceID = IP.ResourceID
ORDER BY IP.IP_Addresses0
Replace <collection ID> with the collection ID for the appropriate collection and execute the query. You will get two columns, one the with machine name and the other with the IP address. The query also sorts the results by IP address. If you would like it sorted by name, replace the ORDER BY line with this:
ORDER BY COLL.Name
