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

Outgage Duration report

I'm losing my mind! I had to reinstall Orion V8 and now a report that I had that showed outage duration for each node for the previous month is gone. I thought this was a canned report. If so where can I find it and if not how can I create it?

Find more posts tagged with

Accepted answers

All comments

vhcato

I believe "Outage Duration" was included in the additional reports that were available for download to customers with active maintenance contracts. I just looked, and I no longer see the additional reports available for download..?

Vic

jtimes

In Report Writter: File> New Report > Advanced SQL
General Tab:
Report Group: Events
Report Title: Outage Duration

Paste this into the SQL Tab:

SELECT
StartTime.EventTime,
Nodes.Caption,
Nodes.Location,
StartTime.Message,
DATEDIFF(Mi, StartTime.EventTime,
(SELECT TOP 1
EventTime
FROM Events AS Endtime
WHERE EndTime.EventTime > StartTime.EventTime AND EndTime.EventType = 5
AND EndTime.NetObjectType = 'N'
AND EndTime.NetworkNode = StartTime.NetworkNode
ORDER BY EndTime.EventTime)) AS OutageDurationInMinutes

FROM Events StartTime INNER JOIN Nodes ON StartTime.NetworkNode = Nodes.NodeID
WHERE (StartTime.EventType = 1) AND (StartTime.NetObjectType = 'N')
ORDER BY StartTime.EventTime DESC

John J. Times

tgoyette

Thanks for the SQL Script, that worked great.

jtimes

thats the SQL commands from the additional reports that Vic was talking about

John J. Times

WINNT

This report seems to be for the past 30 days and not the previous month. Is everyone else getting the same results? Thanks.

jtimes

it sure is the last 30 days. I never checked that because I have it in Report Scheduler to run at midnight every 30 days...

I'll see if I can get the "last month" figured out and re-post it.

John J. Times

jtimes

that was easy... this will give you last month

SELECT
StartTime.EventTime,
Nodes.Caption,
Nodes.Location,
StartTime.Message,
DATEDIFF(Mi, StartTime.EventTime,
(SELECT TOP 1
EventTime
FROM Events AS Endtime
WHERE EndTime.EventTime > StartTime.EventTime AND EndTime.EventType = 5
AND EndTime.NetObjectType = 'N'
AND EndTime.NetworkNode = StartTime.NetworkNode
ORDER BY EndTime.EventTime)) AS OutageDurationInMinutes

FROM Events StartTime INNER JOIN Nodes ON StartTime.NetworkNode = Nodes.NodeID
WHERE (StartTime.EventType = 1) AND (StartTime.NetObjectType = 'N') AND
eventtime between dateadd(month, -1, getdate()) and getdate()
ORDER BY StartTime.EventTime DESC

~~~~~~~~~~~~~~~~~~~~~~~~~~~
or sorted by node

ORDER BY Nodes.Caption ASC

WINNT

Hmmmm, I get the same results.