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!

Threat Hunting Unlocked: How to Uplevel Your Threat Hunting With the PEAK Framework ...

WATCH NOWAs AI starts tackling low level alerts, it's more critical than ever to uplevel your threat hunting ...

Splunk APM: New Product Features + Community Office Hours Recap!

Howdy Splunk Community! Over the past few months, we’ve had a lot going on in the world of Splunk Application ...

Index This | Forward, I’m heavy; backward, I’m not. What am I?

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