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.

Report

taís over 8 years ago

Hello,

I would like the support of you for creating availability reports to report in hours and minutes downtime.

Today is the report used below, but need to make manual adjustments in the collection period each month. It is possible an easier way to perform this type of report?

SELECT

StartTime.EventTime,

Nodes.Estado,

Nodes.Empresa,

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 DurationInMinutes

FROM Events StartTime INNER JOIN Nodes ON StartTime.NetworkNode = Nodes.NodeID

WHERE (EventTime BETWEEN 42123 AND 42132 ) --------> This Month

AND

(

(Nodes.Dispositivo = 'Roteador') AND

(Nodes.Estado = 'Amazonas') AND

(

(EventType = 1) OR

(EventType = 0))

)

ORDER BY Nodes.Caption ASC

----------------------------------------------------------------