topic Re: How to only list the columns containing a fail value in Splunk Search

How to only list the columns containing a fail value

rajkumarwipro — Sat, 06 Jun 2020 00:02:17 GMT

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

For Eg :

Please help me on this!

Re: How to only list the columns containing a fail value

richgalloway — Fri, 15 May 2020 17:05:44 GMT

What is your current search?

Re: How to only list the columns containing a fail value

to4kawa — Sat, 16 May 2020 04:05:18 GMT

| 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

Re: How to only list the columns containing a fail value

rajkumarwipro — Mon, 18 May 2020 09:30:54 GMT

Thank you.