Splunk Search

Finding a host from multiple csv

Saikat001
Explorer

Lets say, i have 1000+ csv and i want to find a host that might be present in multiple csv's. i want to find and return the names of all the csv's containing the particular host. how to acheive this?

Labels (2)
0 Karma

venkatasri
SplunkTrust
SplunkTrust

Hi @Saikat001 

There are two ways that i could think of, you can write a custom script to read through and write the hosts and csv filenames.

Splunk way if only CSV are same structure otherwise you have to normalize the fields takes good amount of time give csv's are too many, ingest 1000+ csv to splunk using UF and write a SPL to find the hostname details by source. Your source is csv filename.

----

An upvote would be appreciated if it helps!

0 Karma
Get Updates on the Splunk Community!

Leveraging Automated Threat Analysis Across the Splunk Ecosystem

Enhance Security Operations with Automated Threat Analysis in the Splunk EcosystemAre you leveraging ...

Splunk Developers: Go Beyond the Dashboard with These .Conf25 Sessions

  Whether you’re building custom apps, diving into SPL2, or integrating AI and machine learning into your ...

Index This | How do you write 23 only using the number 2?

July 2025 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with this month’s ...