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

How do I get the proportion widget for critical servers to show how many?

AndoniFTQ

What is the SWQL code for showing the number of critical events.

I am using SELECT Count(*) AS UP FROM Orion.Nodes WHERE Status = 1 which shows all the number of nodes

but I when I put SELECT Count(*) AS UP FROM Orion.Nodes WHERE Status = 14 for critical, It comes up as zero.

Find more posts tagged with

Accepted answers

All comments

KMSigma.SWI

If you do

SELECT [N].Caption
     , [N].IPAddress
     , [N].Status
     , [SI].StatusName
FROM Orion.Nodes AS [N]
INNER JOIN Orion.StatusInfo AS [SI]
  ON [N].Status = [SI].StatusID

Do you have records for Status = 14?

AndoniFTQ

Hi,

I stopped a service that I am monitoring which is supposed to be critical to see if I get the status 14 and nothing. I put in your code you mentioned in SQWL and got only 1's.

I appreciate your reply.

Thank you

KMSigma.SWI

Oh - that's because you are asking the "node" (the server) if it's critical (high CPU/Memory/Response Time), not if an Application Component is critical.

How about:

SELECT [N].Caption
     , [N].IPAddress
     , [N].StatusDescription     
     , [N].Status
     , [NodeSI].StatusName AS [Node Status]
     , [N].ChildStatus
     , [ChildSI].StatusName AS [Child Status]
FROM Orion.Nodes AS [N]
INNER JOIN Orion.StatusInfo AS [NodeSI]
  ON [N].Status = [NodeSI].StatusID
INNER JOIN Orion.StatusInfo AS [ChildSI]
  ON [N].ChildStatus = [ChildSI].StatusID

Note that "Child Status" is based on any children (interfaces, volumes, applications, components, etc.) So you'll want to be explicit with your widget descriptions.

AndoniFTQ

Thanks for this query but I still did not get any details on status 14. I have one critical and a few warning but it's showing as status 1. Take a look at the screen shots.

thank you