Splunk Search

Update kvstore based on recalculated metrics?

sgtlongwell
New Member

I have a kvstore like below populated with about 1mil rows. 

_key name count1 count2 calculated_number1 calculated_number2
sha256 hash Joe Cool  1 2 3 4

 

How can I update the kvstore where I update the two counts and recalculate the two calculated numbers based on the newly updated counts? I am trying not to read in all 1 million rows and overwrite if I dont have to. 

Any potential pathways are welcome and I am here to learn. Thank you all. 

 

Labels (3)
Tags (1)
0 Karma

bowesmana
SplunkTrust
SplunkTrust

With a kvstore, outputlookup command will replace the existing entry as long as you supply the original _key variable - it will not overwrite other rows if you use append=t, see example 6 here

https://docs.splunk.com/Documentation/Splunk/8.2.7/SearchReference/Outputlookup#Examples

 

0 Karma
Get Updates on the Splunk Community!

Index This | When is October more than just the tenth month?

October 2025 Edition  Hayyy Splunk Education Enthusiasts and the Eternally Curious!   We’re back with this ...

Observe and Secure All Apps with Splunk

  Join Us for Our Next Tech Talk: Observe and Secure All Apps with SplunkAs organizations continue to innovate ...

What’s New & Next in Splunk SOAR

 Security teams today are dealing with more alerts, more tools, and more pressure than ever.  Join us for an ...