Weekly Tip 33

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:




Contact Us

On Key

More Posts

WME Security Briefing 27 May 2024

Kinsing Hacker Group Exploits Docker Vulnerabilities Overview Recent investigations have shown that the hacker group Kinsing is actively exploiting Docker vulnerabilities to gain unauthorized access to systems. The modified hacker group targets misconfigured Docker API ports deployed with cryptocurrency mining malware.

Read More »
WME Cybersecurity Briefings No. 010
Cyber Security

WME Security Briefing 20 May 2024

Advanced Persistent Threats: North Korean Hackers Launch Golang Malware Overview A new malware strain, called Titan Stealer, is currently actively circulating in the threat landscape, targeting a variety of personal data and linked to North Korean state-sponsored cyber espionage

Read More »
WME Cybersecurity Briefings No. 009
Cyber Security

WME Security Briefing 08 May 2024

Exploitable vulnerability in Microsoft Internet Explorer, used to deploy VBA Malware Overview Cybersecurity researchers discovered a severe exploitation targeting a bug that had already been patched in the Microsoft Internet Explorer browser. Their report added that

Read More »
Be assured of everything

Get WME Services

Stay ahead of the competition with our Professional IT offerings.