Splunk Search

How to get all field values from large "| stats values(field)" command?

woodcock
Esteemed Legend

Any search that has many field values and ends in "| stats values(field)" will show a short list of field values followed by "[and xxx more values]". How can I get all of the values?

Tags (2)
1 Solution

bwooden
Splunk Employee
Splunk Employee

There are varying ways, depending on the end goal:

You can list them all horizontally in a separated list

... | stats values(said_field) as said_field | mvcombine delim=" " said_field

You can list them in separate results

... | stats values(said_field) as said_field | mvexpand said_field

...and others.

View solution in original post

bwooden
Splunk Employee
Splunk Employee

There are varying ways, depending on the end goal:

You can list them all horizontally in a separated list

... | stats values(said_field) as said_field | mvcombine delim=" " said_field

You can list them in separate results

... | stats values(said_field) as said_field | mvexpand said_field

...and others.

Kawtar
Path Finder

Thank you.

0 Karma
Get Updates on the Splunk Community!

Developer Spotlight with William Searle

The Splunk Guy: A Developer’s Path from Web to Cloud William is a Splunk Professional Services Consultant with ...

Major Splunk Upgrade – Prepare your Environment for Splunk 10 Now!

Attention App Developers: Test Your Apps with the Splunk 10.0 Beta and Ensure Compatibility Before the ...

Stay Connected: Your Guide to June Tech Talks, Office Hours, and Webinars!

What are Community Office Hours?Community Office Hours is an interactive 60-minute Zoom series where ...