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?