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

Modern Dashboard DOWN widget

So we have a query for showing nodes that are down. That query is:

SELECT DISTINCT a.Caption, a.DetailsURL, c.TriggerTimeStamp
from Orion.Nodes AS a
JOIN Orion.NodesCustomProperties as b ON a.NodeID = b.NodeID
JOIN Orion.AlertStatus as c ON a.NodeID = c.ActiveObject
WHERE Status = '2' AND ClientPrefix LIKE '%INSERT_PREFIX%'

And it has just dawned on me that this is inaccurate, but I don't know where to look to fix it.

The reason it is inaccurate is that we use dependencies and the way it's coded is only looking at the Orion.AlertStatus table for a status of 2. Those of you paying attention (I wasn't until this morning) will now spot that dependencies don't alert so will never appear in the AlertStatus table.

So, I either need to find a different table to select from or somehow drag in the dependencies as well and that is where I need your help please folks?

Find more posts tagged with

Accepted answers

stuartd

So, if I follow you, and in theory [and remembering I'm not a coder as you know], if I change that last line to:

>> WHERE (a.Status = '2' OR a.Status = '12') AND b.ClientPrefix LIKE '%INSERT_PREFIX%'

Should just work? And it does... to a degree!

However, to do so, I have to remove the Orion.AlertStatus join and TriggerTimeStamp field - but I would like to include a time when these alerted (or were set to unreachable). The alternative I have would be to use the: LastSystemUpTimePollUtc from Orion.Nodes I suppose.

It isn't the same as the alert time, but it's close enough for an overview console.

So, for completeness sake my code is now:

SELECT DISTINCT a.Caption, b.ClientPrefix, a.DetailsURL, a. LastSystemUpTimePollUtc,
a.Status
from Orion.Nodes AS a
JOIN Orion.NodesCustomProperties as b ON a.NodeID = b.NodeID
WHERE (a.Status = '2' OR a.Status = '12') AND b.ClientPrefix LIKE '%INSERT_PREFIX%'

All comments

micheal100

Hey Stuart,

looking at it, the status is coming from the nodes table. But the bigger thing here is that nodes that are in dependencies will appear as "unreachable" (statusid =12), and they probably won't appear in any alert (since the alerts are set to generally not take into account that status. (For reference orion.statusinfo has the lookups of the status IDs).

You could look at expanding out the query to pick up child nodes in dependencies, as orion.dependencies has the parent node id.