Record extract based on data value: KV Store/CSV

[hemendralodhi]

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

[alemarzu]

Hi there, try this.

your_search | outputcsv yourfilename.CSV

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

[hemendralodhi]

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

[alemarzu]

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