Splunk Search

How to search csv for values in a lookup table?

akke
Explorer

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

payload
*.exe
*.zip
*.7z

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

richgalloway
SplunkTrust
SplunkTrust

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
Register for .conf21 Now! Go Vegas or Go Virtual!

How will you .conf21? You decide! Go in-person in Las Vegas, 10/18-10/21, or go online with .conf21 Virtual, 10/19-10/20.