How to identify nodes that are not part of a group

cmccartinbshk

How can you get a list of nodes that are not part of a group in NPM and is this possible through the web interface?

Find more posts tagged with

npm

groups

Accepted answers

netlogix

Try:

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

your database name might not be "NetPerfMon".

All comments

netlogix

Here is SQL to find that:

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

You might be able to create a custom SQL report that runs that. I added a SQL experiance to APM that watches the Count(*) for that and sends me an alert if it exceeds 0.

cmccartinbshk

When I run this query, I get the following error:

Invalid object name 'NetPerfMon.dbo.ContainerMemberSnapshots'.

I'm running the RC version of NPM - 10.2. Do I need to run a different query?

Thanks,

Chris

netlogix

Try:

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

your database name might not be "NetPerfMon".

cmccartinbshk

That worked - Thanks again!