Splunk Search

How to list with events time difference greater than 0.5 secs?

msg4sunil
Path Finder

How do I list those events within a set of events(say expand the below query) wherein say 2 consecutive's event time difference is more than 0.5 secs?

index=index1 * "orderid"

 

thank you

Labels (1)
0 Karma
1 Solution

bowesmana
SplunkTrust
SplunkTrust

Simple example here

index=index1 * "orderid"
| delta _time as timeDiff
| where timeDiff < -0.5

That is simply selecting events where the earlier event is more than 0.5 seconds before the current event, but not sure if that's exactly what you're after

View solution in original post

msg4sunil
Path Finder

@bowesmana , lovely thanks a lot!

0 Karma

bowesmana
SplunkTrust
SplunkTrust

Simple example here

index=index1 * "orderid"
| delta _time as timeDiff
| where timeDiff < -0.5

That is simply selecting events where the earlier event is more than 0.5 seconds before the current event, but not sure if that's exactly what you're after

Get Updates on the Splunk Community!

The Splunk Success Framework: Your Guide to Successful Splunk Implementations

Splunk Lantern is a customer success center that provides advice from Splunk experts on valuable data ...

Splunk Training for All: Meet Aspiring Cybersecurity Analyst, Marc Alicea

Splunk Education believes in the value of training and certification in today’s rapidly-changing data-driven ...

Investigate Security and Threat Detection with VirusTotal and Splunk Integration

As security threats and their complexities surge, security analysts deal with increased challenges and ...