Query on DB

jedski

If Event Date Up > Event Date Down = Event Date Up (display)
If Event Date Up < Event Date Down = Event Date Down (display)

Is this possible if we'll make use of the sql database? We need to display how many days or minutes or seconds the node has been down. Anyone who has an idea on how we can do this using the sql since this is not yet possible using orion?

 

thanks,

Jed

Lnavin

You should be able to use the query below to get downtime in Minutes.  I have adapted this based on a report I found here.  You may need to adjust the NetObjectType. 

 

SELECT      

StartTime.EventTime,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))      FROM Events StartTime INNER JOIN Nodes ON StartTime.NetworkNode = Nodes.NodeID   WHERE (StartTime.EventType = 1) AND (StartTime.NetObjectType = 'N')   ORDER BY Nodes.Caption