Find all you need to begin your THWACK journey, including documentation, missions, blogs, community groups, events, and media.
Find the best place to learn and ask questions about your SolarWinds products.
Find downloadable files and templates other users have built and found useful to share with others.
Create individual user accounts for your team, manage your licenses, download your SolarWinds software, create and track support tickets, and more.
A one-stop-shop for world-class training for SolarWinds products through on-demand videos, and instructor-led classes. All SolarWinds Academy content is included with every software purchase.
Get help when you need it from a world-class support team, available to assist with technical product issues 24 hours a day, seven days a week, 365 days a year.
Accelerate SolarWinds Partners’ ability to drive digital and IT transformation for customers with powerful tools, resources, and increased profit potential.
I want a report that shows outage duration in minutes which is greater than 60 minutes in last month.
There is a report in the content exchange here:
Many thanks jamison but I want it only shows events which has outage greater than 60 minutes.
ok, modify that report with this:
with t as (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())
Select *
from t
where t.OutageDurationInMinutes>60
Many many thanks my friend.
