Knowledge Management

How to update a KV store field?

guimilare
Communicator

Hello Splunkers.

I'm starting to work with KV store.
I used this exemple to practice: http://dev.splunk.com/view/SP-CAAAEZC

It's very interesting and is something I can use in my company with a little changes.
By the steps, we can ADD a row and DELETE a row.

How about updating a row?
I mean, I have the _key info, so I think that an update should be possible.
For example, a customer changed his address and I want to update his address field.

Can you guys help me?

Regards,
GMA

0 Karma
1 Solution

somesoni2
Revered Legend

See the information available here on how to update KV store data using lookup command. http://dev.splunk.com/view/SP-CAAAEZH#keyid

Look for 5th example under "Examples" section

| inputlookup csvcoll_lookup | search _key=544948df3ec32d7a4c1d9755 | eval CustName="Marge Simpson" | eval CustCity="Springfield" | outputlookup csvcoll_lookup append=True

View solution in original post

aaraneta_splunk
Splunk Employee
Splunk Employee

@guimilare - Did the answer provided by somesoni2 help provide a working solution to your question? If yes, please don't forget to resolve this post by clicking "Accept". If no, please leave a comment with more feedback. Thanks!

0 Karma

somesoni2
Revered Legend

See the information available here on how to update KV store data using lookup command. http://dev.splunk.com/view/SP-CAAAEZH#keyid

Look for 5th example under "Examples" section

| inputlookup csvcoll_lookup | search _key=544948df3ec32d7a4c1d9755 | eval CustName="Marge Simpson" | eval CustCity="Springfield" | outputlookup csvcoll_lookup append=True

JTS911
Explorer

Hi, 

Thanks 

0 Karma
Get Updates on the Splunk Community!

Splunk Observability as Code: From Zero to Dashboard

For the details on what Self-Service Observability and Observability as Code is, we have some awesome content ...

[Puzzles] Solve, Learn, Repeat: Character substitutions with Regular Expressions

This challenge was first posted on Slack #puzzles channelFor BORE at .conf23, we had a puzzle question which ...

Shape the Future of Splunk: Join the Product Research Lab!

Join the Splunk Product Research Lab and connect with us in the Slack channel #product-research-lab to get ...