How to see witch nodes are not assigned in a group

Question

Hello,

Normaly every nodes is assigned in a group, but sometimes they will forget to set a node in a group.

How can I see, maybe with a report, witch nodes are not assigned in a group.

bciecko42 · Answer

From all the SQL syntax there, I am guessing there is no easy way to do this from the Web Interface?

RichardLetts · Answer

Wow. SolarWinds need to seriously have someone review the SQL on customer-facing pages

select Caption,IP_Address from nodes where not Caption in(SELECT distinct[FullName] FROM [ContainerMemberSnapshots] where [EntityDisplayName] = 'Node')\

this requires a sort and lots of string compares for the IN portion

select Caption,IP_Address 
from nodesdata left outer join
     ContainerMemberSnapshots on 
          nodesdata.NodeID=ContainerMemberSnapshots.EntityID
      and ContainerMemberSnapshots.EntityType='Orion.Nodes'
where ContainerMemberSnapshots.EntityID is NULL

runs at least 25 times faster (as it hits indexes)

Or (slightly faster, and easier to understand)

select Caption,IP_Address 
from nodesdata 
where not exists (select 1 from ContainerMemberSnapshots where
nodesdata.NodeID=ContainerMemberSnapshots.EntityID
and ContainerMemberSnapshots.EntityType='Orion.Nodes')

(removes a Filter step in the execution plan)

[Editing something with the syntax highlighting turned on is challenging]

vinay.by · Answer

SQL Query to trace unassigned nodes to any groups - SolarWinds Worldwide, LLC. Help and Support

SAM - Find nodes not assigned to a Group?