topic Re: How can i use the append command based on an If condition ? in Splunk Search

How can i use the append command based on an If condition ?

harishalipaka — Wed, 28 Nov 2018 06:57:31 GMT

Hi All,

i have a base search ,with field A ,

If field A >0 , I have to append another search query that returns multi columns.

Re: How can i use the append command based on an If condition ?

FrankVl — Wed, 28 Nov 2018 09:25:35 GMT

If the base search is not overly heavy, you could include the base search in the appended subsearch, filter for A>0 in the subsearch and then only return the columns that you actually wanted to add.

So in pseudo code:

base search
| append [ base search | append [ subsearch ] | where A>0 | table subsearchfieldX subsearchfieldY ]

Re: How can i use the append command based on an If condition ?

inventsekar — Wed, 28 Nov 2018 09:38:36 GMT

@FrankVl Superb one!
i learnt this append tidbit from you.
(learning and using this append, appendcols are difficult areas, even for many experienced splunk admins)

Re: How can i use the append command based on an If condition ?

harishalipaka — Wed, 28 Nov 2018 10:37:10 GMT

Hi @FrankVl ,
It is working. Thanks

Re: How can i use the append command based on an If condition ?

FrankVl — Wed, 28 Nov 2018 10:47:52 GMT

Note, the code was just pseudo code. If you really use append like that it will not work, as append adds it as extra lines, so you cannot filter this. It might help if you give a more concrete example of what your search looks like (without the filter).

Something like this works:

| makeresults 
| eval A=1
| table A
| appendcols [ | makeresults | eval A=1 | appendcols [ | makeresults | eval b=1,c=2,d=3 ] | where A>0 | table b,c,d ]

This returns all 4 fields. When running the same example but with A=0, it only returns A:

| makeresults 
| eval A=0
| table A
| appendcols [ | makeresults | eval A=0 | appendcols [ | makeresults | eval b=1,c=2,d=3 ] | where A>0 | table b,c,d ]