Splunk Search

How do you create a table with each row being a log and every column being a recognized "Interesting Field"?

ixixix_spl
Explorer

I was wondering if there is an easy way to create a table that contains every single recognized interesting field instead of doing the usual | table field1, field2... method.

To be clear I want to have each row in the table as a separate instance/log and not a summary of counts. In other words, I would like a substitution for | table but to capture every single interesting field that is recognized. Thanks!

0 Karma

HiroshiSatoh
Champion

I am sorry if I misunderstood the question.
In this search statement you can see the fields used in the log and the number of occurrences.

index=* | stats dc(*) as * | transpose
0 Karma

ixixix_spl
Explorer

sorry this doesnt answer my question i am looking for a shortcut that will basically do something like this:

       field1 .    field2 ....  field100 
log A:    stringA .  stringB .  stringC 
logB:     stringD . stringE .   stringF

i know you can do it manually by performing the command | table field1, field2... field100

but typing out every field i want to capture is extremely time consuming so i am wondering if there is a shortcut to do it

0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Announcing Modern Navigation: A New Era of Splunk User Experience

We are excited to introduce the Modern Navigation feature in the Splunk Platform, available to both cloud and ...

Modernize your Splunk Apps – Introducing Python 3.13 in Splunk

We are excited to announce that the upcoming releases of Splunk Enterprise 10.2.x and Splunk Cloud Platform ...

Step into “Hunt the Insider: An Splunk ES Premier Mystery” to catch a cybercriminal ...

After a whole week of being on call, you fell asleep on your keyboard, and you hit a sequence of buttons that ...