How can I create lookup table file(csv file) automatically?

[tkdguq0110]

I just want to create csv file automatically everyday

for example, today just is created 20200417.csv
tomorrow will be created 20200418.csv ...

Is it possible??

[manjunathmeti]

You can use map command and get the data in csv using below query. You can append OR join below query with your main search.

| makeresults | eval date = strftime(now(), "%Y%m%d") | map search="| inputlookup $date$.csv"

[tkdguq0110]

thanks for your help!

[to4kawa · Accepted solution]

https://www.splunk.com/en_us/blog/tips-and-tricks/splunk-rest-api-is-easy-to-use.html
try and make cron

[tkdguq0110]

thanks for your help!