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!

Archived Metrics Now Available for APAC and EMEA realms

We’re excited to announce the launch of Archived Metrics in Splunk Infrastructure Monitoring for our customers ...

Detecting Remote Code Executions With the Splunk Threat Research Team

WATCH NOWRemote code execution (RCE) vulnerabilities pose a significant risk to organizations. If exploited, ...

Enter the Dashboard Challenge and Watch the .conf24 Global Broadcast!

The Splunk Community Dashboard Challenge is still happening, and it's not too late to enter for the week of ...