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

NODES count grath with SWQL

Hello,

I am new to SWQL. i am trying to make a graph of nodes which are in critical, UP, DOWN state. i found how to take count of nodes which are in critical state, but when i try to make a graph i am getting an error, because i do not have a time Column.

SELECT Count(*) as TOTAL

,(SELECT Count(*) as UP FROM Orion.Nodes Where Status = 1) as UP

,(SELECT Count(*) as DOWN FROM Orion.Nodes Where Status = 2) as DOWN

,(SELECT Count(*) as Warning FROM Orion.Nodes Where Status = 3) as Warning

,(SELECT Count(*) as Critical FROM Orion.Nodes Where Status = 14) as Critical

FROM Orion.Nodes

Find more posts tagged with

Accepted answers

All comments

Seashore

Thats right, with that query you only get one set of numbers, how many nodes that have that status right now.

What you want is the historical data also. How many nodes that was critical yesterday etc.

I dug around but I could not find that info. I think it should be there but right now i didn't find it.

mikesky

I think you'll need to use the SWQL Orion.ResponseTime table. You can use the Availability column as your "status" and the DateTime as your 'timestamp.'

100 = Up
Between 1-99 = Warning/Critical
0 = Down