Splunk Search

Plot average time between events.

picktheneedle
Loves-to-Learn

Can someone help me with the query to plot average time between events matching a field having certain value e.g msg="xyz"? The span is every 10 minutes. For e.g if events occurs 6000 times in 10 minutes, then average time between events is 600/6000 = 0.1 sec. 

Thanks

 

Labels (1)
0 Karma

gcusello
SplunkTrust
SplunkTrust

Hi @picktheneedle,

you have to filter events in the main search and then count the results in each span, something like this:

index=your_index msg="xyz"
| timechart span=10m count
| eval "Average (sec)"=count/600

to adapt to your real situation.

Ciao.

Giuseppe

0 Karma
Get Updates on the Splunk Community!

New Year, New Changes for Splunk Certifications

As we embrace a new year, we’re making a small but important update to the Splunk Certification ...

[Puzzles] Solve, Learn, Repeat: Unmerging HTML Tables

[Puzzles] Solve, Learn, Repeat: Unmerging HTML TablesFor a previous puzzle, I needed some sample data, and ...

Enterprise Security (ES) Essentials 8.3 is Now GA — Smarter Detections, Faster ...

As of today, Enterprise Security (ES) Essentials 8.3 is now generally available, helping SOC teams simplify ...