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!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...