Splunk Search

How do I search for multiple files in Splunk?

sunnyparmar
Communicator

I have one Excel sheet in which there are around 1150 bum IDs. One of example given below.

bum_id a62f1ede-e3c2-418a-8376-945d94288c56

Can anybody suggest to me how I can search all of those in one shot in Splunk? Any insights would be appreciated.

0 Karma

mstjohn_splunk
Splunk Employee
Splunk Employee

hi @sunnyparmar

Did the answer below solve your problem? If so, please resolve this post by approving it! If your problem is still not solved, keep us updated so that someone else can help ya. Thanks for posting!

0 Karma

sduff_splunk
Splunk Employee
Splunk Employee

Have you indexed these Excel files in Splunk already? You may need to convert them to CSVs, or use some other approach ( https://simonduff.net/processing_excel_xlsx_files_with_python/ )

Once you have them in Splunk, its very simple to search for them

index=* bum_id a62f1ede-e3c2-418a-8376-945d94288c56

or
index=* source="*/file1.csv" OR source="*/file2.csv" OR source="*/file3.csv" bum_id a62f1ede-e3c2-418a-8376-945d94288c56

0 Karma
Get Updates on the Splunk Community!

Extending Observability Content to Splunk Cloud

Watch Now!   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to leverage ...

More Control Over Your Monitoring Costs with Archived Metrics!

What if there was a way you could keep all the metrics data you need while saving on storage costs?This is now ...

New in Observability Cloud - Explicit Bucket Histograms

Splunk introduces native support for histograms as a metric data type within Observability Cloud with Explicit ...