That was the first thing I tried but I don't get any results. I have also tried "" and '' and NULL. Nothing seems to produce any results.
How about matching a single blank space ( )?
Tried that too. No luck.
I tried several variations, '', ' ', null, (), ( ), blank space, et al.
Nothing seems to parse, not even is NULL or Matches NULL..
For something like this I normally use a query for nodes not in a group;
select Caption from Nodes where not Caption in ( SELECT distinct FullName FROM ContainerMemberSnapshots where EntityDisplayName = 'Node' )
if you want to settle on a specific group, or naming convention for certain nodes try the following;
from Nodes n where n.caption like 'abc%' and not n.Caption in -- Node Name Matching - remove if desired-> ' n.caption like 'abc%' and'
SELECT distinct cm.FullName
FROM ContainerMemberSnapshots cm
INNER Join Containers c on cm.containerid = c.containerid
where EntityDisplayName = 'Node' and c.name = 'GroupName' -- Matching a Specific Group by Name of Group - remove for all groups -> 'and c.name = 'GroupName'
Loop1 Systems: SolarWinds Training and Professional Services