SWQL QUERY TO SHOW GROUP MEMBER IP ADDRESS

wsk

I set the member in the Group whose Status is down to Alert.

I need SWQL to check the IP address for a group member. Is it possible???

Seeing (https://thwack.solarwinds.com/thread/71929) didn't solve it.

christopher.t.jones123

You'd have to create a custom variable. Below is an example, you should be able to replace "${N=SwisEntity;M=Name}" in my query with the variable you are currently using "${groupMemberName}" let me know if it doesn't work

${N=SWQL;M=select top 1 n.ipaddress
from orion.Nodes n
join orion.ContainerMembers c on n.NodeID = c.MemberPrimaryID
where c.Name = '${N=SwisEntity;M=Name}' }