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

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?