Splunk Search

Why isn't table column formatting working for some rows in the following search?

ddelapasse
Explorer

Can anyone tell me why coloring on these true/false values is not working for all the rows?

alt text

Tags (1)
0 Karma
1 Solution

woodcock
Esteemed Legend

The problem is that your fields are multi-valued. Add this to the end of your search and it should work fine:

| foreach streamMissing shouldBeRecording [ eval <<FIELD>> = mvdedup(<<FIELD>>) ]

View solution in original post

0 Karma

woodcock
Esteemed Legend

The problem is that your fields are multi-valued. Add this to the end of your search and it should work fine:

| foreach streamMissing shouldBeRecording [ eval <<FIELD>> = mvdedup(<<FIELD>>) ]
0 Karma

ddelapasse
Explorer

Worked perfectly. Thanks very much!

0 Karma

wagnerlucena
Explorer

Are you using table or stats command in your search ?
It is not working because there is 2 values in one unique row. I mean, the Splunk will only color the value if the value match exactly true or false, not False False or True True in same line. If you are using table commands to show the results, you will need to change to stats command.

0 Karma
Get Updates on the Splunk Community!

Splunk Observability Cloud's AI Assistant in Action Series: Observability as Code

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

Splunk Answers Content Calendar, July Edition I

Hello Community! Welcome to another month of Community Content Calendar series! For the month of July, we will ...

Secure Your Future: Mastering Upgrade Readiness for Splunk 10

Spotlight: The Splunk Health Assistant Add-On  The Splunk Health Assistant Add-On is your ultimate companion ...