Dashboards & Visualizations

How to return or display the value that is being searched and if not coming in the search results

sriky
New Member

When i search multiple values like (search a OR b OR c OR d OR e) how i can return or display the value which is not coming in the search results

Tags (1)
0 Karma

woodcock
Esteemed Legend

This is the Sentinel Search problem discussed (with solution) here:

https://conf.splunk.com/session/2015/conf2015-LookupTalk.pdf

0 Karma

CarsonZa
Contributor

@skoelpin is referring to something like this

| appendpipe 
    [ |stats count(a) as a
    | eval empty=if(isnum(a),"0", "a")] 

you would have to add the append to for each category a, b, c... etc

0 Karma

sriky
New Member

if i try to add append for each category i am getting error as Error in 'appendpipe' command: The last argument must be a subsearch.

aaaa@gmail.com | appendpipe [stats count as 1] OR ccc@gmail.com| appendpipe [stats count as 2]

0 Karma

CarsonZa
Contributor

each append needs to be closed by "]". that closes the statement but you have a random OR in there

0 Karma

skoelpin
SplunkTrust
SplunkTrust

You will need to do a sub search and append the results onto the first search

0 Karma

sriky
New Member

Hi, Could you please show me some examples?

0 Karma
Get Updates on the Splunk Community!

Splunk Enterprise Security 8.x: The Essential Upgrade for Threat Detection, ...

 Prepare to elevate your security operations with the powerful upgrade to Splunk Enterprise Security 8.x! This ...

Get Early Access to AI Playbook Authoring: Apply for the Alpha Private Preview ...

Passionate about security automation? Apply now to our AI Playbook Authoring Alpha private preview ...

Reduce and Transform Your Firewall Data with Splunk Data Management

Managing high-volume firewall data has always been a challenge. Noisy events and verbose traffic logs often ...