Splunk Search

Is this the best way to add up all numbers in a given field?

johanupwork
New Member

If I want to add up all numbers I have in the nr_external_recipients field for a particular event type, is this the best way of doing it?

action=email_confirmed | table nr_external_recipients | addcoltotals nr_external_recipients | stats max(nr_external_recipients)

Example event of the type that I want to add up are (this example should show 5):
"action=email_confirmed nr_external_recipients=2"
"action=email_confirmed nr_external_recipients=3"

Tags (2)
0 Karma

sundareshr
Legend

If you want the total as a seperate line/event addcoltotals is your best option. If you're only looking for the total, then you can do stats sum(nr_external_recipients) as total

0 Karma
Get Updates on the Splunk Community!

More Ways To Control Your Costs With Archived Metrics | Register for Tech Talk

Tuesday, May 14, 2024  |  11AM PT / 2PM ET Register to Attend Join us for this Tech Talk and learn how to ...

.conf24 | Personalize your .conf experience with Learning Paths!

Personalize your .conf24 Experience Learning paths allow you to level up your skill sets and dive deeper ...

Threat Hunting Unlocked: How to Uplevel Your Threat Hunting With the PEAK Framework ...

WATCH NOWAs AI starts tackling low level alerts, it's more critical than ever to uplevel your threat hunting ...