Splunk Search

How to derive earliest and latest from a list of events that overlap in timespans

neusse
Path Finder

I need to roll up several events with overlapping start and stop times. I need the total time of the events without doing a sum of the elapsed time for each event.

Each event in the series has a start time and an end time. The times may or may not overlap. The results need to be one or more time spans that equal the earliest and latest for each consecutive amount of time.
alt text

The green are the event time spans and the red is the needed result time. I am at a loss as to how to approach this.

Thanks.

0 Karma

twinspop
Influencer
... | stats min(_time) as start max(_time) as end by some_key_in_your_events | eval span_seconds=end-start 
0 Karma

neusse
Path Finder

Is there a way to detect gaps in the middle like the chart shows above? So the red is two time spans. I can think of a way to detect that. If the data is always overlapping this works. But my data is not always overlapping.

Thanks,

0 Karma
.conf21 CFS Extended through 5/20!

Don't miss your chance
to share your Splunk
wisdom in-person or
virtually at .conf21!

Call for Speakers has
been extended through
Thursday, 5/20!