Splunk Search

How do you compare a field in a search table with a lookup table field?

kdelvillar
Engager

I have a search that produces a table that contains a field called "http_referer", and I want to compare this field against a field called "TargetURL" that's in my inputlookup redirect-url.csv result. If there's a match I would like it to display all the matches.

Tags (1)
0 Karma
1 Solution

kamlesh_vaghela
SplunkTrust
SplunkTrust

@kdelvillar

Have you tried lookup command? I'm not able to understand all the matches with!!!??

Can you please try below search?

YOUR_TABLE_SEARCH | lookup redirect-url.csv TargetURL as http_referer OUTPUTNEW TargetURL as myTargetURL | where isnotnull(myTargetURL)

https://docs.splunk.com/Documentation/Splunk/7.2.0/SearchReference/Lookup

View solution in original post

kamlesh_vaghela
SplunkTrust
SplunkTrust

@kdelvillar

Have you tried lookup command? I'm not able to understand all the matches with!!!??

Can you please try below search?

YOUR_TABLE_SEARCH | lookup redirect-url.csv TargetURL as http_referer OUTPUTNEW TargetURL as myTargetURL | where isnotnull(myTargetURL)

https://docs.splunk.com/Documentation/Splunk/7.2.0/SearchReference/Lookup

kdelvillar
Engager

This worked thank you!

0 Karma

kamlesh_vaghela
SplunkTrust
SplunkTrust

@kdelvillar

Glad to help you. Can you please accept the answer and upvote comment to help the community?

0 Karma
Get Updates on the Splunk Community!

Splunk Training for All: Meet Aspiring Cybersecurity Analyst, Marc Alicea

Splunk Education believes in the value of training and certification in today’s rapidly-changing data-driven ...

Investigate Security and Threat Detection with VirusTotal and Splunk Integration

As security threats and their complexities surge, security analysts deal with increased challenges and ...

Observability Highlights | January 2023 Newsletter

 January 2023New Product Releases Splunk Network Explorer for Infrastructure MonitoringSplunk unveils Network ...