topic Re: Search query - where after stats count command in Splunk Search

Search query - where after stats count command

shayhibah — Sun, 03 Jun 2018 09:12:31 GMT

I'm trying to count the value of "name" field and to show results only where the count is greater than 1.

My query is: | stats count by name| where count > 1

What am I missing? 😮

Thanks

martin_mueller — Sun, 03 Jun 2018 12:20:34 GMT

The search looks correct if you want "count events for each value of the name field, and only show name field values that occur more than once".

If that's not what you're looking for, do elaborate more what your actual use case is.

shayhibah — Sun, 03 Jun 2018 12:24:26 GMT

Thats exatcly what I want.
The problem is that I can find events on the results that their count equals to 1.

martin_mueller — Sun, 03 Jun 2018 14:03:49 GMT

Got a screenshot that includes your search and results with count=1?