Splunk Search

Search query - where after stats count command

shayhibah
Path Finder

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

Tags (1)

martin_mueller
SplunkTrust
SplunkTrust

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.

martin_mueller
SplunkTrust
SplunkTrust

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

0 Karma

shayhibah
Path Finder

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

Get Updates on the Splunk Community!

Splunk Observability Cloud’s AI Assistant in Action Series: Analyzing and ...

This is the second post in our Splunk Observability Cloud’s AI Assistant in Action series, in which we look at ...

Elevate Your Organization with Splunk’s Next Platform Evolution

 Thursday, July 10, 2025  |  11AM PDT / 2PM EDT Whether you're managing complex deployments or looking to ...

Splunk Answers Content Calendar, June Edition

Get ready for this week’s post dedicated to Splunk Dashboards! We're celebrating the power of community by ...