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.
@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
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
This worked thank you!
@kdelvillar
Glad to help you. Can you please accept the answer and upvote comment to help the community?