Splunk Search

how to do a stats count and generate all of the fields

mrtolu6
Path Finder

I'm trying to do a stats command to find a count of any value less than 2 counts and display all the other fields. I only want a stats count on one field, but I want to display all the field that is generated with that stats count result.

This is my search query
sourcetype="sourcenamet" search string | stats count by field1 | where count<2 | | table field1 field 2 field3 field4

Tags (1)
0 Karma
1 Solution

woodcock
Esteemed Legend

Switch to eventstats:

sourcetype="sourcenamet" search string | eventstats count by field1 | where count<2 | table field1 field 2 field3 field4

View solution in original post

0 Karma

woodcock
Esteemed Legend

Switch to eventstats:

sourcetype="sourcenamet" search string | eventstats count by field1 | where count<2 | table field1 field 2 field3 field4
0 Karma
Get Updates on the Splunk Community!

Automatic Discovery Part 1: What is Automatic Discovery in Splunk Observability Cloud ...

If you’ve ever deployed a new database cluster, spun up a caching layer, or added a load balancer, you know it ...

Real-Time Fraud Detection: How Splunk Dashboards Protect Financial Institutions

Financial fraud isn't slowing down. If anything, it's getting more sophisticated. Account takeovers, credit ...

Splunk + ThousandEyes: Correlate frontend, app, and network data to troubleshoot ...

 Are you tired of troubleshooting delays caused by siloed frontend, application, and network data? We've got a ...