bhavesh2903

Comments

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 UpEventTime, * Nodes.Caption, StartTime.Message, DATEDIFF(Mi,…

in Customize Availability Report that would show DownTime and Uptime of Nodes and its Interface in minutes Comment by bhavesh2903 October 2013