Splunk Search

Keep track of max count.

sandeepmakkena
Contributor

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.

0 Karma

tjago11
Communicator

oops, sorry.

0 Karma
Get Updates on the Splunk Community!

Improve Your Security Posture

Watch NowImprove Your Security PostureCustomers are at the center of everything we do at Splunk and security ...

Maximize the Value from Microsoft Defender with Splunk

 Watch NowJoin Splunk and Sens Consulting for this Security Edition Tech TalkWho should attend:  Security ...

This Week's Community Digest - Splunk Community Happenings [6.27.22]

Get the latest news and updates from the Splunk Community here! News From Splunk Answers ✍️ Splunk Answers is ...