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!

Optimize Cloud Monitoring

  TECH TALKS Optimize Cloud Monitoring Tuesday, August 13, 2024  |  11:00AM–12:00PM PST   Register to ...

What's New in Splunk Cloud Platform 9.2.2403?

Hi Splunky people! We are excited to share the newest updates in Splunk Cloud Platform 9.2.2403! Analysts can ...

Stay Connected: Your Guide to July and August Tech Talks, Office Hours, and Webinars!

Dive into our sizzling summer lineup for July and August Community Office Hours and Tech Talks. Scroll down to ...