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

Find nodes not assigned to a group

rakem

Is there a way in NCM to find out which nodes are not assigned to a group?

Find more posts tagged with

Accepted answers

All comments

jeff.stewart

You have two options for this;

1. You can change how the Node List is sorted, and sort Grou By Level 1 by 'Node Group'. Any node that doesn't have a node group assigned should show up in the unknown catagory.

-or-

2. You can run the following query against the NCM DB;

Select *
From Nodes
Where NodeGroup=''

Jeff

*You could also sort the devices in a similar manner to option 1 in the Win32 App on the NCM server.

netlogix

I don't have a field called "NodeGroup", but the way I do it is:

select Caption
from nodes
where
not Caption in (
   SELECT distinct [FullName]
   FROM [NetPerfMon].[dbo].[ContainerMemberSnapshots]
   where [EntityDisplayName] = 'Node'
)