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!

Splunk Observability for AI

Don’t miss out on an exciting Tech Talk on Splunk Observability for AI! Discover how Splunk’s agentic AI ...

[Puzzles] Solve, Learn, Repeat: Dereferencing XML to Fixed-length events

This challenge was first posted on Slack #puzzles channelFor a previous puzzle, I needed a set of fixed-length ...

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

What are Community Office Hours? Community Office Hours is an interactive 60-minute Zoom series where ...