nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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 option within the Report Writer

jflewis1021

Is Solarwinds planing to add this feature to the Report Writer? For us not SQL Query Pro's this would be a well used option.

Find more posts tagged with

Accepted answers

All comments

FormerMember

Please elaborate on what you're looking for, and I can add it to the queue. I need to know the scenario, the problem you're trying to solve. That's more useful and likely to get in than a flat description of a feature.

jflewis1021

This was out lined in many threads under the title of Outage Duration in the Reports section. Also this would be very helpfull when you select a date range.

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

jflewis1021

This was out lined in many threads under the title of Outage Duration in the Reports section.

FormerMember

What I'm looking for is the business problem you're trying to solve.

jflewis1021

I have been asked by management to provide a report that shows the outage duration of the node verus just a report that shows the up and down events. This would help in providing SLA reports to the management team. At this time I am having to due the calculations by hand within Excel.

Jim

ecklerwr1

Maybe a quick and dirty way to get this is the following report from content exchange:

At least as a starting point if you are not a DBA :}

jeffnorton

One thing to consider on outage reports like this, is that this records only when the entire node goes down. Of more interest to most execs are WAN outages. Since many nodes actually have multiple paths, simply looking at the node outage won't be accurate. In this instance it takes looking at a specific interface outage. Now having said that I'm not an SQL guru either. What I've done to ID WAN interfaces in my network is to create a custom interface resource called WAN with a yes/no selection. So what I would be looking for is a report writer resource that would let me show all the down events and total duration of that down event for an interface with a custom resource of WAN = yes over a 30 day period. Any one, Any one

scottd

I'm no SQL guru either, but i do understand the query... We have adopted the query and made it work for us. I have set this up several different ways and have settled on one that works best for me. I will describe the way we use it...

I have set up a dts package to handle the outage reporting process. It creates a table and puts all of the outages that meet your criteria into it. Then it removes the entries that do not meet the time frame that we use for outage reporting. I scheduled this query run every 30 minutes so there is always 7 day worth of up-to-date outage events residing in the table ready to be queried(i do this so i dont have to chase down a bunch of root causes at the end of the report week). At this point you could use something like SQL reporting services to genertate your outage report or you could use Excel to grab the data from the outage table. We use Excel for this as we still have to assign a root cause for all outages that meet the criteria. As soon as we settle on a new help desk system i will be looking to link to the tables that hold root cause information so that we can automate the outage reporting entirely on the backend.

the query is commented to make it eaiser to read.

--*************************
--Outage Reporting Process
--*************************

--Disable returned output
SET NOCOUNT ON

--Delete Old/Stale Data
DROP TABLE Outage

--Gather up all outage data for the last 7 days and load it into the Outage Table
SELECT
StartTime.EventTime AS EventTime,
Nodes.Caption AS Caption, --custom property
Nodes.Company AS Company, --custom property
Nodes.Production AS Production, --custom property
Nodes.Report AS Report, --custom property
Nodes.IP_Address AS IP_Address,
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
INTO Outage
FROM Events StartTime INNER JOIN Nodes ON StartTime.NetworkNode = Nodes.NodeID
WHERE (StartTime.EventType = 1)
AND (StartTime.NetObjectType = 'N')
AND EventTime BETWEEN DATEADD(DAY, -7, GETDATE()) AND GETDATE()
AND (Nodes.Production = 1)
AND (Nodes.Report = 1)
AND NOT (Nodes.UnManaged = 1)
ORDER BY 1 ASC

--Clean out entries that do not meet the time reporting criteria, we report outages between 6am and 10pm that last more than 5 minutes

DELETE FROM Outage
WHERE (OutageDurationInMinutes <=5)
OR (CONVERT(CHAR(2), EventTime, 114) BETWEEN 22 AND 24)
OR (CONVERT(CHAR(2), EventTime, 114) BETWEEN 00 AND 05)