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

SWQL query to see total number of managed nodes

Hi,

We have created a dashbaord widget for viewing total numbers of nodes but it also includes the unmanaged nodes. We only want to see the total number of managed nodes. Could anyone please help with the SWQL query for that?

The query that I have used-

select count(1) as countnodes from orion.nodes where (nodes.customproperties.country = 'city1' or nodes.customproperties.country = 'city2' or nodes.customproperties.country = 'city3' or nodes.customproperties.country = 'city4' or nodes.customproperties.country = 'city5' or nodes.customproperties.country = 'city6' or nodes.customproperties.country = 'city7' or nodes.customproperties.country = 'city8' )

Thanks.

Find more posts tagged with

swql query

sdk

Accepted answers

wluther

You could probably add something like

AND Nodes.Status <> 9

Put that onto the end of your query and see if it helps.

All comments

wluther

You could probably add something like

AND Nodes.Status <> 9

Put that onto the end of your query and see if it helps.

wluther

I'm pretty sure this info is scattered across many tables, and I think it's changed a bit over the years, though I believe this table should get you what you need.

arijitnaha

This actually helped to get the results what I needed. Thank you.