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

Is there a way i can get a report of how many times a node went down over the past 12 months?

I am not looking for device availability report which shows the %. i need something like say a NODE was down for 20 times over the past 12 months

Find more posts tagged with

Accepted answers

All comments

antonis.athanasiou

The SWQL query below should be a good starting point, adjust it to your node caption you're interested in, let me know if you need more columns in:

SELECT EventTime
	,EngineID
	,EventType
	,Message
FROM Orion.Events E
WHERE E.EventTypeProperties.Name = 'Node Down'
	AND E.Nodes.Caption = 'NODENAME'
	AND E.EventTime > ADDMONTH(- 12, GETDATE())

To get just the count, try the following:

SELECT COUNT(EventTime) AS [Times Down]
FROM Orion.Events E
WHERE E.EventTypeProperties.Name = 'Node Down'
	AND E.Nodes.Caption = 'NODENAME'
	AND E.EventTime > ADDMONTH(- 12, GETDATE())

anzar_nazir

Thank you Antonis, but tried this and not getting any results

greskamh

With this SWQL you can count the events of Type "Node down":

SELECT COUNT(1) AS NodeDownEvents, n.DisplayName
FROM Orion.Events e
INNER JOIN Orion.Nodes n ON n.NodeID = e.NetObjectID
WHERE EventType = 1
GROUP BY n.DisplayName

The Availability of a Node is a given function in SWQL, no need to calculate manually:

SELECT TOP 100 r.Availability, n.DisplayName
FROM Orion.ResponseTime r 
INNER JOIN Orion.Nodes n ON n.NodeID = r.NodeID