was successfully added to your cart.

Weekly Tip

By December 16, 2015Uncategorized

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