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!

Build and Launch AI Agents from Your Splunk Workflows

  Register We’ve all been there: juggling alerts, runbooks, and endless manual searches. What if you could ...

Splunk Cloud Application Management in Terraform

Register   On Tuesday, August 4 at 11AM PDT / 2PM EDT, we’re diving into how you can bring Infrastructure as ...

Get Agentic with Splunk Lantern: Connect to Cisco Cloud Control, Transform ...

Splunk Lantern is Splunk’s customer success center that provides practical guidance from Splunk experts on key ...