Splunk Search

How to import mulitple host csv file to fetch data in splunk?

shariz
New Member

I am trying to download vulnerability report for a 1000 hosts. Instead of providing them in the splunk query. I thought of uploading them as a csv format and fetch the data. is it possible in splunk? 

Labels (1)
0 Karma

diogofgm
SplunkTrust
SplunkTrust

Correct me if I'm wrong, not sure if this is what you mean, but assuming you want to search the vulnerability report data that you have in a csv file by using the file itself instead of indexing the data and then search it, yes its possible. Just upload the csv file as a lookup and you can do `|inputlookup myreport.csv` . Just make sure you have the right permissions set on the lookup.
There are some caveats using this approach. You won't be able to use the search timepicker since what you are doing in essentially loading a lookup and it will load everything in that file but you can still use some spl after the input lookup to filter whatever you need.

------------
Hope I was able to help you. If so, some karma would be appreciated.
0 Karma
Get Updates on the Splunk Community!

New Year, New Changes for Splunk Certifications

As we embrace a new year, we’re making a small but important update to the Splunk Certification ...

Stay Connected: Your Guide to January Tech Talks, Office Hours, and Webinars!

What are Community Office Hours? Community Office Hours is an interactive 60-minute Zoom series where ...

[Puzzles] Solve, Learn, Repeat: Reprocessing XML into Fixed-Length Events

This challenge was first posted on Slack #puzzles channelFor a previous puzzle, I needed a set of fixed-length ...