Splunk Search

Keep track of max count.


| stats avg(time) as "median", max(time) as MaxMedian max(time99) as "Max99th", max(time999) as Max999th by host

I have something like this, I also want a count of max(99th) by host in past 1hr.

Just make it clear, let say I'm running search for 1hr, I want to calculate max(99th) value every 10mins and display its count by host but, I still want my stats to for whole 1hr.

Say we have host A, B and C
at 00:10 the max(99th) is on host-A
at 00:20 the max(99th) is on host-A
at 00:30 the max(99th) is on host-B

I want to display
host-A median MaxMedian Max99th Max999th "2 times out of 3"
host-B median MaxMedian Max99th Max999th "1 time out of 3"
host-C median MaxMedian Max99th Max999th "0 times out of 3"
Thanks for your time.

0 Karma


oops, sorry.

0 Karma
Get Updates on the Splunk Community!

Enterprise Security Content Update (ESCU) | New Releases

In the last month, the Splunk Threat Research Team (STRT) has had 2 releases of new security content via the ...

Announcing the 1st Round Champion’s Tribute Winners of the Great Resilience Quest

We are happy to announce the 20 lucky questers who are selected to be the first round of Champion's Tribute ...

We’ve Got Education Validation!

Are you feeling it? All the career-boosting benefits of up-skilling with Splunk? It’s not just a feeling, it's ...