Splunk Search

Adding Field Values Generated by a |stats latest(fieldvalue) command

jason_hotchkiss
Path Finder

Hello -

 

I have the following search:

<base search>
| fields host registrations
| stats latest(registrations) by host

This produces the following table:

host       latest(registrations)
Pc1        51

Pc2        29

Pc3        18

How would I add the values of latest(registrations) to provide a single value for all 3 hosts?  For example, I would like only the sum of the latest registrations (98) to display in a single value panel.

 

Thank you!

Labels (3)
0 Karma
1 Solution

ITWhisperer
SplunkTrust
SplunkTrust
<base search>
| fields host registrations
| stats latest(registrations) as latest_reg by host
| stats sum(latest_reg) as total_latest_reg

View solution in original post

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust
<base search>
| fields host registrations
| stats latest(registrations) as latest_reg by host
| stats sum(latest_reg) as total_latest_reg

View solution in original post

0 Karma

jason_hotchkiss
Path Finder

Thank you!!  This worked for me.

0 Karma
Did you miss .conf21 Virtual?

Good news! The event's keynotes and many of its breakout sessions are now available online, and still totally FREE!