Getting Data In

Record extract based on data value: KV Store/CSV

Contributor

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

0 Karma

Motivator

Hi there, try this.

your_search | outputcsv yourfilename.CSV

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

0 Karma

Contributor

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

0 Karma

Motivator

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

0 Karma
State of Splunk Careers

Access the Splunk Careers Report to see real data that shows how Splunk mastery increases your value and job satisfaction.

Find out what your skills are worth!