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
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Mile High Learning with Splunk University, Denver, Colorado

If Denver is known for its mile-high elevation, Splunk University is about to raise the bar on technical ...

IT Service Intelligence 5.0 Series: Your Guide to the June Launch

We are excited to announce the June release of Splunk IT Service Intelligence (ITSI) 5.0. This update ...

Agent Mode Engaged! Enchaining Agentic Operations with Splunk AI Assistant 2.0

    Are you ready to transform how your team handles complex data requests? We invite you to our upcoming ...