Archive

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