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

Outage Duration Last Month

jtimes

Purpose:
Generates an Outage (node detail) report for the past 30 days.

Grouped by node name, Ordered by Event Time

Prerequisite:

none

Optional:
Report Scheduler job defined to send report monthly

Outage_Duration_Last_Month.OrionReport

Find more posts tagged with

custom_report

Accepted answers

All comments

BinaryDigit09

Does this report accumulate the total down time for the node if it went up and down several times during the month? Looking at the SQL statement, it appears to assume the node went down only once.

jtimes

This part of the SQL statement is for the last month
eventtime between dateadd(month, -1, getdate()) and getdate()

heinzy

Can you confirm this is 'last month' - it looks like the last 30 days to me....

DaveStraley

This works from the report writer but not from the web interface. We updated to v9.5... maybe that has something to do with it.

Geoo

I like this report alot. Is it possible to "sum" the amount of time in a month that the nodes were down rather than display each time?

jsherwin

how do you install this program ????

soplixx

does it generate report For Cisco Device, in my report view i can not find my cisco report

soplixx

very usefull report,
thanks

Shailesh1

Sorry...this report seems to be for the last 30 days. Not for last month. Can the author clarify.

augustocsm

You can try this one:

jeffnorton

THe only problem I see with this report is that it focused only on a node being down and does not address interfaces on that node that are down

mesebua

great report loved it

FormerMember

Thanks, Good report :-)

Is there any way i can filter this using custom properties?

Thanks

bsciencefiction.tv

This is freaking AWESOME.

engineerbaz

Dear Jsherwin,

Download this report and copy in folder where all reports are saved.( i.e \Program Files\Solarwinds\Orion\Reports\ ) .

Then open Orion Report Writer.

Click on OPEN & select desired report.

aveloz

Shailesh wrote:
Sorry...this report seems to be for the last 30 days. Not for last month. Can the author clarify.

I modified it to show the last previous month....please test it:

DECLARE @StartDate DateTime

DECLARE @EndDate DateTime

SET @StartDate = DATEADD(d, DATEDIFF(d, 0, DATEADD(m, -1, DATEADD(d, 1 - day(getdate()), getdate()))), 0)

SET @EndDate = DATEADD(ms, -2,DATEADD(d, DATEDIFF(d, 0, DATEADD(d, 1 - day(getdate()), getdate())), 0));

SELECT

StartTime.EventTime,

Nodes.Caption,

Nodes.Organization,

Nodes.Type,

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 @StartDate AND @EndDate ) AND Nodes.Organization = 'FMHP' AND Nodes.Type = 'Router'

ORDER BY StartTime.EventTime

jtimes

Correct the report does the past 30 days, and if you schedule it to run (as is) on the first day of the new month it works as written.

This part of the original SQL statement is for the last month

eventtime between dateadd(month, -1, getdate()) and getdate()

this gets the event time and measures it only from the perspective of occurring within the last month.

Your report includes custom properties, I have removed them with the following resulting SQL:

DECLARE @StartDate DateTime

DECLARE @EndDate DateTime

SET @StartDate = DATEADD(d, DATEDIFF(d, 0, DATEADD(m, -1, DATEADD(d, 1 - day(getdate()), getdate()))), 0)

SET @EndDate = DATEADD(ms, -2,DATEADD(d, DATEDIFF(d, 0, DATEADD(d, 1 - day(getdate()), getdate())), 0));

SELECT

StartTime.EventTime,

Nodes.Caption,

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 @StartDate AND @EndDate )

ORDER BY StartTime.EventTime

Both reports accomplish the same result

cmatrask

Thank you!!! This is a great report!!!

Appreciate the share on this one!

Cheryl

Hi @jtimes

This report is awesome, working fine as expected.

I am using your report for last month you shared last in this thread.

I am trying exclude the nodes with null values (no down time) from the report but no luck. Can you help me where i need place the query.

Thanks,