nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Creating a report that shows hosts that do not belong to a group

brent.weaver

Hello there! I am trying to create a report that will show hosts that are not in a group. How would this be done?

Find more posts tagged with

Accepted answers

AlexSoul

REPORTS > MANAGE REPORTS > CREATE NEW REPORT
CUSTOM TABLE > Select and Continue
Selection method: Advanced DataBase Query (SQL, SWQL) > SQL
Paste the following... > PREVIEW RESULTS
Once happy - ADD To LAYOUT
Then go to EDIT TABLE and add columns > SUBMIT
NEXT > NEXT > NEXT > DONE

SELECT
   n.NodeID, n.Caption, n.IP_Address
FROM SolarWinds.dbo.Nodes n
WHERE
n.NodeID NOT IN
(
SELECT cms.EntityID
    FROM SolarWinds.dbo.ContainerMemberSnapshots cms
    JOIN SolarWinds.dbo.Containers c ON c.ContainerID = cms.ContainerID
    WHERE
      cms.EntityType = 'Orion.Nodes' AND
      c.Name = 'YOUR GROUP NAME'
)

All comments

AlexSoul

REPORTS > MANAGE REPORTS > CREATE NEW REPORT
CUSTOM TABLE > Select and Continue
Selection method: Advanced DataBase Query (SQL, SWQL) > SQL
Paste the following... > PREVIEW RESULTS
Once happy - ADD To LAYOUT
Then go to EDIT TABLE and add columns > SUBMIT
NEXT > NEXT > NEXT > DONE

SELECT
   n.NodeID, n.Caption, n.IP_Address
FROM SolarWinds.dbo.Nodes n
WHERE
n.NodeID NOT IN
(
SELECT cms.EntityID
    FROM SolarWinds.dbo.ContainerMemberSnapshots cms
    JOIN SolarWinds.dbo.Containers c ON c.ContainerID = cms.ContainerID
    WHERE
      cms.EntityType = 'Orion.Nodes' AND
      c.Name = 'YOUR GROUP NAME'
)

brent.weaver

Alex - Thank you VERY much. I was unclear however, I am looking for hosts that belong to no groups, not a specific group. How would I do that?

AlexSoul

Pleasure. To do this simply remove last line "c.Name = 'YOUR GROUP NAME'" and also remove "AND" and the end of the previous line

brent.weaver

So I followed you instructions (I think lol) and I got invalid Query. I cut and pasted the text in you original response and of course replaced it with a group name. It failed. I then remove the AND plus that last lint before the ) and that failed as well. Any advice?

AlexSoul

did you change database name? it appears 2 time as "SolarWinds". Default is "SolarWindsOrion" if you haven't change it during install

brent.weaver

I did not, i just cut and pasted what you had. I did not change any default databases during install.

Where do I change this?

AlexSoul

You need to replace "SolarWinds" database name in the code to be your database name. Check your SQL server how it is called or try "SolarWindsOrion" - hope it will works

see below. I have also removed JOIN which was used to join group names.

Now you can copy-paste...

SELECT
   n.NodeID, n.Caption, n.IP_Address
FROM SolarWindsOrion.dbo.Nodes n
WHERE
n.NodeID NOT IN
(
SELECT cms.EntityID
    FROM SolarWindsOrion.dbo.ContainerMemberSnapshots cms
    WHERE
      cms.EntityType = 'Orion.Nodes'
)

brent.weaver

You are the best! Thank you so much for taking the time for a newbie

AlexSoul

my pleasure