0 Replies Latest reply on Oct 13, 2008 12:13 PM by dhardy

    SQL Query assistance please

    dhardy

      I've created a report to display outage events (Node Down, Int down ect.) for a particular node. What I need is a summation of total downtime where end time minus start time + sequences of the same for 1000s of events.


       ie  

      n

      ? i=1: X2i - X2i-1


       Does anyone know the most simple way to find the sum of what I just mentioned in a SQL query?