Splunk Search

how to see the data in table command which is showing empty cells

venugoski
Explorer

i see the splunk query 
index="sample" "log_processed.env"=prod "log_processed.app"=sample "log_processed.traceId"=90cf115a05ebb87b2
| table _time, log_processed.message

this is displaying the empty messages in a table cell . i could the event in the raw format.
do i have any limit to see the whole message in table box .

Labels (1)
Tags (1)
0 Karma

inventsekar
SplunkTrust
SplunkTrust

Hi @venugoski .. out of 23 events some events(as shown in the 3rd event in table output) may not have that particular "log_processed.message". 

Lets doublecheck - pls check this one.. as the table command printing the _raw also, you can verify on same screen:

index="sample" "log_processed.env"=prod "log_processed.app"=sample "log_processed.traceId"=90cf115a05ebb87b2
| table _time log_processed.message _raw
0 Karma

venugoski
Explorer

hi @inventsekar Thank you ,
you are right,  some events not have that particular "log_processed.message".
when i put | spath input=_raw i am seeing the events in table format but also seeing the duplicate events. can we avoid that.

index="sample" "log_processed.app"=mercury "log_processed.traceId"=dc57c0b7f0e8cfdee5002b62873f5de7 | spath input=_raw | table _time, log_processed.message

0 Karma

yuanliu
SplunkTrust
SplunkTrust

Drop spath.  Splunk is already giving you field values.  Adding spath as illustrated in your example will only give each field a duplicate value.  When your log source is JSON, spath can be used to extract from a specific field that embeds an escaped JSON, or to extract value of a specific path.  | spath input=_raw does neither.

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!

[Puzzles] Solve, Learn, Repeat: Character substitutions with Regular Expressions

This challenge was first posted on Slack #puzzles channelFor BORE at .conf23, we had a puzzle question which ...

Splunk Community Badges!

  Hey everyone! Ready to earn some serious bragging rights in the community? Along with our existing badges ...

[Puzzles] Solve, Learn, Repeat: Matching cron expressions

This puzzle (first published here) is based on matching timestamps to cron expressions.All the timestamps ...