How to only list the columns containing a fail value

[rajkumarwipro]

I want to display the events having a FAIL value in any of the columns.

For Eg :

Please help me on this!

[to4kawa · Accepted solution]

| makeresults count=6
| streamstats count
| eval Name="System ".count
| fillnull Status_A Status_B Status_C Status_D Status_E
| foreach Status*[eval <<FIELD>> = mvindex(split("PASS,FAIL",","),random() % 2)]
| table Name Status*
| rename COMMENT as "sample data"

| untable Name Status status
| stats values(eval(if(status="PASS",Status,NULL))) as PASS values(eval(if(status="FAIL",Status,NULL))) as FAIL by Name
| nomv PASS
| nomv FAIL

try after COMMENT

[rajkumarwipro]

Thank you.

[richgalloway]

What is your current search?