Keep track of max count.

sandeepmakkena — Sat, 28 Sep 2019 18:04:41 GMT

Mysesarch
| 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.

Re: Keep track of max count.

tjago11 — Tue, 01 Oct 2019 14:59:50 GMT

oops, sorry.

topic Keep track of max count. in Splunk Search

Keep track of max count.

Re: Keep track of max count.