topic Record extract based on data value: KV Store/CSV in Getting Data In

Record extract based on data value: KV Store/CSV

hemendralodhi — Mon, 21 Mar 2016 04:58:15 GMT

Hello,

We have a requirement where we have one csv file which contains around 30K records of data and need to extract complete row based on data values passed as an API or search parameter. Each time there can be different data values passed.

What is the best and efficient way of achieving this. I was reading about KV store which might be able to give desired result.

Can I can use KV store or CSV lookup to test this? How this is achievable?

Thanks
Hemendra

Re: Record extract based on data value: KV Store/CSV

alemarzu — Mon, 21 Mar 2016 12:46:03 GMT

Hi there, try this.

your_search | outputcsv yourfilename.CSV

Get your file on $SPLUNK_HOME/var/run/splunk
Hope it helps.

Re: Record extract based on data value: KV Store/CSV

hemendralodhi — Mon, 21 Mar 2016 23:33:07 GMT

Hello,

Thanks for your response. I will check on this.

Another qq: Will search on KV Store/CSV store field data will output complete row?

Thanks
Hemendra

Re: Record extract based on data value: KV Store/CSV

alemarzu — Tue, 22 Mar 2016 18:28:55 GMT

Can tell if it works with the complete _raw data, but I believe its possible.