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 (3)
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!

.conf24 | Registration Open!

Hello, hello! I come bearing good news: Registration for .conf24 is now open!   conf is Splunk’s rad annual ...

ICYMI - Check out the latest releases of Splunk Edge Processor

Splunk is pleased to announce the latest enhancements to Splunk Edge Processor.  HEC Receiver authorization ...

Introducing the 2024 SplunkTrust!

Hello, Splunk Community! We are beyond thrilled to announce our newest group of SplunkTrust members!  The ...