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.
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!
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