Splunk Search

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

jason_hotchkiss
Communicator

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
0 Karma

jason_hotchkiss
Communicator

Thank you!!  This worked for me.

0 Karma
Get Updates on the Splunk Community!

Prove Your Splunk Prowess at .conf25—No Prereqs Required!

Your Next Big Security Credential: No Prerequisites Needed We know you’ve got the skills, and now, earning the ...

Splunk Observability Cloud's AI Assistant in Action Series: Observability as Code

This is the sixth post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how to ...

Splunk Answers Content Calendar, July Edition I

Hello Community! Welcome to another month of Community Content Calendar series! For the month of July, we will ...