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
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Agent Mode Engaged! Enchaining Agentic Operations with Splunk AI Assistant 2.0

    Are you ready to transform how your team handles complex data requests? We invite you to our upcoming ...

Announcing Modern Navigation: A New Era of Splunk User Experience

We are excited to introduce the Modern Navigation feature in the Splunk Platform, available to both cloud and ...

Modernize your Splunk Apps – Introducing Python 3.13 in Splunk

We are excited to announce that the upcoming releases of Splunk Enterprise 10.2.x and Splunk Cloud Platform ...