Splunk Search

average count events

Shark2112
Communicator

Hey guys.

I need to know what ip have less events then avarage of all devices.

for example:
ip events
1.1.1.1 11
2.2.2.2 10
3.3.3.3 9
4.4.4.4 1

so average is 7.75 and i want to find ip 4.4.4.4

Tags (1)
0 Karma
1 Solution

javiergn
SplunkTrust
SplunkTrust

Eventstats is your friend. Assuming your fields are named IP and events:

| eventstats avg(events) as avg_events
| where events < avg_events

View solution in original post

javiergn
SplunkTrust
SplunkTrust

Eventstats is your friend. Assuming your fields are named IP and events:

| eventstats avg(events) as avg_events
| where events < avg_events
Get Updates on the Splunk Community!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...