Splunk Search

How to search csv for values in a lookup table?


I have a large csv with lots of columns and a lookup table below


How do I search all fields for values in my lookup table? For example I want to look for values like "badfile.exe".

Tags (3)
0 Karma


Read the lookup file in a subsearch and use the format command to help build the main search.

index=foo [|inputlookup payload.csv | fields payload | format]

will expand into the search index=foo (payload=*.exe OR payload=*.zip OR payload=*.7z)

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