topic Re: How to use NOT match condition in Case statement for Multi valued field in Splunk Search

How to use NOT match condition in Case statement for Multi valued field

manjunath_0208 — Wed, 17 Nov 2021 16:50:54 GMT

|eval SNOW_Description=case(EMGC_ADMINSERVER_Status!="k1","Java Process EMGC_ADMINSERVER data not available in splunk on host, EMGC_ORACLE_Status!="k2","Java Process EMGC_ORACLE data not available in splunk on host)

Here I am trying to use multiple fields inside case statement. I am not getting correct output. How can this be achieved?

Re: How to use NOT match condition in Case statement for Multi valued field

richgalloway — Wed, 17 Nov 2021 16:58:54 GMT

What output are you getting and what output do you expect? The title of the post says "multi valued field", but the body says "multiple fields". That's two different things so which is the case? The latter is commonplace and should work easily, whereas the former requires one or more mv* functions.

That looks like it should work once the quotation marks are matched up.

Re: How to use NOT match condition in Case statement for Multi valued field

manjunath_0208 — Wed, 17 Nov 2021 17:33:09 GMT

In the above query, I am getting the output if the first condition EMGC_ADMINSERVER_Status!="k1" is met.

I am expecting to get the output when both conditions EMGC_ADMINSERVER_Status!="k1 and EMGC_ORACLE_Status!="k2" are met.

Re: How to use NOT match condition in Case statement for Multi valued field

PickleRick — Wed, 17 Nov 2021 17:59:17 GMT

Case is evaluated from the left until a condition is met.

So if the first condition is met, subsequent ones are not evaluated. You might want to rethink your conditions/evaluation order.