topic Re: displaying all values in a field in Splunk Search

How to display all values in a field?

NizanCohen — Mon, 19 Dec 2022 15:52:00 GMT

Hi.

I'm looking to make a table/stats of all fields in a search to display all values inside of each field.

Similar to stats count, but instead of counting the amount of values, I want to display all values inside.

Manasa_401 — Mon, 19 Dec 2022 10:55:41 GMT

Try this : stats values(*) as *

OR using a by clause

stats values(*) as * by unique_field

This will give the result as multivalued field.

Thanks

Manasa

NizanCohen — Mon, 19 Dec 2022 11:43:07 GMT

Should I keep it as "unique_field"?

Because it returns no results the way you wrote here (I copy pasted it the way it is).

Manasa_401 — Mon, 19 Dec 2022 12:22:34 GMT

That unique_field is just for reference.

First try |stats values(*) as *

This will give all the data in single row as multivalued fields.

If you have any field in your data by which you can group it then use that field in by clause.

|stats values(*) as * by your_field_name