https://community.splunk.com/t5/Splunk-Search/Show-All-the-Results-within-the-Field/m-p/468773#M191960 <P>Keldrig2, What search are you running?</P> <P>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?</P> Wed, 23 Oct 2019 22:16:52 GMT Sahr_Lebbie 2019-10-23T22:16:52Z https://community.splunk.com/t5/Splunk-Search/Show-All-the-Results-within-the-Field/m-p/468772#M191959 <P>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?</P> Wed, 23 Oct 2019 21:36:31 GMT https://community.splunk.com/t5/Splunk-Search/Show-All-the-Results-within-the-Field/m-p/468772#M191959 keldridg2 2019-10-23T21:36:31Z https://community.splunk.com/t5/Splunk-Search/Show-All-the-Results-within-the-Field/m-p/468773#M191960 <P>Keldrig2, What search are you running?</P> <P>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?</P> Wed, 23 Oct 2019 22:16:52 GMT https://community.splunk.com/t5/Splunk-Search/Show-All-the-Results-within-the-Field/m-p/468773#M191960 Sahr_Lebbie 2019-10-23T22:16:52Z https://community.splunk.com/t5/Splunk-Search/Show-All-the-Results-within-the-Field/m-p/468774#M191961 <P>The <CODE>values</CODE> and <CODE>list</CODE> functions of the <CODE>stats</CODE> 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:</P> <P><CODE>your initial search...<BR /> | stats values(field) as uniqueValuesFromField, list(field) as listOfValuesFromField by whateverGroupByYouWantOrNone</CODE></P> <P>another interpretation of your question: you want to see the result with the lowest count:</P> <P><CODE>your initial search...<BR /> | stats count by field</CODE></P> <P>Let me know if either of these help!</P> <P>EDIT -- Using <CODE>stats</CODE> with the <CODE>min</CODE> function seemed to work here</P> Wed, 23 Oct 2019 23:09:29 GMT https://community.splunk.com/t5/Splunk-Search/Show-All-the-Results-within-the-Field/m-p/468774#M191961 aberkow 2019-10-23T23:09:29Z https://community.splunk.com/t5/Splunk-Search/Show-All-the-Results-within-the-Field/m-p/468775#M191962 <P>I am searching for a eventtype in looking for the lowest values. I do want to see the field based from the interesting fields.</P> Thu, 24 Oct 2019 05:02:34 GMT https://community.splunk.com/t5/Splunk-Search/Show-All-the-Results-within-the-Field/m-p/468775#M191962 keldridg2 2019-10-24T05:02:34Z https://community.splunk.com/t5/Splunk-Search/Show-All-the-Results-within-the-Field/m-p/468776#M191963 <P>Try using the <CODE>min</CODE> function in a <CODE>stats</CODE> command then? </P> Thu, 24 Oct 2019 19:59:05 GMT https://community.splunk.com/t5/Splunk-Search/Show-All-the-Results-within-the-Field/m-p/468776#M191963 aberkow 2019-10-24T19:59:05Z https://community.splunk.com/t5/Splunk-Search/Show-All-the-Results-within-the-Field/m-p/468777#M191964 <P>Yes, that help me out.</P> Fri, 25 Oct 2019 02:45:50 GMT https://community.splunk.com/t5/Splunk-Search/Show-All-the-Results-within-the-Field/m-p/468777#M191964 keldridg2 2019-10-25T02:45:50Z