Problem with swquery nodes with groups

Personaje91

I'm traying to create a query that will bring Nodes with the group they are, but in the results, I'm seeing some results with nodes with a group that they don't belong to. I entered SolarWinds web server and confirmed the group that those nodes belong. Not all the result brings the nodes with the wrong group, but some of them do.  

This is the query I am using.

Select Caption, c.Name AS [Group], SF, nd.DetailsURL AS [Node Details URL] FROM Orion.NodesCustomProperties cp

--For SF---
INNER JOIN Orion.nodes nd on cp.NodeID = nd.NodeID

--For Group---
LEFT JOIN Orion.ContainerMemberSnapshots AS CMS ON nd.NodeID=CMS.EntityID
LEFT JOIN Orion.Container AS C ON C.ContainerID=CMS.ContainerID

--For Unmanaged----
WHERE nd.status = 1 AND c.Owner != 'Maps' AND c.Name = 'Test'

Any help is welcome

stuartd

Not a SQL/SWQL guru by any imagination but what is the SF bit in the SELECT line?

Also, to be clear on what you want ...?

Did you want...

• a list of nodes listed per group
• or a widget on each node page showing what groups it is in
• or something else?

A simple query we use to show what maps a node exists on is - and in this case maps=groups

SELECT  [Container].Name
      , [Container].DetailsUrl AS [_LinkFor_Name]
FROM Orion.Container AS [Container]
WHERE [Container].Name NOT LIKE  'MAPS-________-____-____-_________________'
  AND [Container].Members.MemberEntityType = 'Orion.Nodes'
  AND [Container].Members.MemberPrimaryID = ${NodeID}
ORDER BY [Container].Name

If that's not what you need then we also have this in a report:

SELECT
    c.Name AS [GroupName],
    c.Status AS [GroupStatus],
    CASE WHEN c.Status IN (1,3,14) THEN 100 ELSE 0 END AS [GroupPercentAvailability],
    c.DetailsUrl,
    cm.Name AS [GroupMemberName],
    cm.Status AS [GroupMemberStatus],
    CASE WHEN cm.Status IN (1,3,14) THEN 100 ELSE 0 END AS [GroupMemberPercentAvailability]

FROM Orion.ContainerMembers AS cm
JOIN Orion.Groups AS c ON c.ContainerID = cm.ContainerID

ORDER BY c.Name, cm.Name

This will detail the group, all the nodes in said group and each nodes uptime. You could easily change the Order By to display all the groups a node is in if that's what is preferred.