Splunk Search

Splunk query to compare a field from search with a field from lookup and find the unmatched ones

srivardhini92
Observer

Hi Can you please let me know how to frame splunk query compare a field from search with a field from lookup and find the unmatched ones from the lookup table

Labels (1)
0 Karma

richgalloway
SplunkTrust
SplunkTrust

The general form is

<<some search that returns field 'foo'>> NOT [ | inputlookup mylookup.csv | field foo ]

If the lookup file does not contain 'foo' then you'll need a rename command to change what it has to 'foo'.

---
If this reply helps you, Karma would be appreciated.
0 Karma

PickleRick
SplunkTrust
SplunkTrust

@richgalloway's solution is one of the possible answers. It has its pros and cons. The other possibility is to search for all events, do a lookup on them and find non-matched ones.

<your_search>
| lookup your_lookup match_field OUTPUT match_field AS new_match_field
| where isnull(new_match_field

 Typically you'd use mine option later in the search pipeline while @richgalloway 's solution would probably be more suitable in the initial search.

Get Updates on the Splunk Community!

Enter the Splunk Community Dashboard Challenge for Your Chance to Win!

The Splunk Community Dashboard Challenge is underway! This is your chance to showcase your skills in creating ...

.conf24 | Session Scheduler is Live!!

.conf24 is happening June 11 - 14 in Las Vegas, and we are thrilled to announce that the conference catalog ...

Introducing the Splunk Community Dashboard Challenge!

Welcome to Splunk Community Dashboard Challenge! This is your chance to showcase your skills in creating ...