Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

SWIS Query for node members of group

I'd like to create a query to list all nodes that are members of a group. Any help would be greatly appreciated.

Find more posts tagged with

Accepted answers

Groups can contain different objects (Nodes, Volumes, more groups, etc.) therefore it is not always straightforward how to navigate through them.

Try the following and see if it works, note that it will only output the nodes in the specific group and will ignore sub-groups if any.

SELECT CM.Name 
FROM Orion.ContainerMembers CM
WHERE
    CM.EntityDisplayName='Node'
AND CM.Container.Name = 'group name'

All comments

antonis.athanasiou

SELECT CM.Name 
FROM Orion.ContainerMembers CM
WHERE
    CM.EntityDisplayName='Node'
AND CM.Container.Name = 'group name'

shocko

Indeed they can but in this case I know the groups I'm targeting only contain nodes. Thanks for the steer!

brscott

SIDE NOTE: If you are doing much with groups, you will discover they just suck. Alternatively setup custom properties and use those instead. Then to maintain compatibly with your existing groups you add a dynamic query to the group to add all of the nodes with that custom property value.

adam.beedell

Something like this


SELECT DISTINCT(n.caption)
FROM orion.containermembers cm
LEFT JOIN Orion.nodes n on n.NodeID = cm.MemberPrimaryID
WHERE cm.MemberEntityType like '%Node%'

adam.beedell

Or if you want the group name swap in the group name property instead of n.caption

shocko

Great shout @brscott

kjamil

from performance perspective and especially if you going to be running the query many times, try not to use leading % in your where clause especially when you have lots of nodes 10X because you do not want to be reading all the table into the memory every time. you can use = 'Orion.Nodes' see the highlighted query below and check against you environment to make decision.

ImNishat

It's working, but showing only node name. Want to add IP address of each node of the group and group member name and one Custom properties like Node Category.

Is it possible to achieve using query?

stevenstadel

Sure, you will need to add in the missing properties that you want to see in the SWQL statement. I am not sure of your custom property name but this may get you close to want you want.

SELECT DISTINCT c.Name, 
n.Caption, 
n.IPAddress, 
n.CustomProperties.node_category, 
FROM Orion.ContainerMembers cm
LEFT JOIN Orion.Nodes n ON n.NodeID = cm.MemberPrimaryID
LEFT JOIN Orion.Container c ON c.ContainerID = cm.ContainerID
WHERE cm.MemberEntityType LIKE '%Node%'