This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Downtime reports (unplanned)

I'm trying to recreate our Unplanned Downtime Report. It was originally created in the Report Writer tool, but it's not compatible with the current Web Reports on the Orion Platform 2020.2.6.

This is what I have in the legacy tool:

SELECT 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 EndDateTime, Nodes.Caption, Nodes.CriticalTier, Nodes.Application, Nodes.WithholdGlobalAlerts, 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 EventTime >= DATEADD(day,-1,GETDATE()) AND (StartTime.EventType = 1) AND (StartTime.NetObjectType = 'N') And Nodes.CriticalTier is NOT NULL AND Nodes.WithholdGlobalAlerts = 0 ORDER BY StartTime.NetworkNode ASC
Is there a way to get this to work for the Web Report? I've tried to import it, but there's an error. Error: Source entity [Events] not found in catalog.
Thanks in advance