Splunk Search

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

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.


0 Karma

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

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.


0 Karma
Get Updates on the Splunk Community!

Observability Newsletter Highlights | March 2023

 March 2023 | Check out the latest and greatestSplunk APM's New Tag Filter ExperienceSplunk APM has updated ...

Security Newsletter Updates | March 2023

 March 2023 | Check out the latest and greatestUnify Your Security Operations with Splunk Mission Control The ...

Platform Newsletter Highlights | March 2023

 March 2023 | Check out the latest and greatestIntroducing Splunk Edge Processor, simplified data ...