Step 1: I want to run a splunk search on my local machine data and import the results into a csv/text file. Step 2: Then I want to run an R script/Program on the obtained text file to create another excel file consisting of the results.
I have, at present, the R app (created by Rfujara) installed too.
Is there some way I can automate the whole process or integrate step1 and Step 2 into a single step so that I can directly view the results on a dashboard in Splunk by simple running a search query or by running an R script in the search bar?
Simply put, I want to be able to do something like
"the splunk search query to get necessary data" | r script to run/extract what I want from prev step | Splunk command to view results on dashboard
My primary issue lies in pointing the data obtained from the splunk search query into R directly, without having to change the file names in my R program manually each time I run it.