Splunk Search

Show All the Results within the Field

keldridg2
New Member

I want to show all the results within the field itself as I do not want it just show the top 10 limits from the list. I would like to see the result that lowest number of results. Is there a command out there that can show you unlimited results?

0 Karma

aberkow
Builder

The values and list functions of the stats command in a search might be what you're looking for based on your question, but I agree with the person above that we likely need a bit more information to adequately answer your question. If you want to try running a search, something like this might be it:

your initial search...
| stats values(field) as uniqueValuesFromField, list(field) as listOfValuesFromField by whateverGroupByYouWantOrNone

another interpretation of your question: you want to see the result with the lowest count:

your initial search...
| stats count by field

Let me know if either of these help!

EDIT -- Using stats with the min function seemed to work here

0 Karma

Sahr_Lebbie
Path Finder

Keldrig2, What search are you running?

And are you wanting to see the values from the field based on the interesting fields or are you okay with looking at all the results in a table format?

0 Karma

keldridg2
New Member

I am searching for a eventtype in looking for the lowest values. I do want to see the field based from the interesting fields.

0 Karma

aberkow
Builder

Try using the min function in a stats command then?

0 Karma

keldridg2
New Member

Yes, that help me out.

0 Karma
Get Updates on the Splunk Community!

Adoption of RUM and APM at Splunk

    Unleash the power of Splunk Observability   Watch Now In this can't miss Tech Talk! The Splunk Growth ...

Routing logs with Splunk OTel Collector for Kubernetes

The Splunk Distribution of the OpenTelemetry (OTel) Collector is a product that provides a way to ingest ...

Welcome to the Splunk Community!

(view in My Videos) We're so glad you're here! The Splunk Community is place to connect, learn, give back, and ...