Splunk Search

How to display all values in a field?

NizanCohen
Explorer

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.

Labels (1)
0 Karma

Manasa_401
Communicator

Hello @NizanCohen 

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

0 Karma

NizanCohen
Explorer

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).

0 Karma

Manasa_401
Communicator

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

0 Karma
Get Updates on the Splunk Community!

Dashboards: Hiding charts while search is being executed and other uses for tokens

There are a couple of features of SimpleXML / Classic dashboards that can be used to enhance the user ...

Splunk Observability Cloud's AI Assistant in Action Series: Explaining Metrics and ...

This is the fourth post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how ...

Brains, Bytes, and Boston: Learn from the Best at .conf25

When you think of Boston, you might picture colonial charm, world-class universities, or even the crack of a ...