Splunk Search

How to sum two fields ?

aymericbrun
Explorer

Hello,

How can i sum fields to have the total in a new field ?
For example, i have a field called (BytesReceivedPerSec) and i would have the sum of this field for all the event (in realtime)

I tried accum BytesReceivedPersec AS bytesrcvdtotal but i doesn't do a total sum of all the bytes received.

Have you an idea ?

Thanks

Tags (1)
0 Karma
1 Solution

Ant1D
Motivator

Try the following search:

index=Your_Index | stats sum(BytesReceivedPerSec) AS bytes_total

View solution in original post

0 Karma

aymericbrun
Explorer

Thank you very much 🙂

It works perfectly

my search exactly :

host=hp-dev index="main"| stats sum(BytesReceivedPersec) AS octets_recus sum(BytesSentPersec) AS octets_envoyes | eval octets_recus_Mo=octets_recus / 1000000 | eval octets_envoyes_Mo=octets_envoyes / 1000000

0 Karma

Ant1D
Motivator

Glad to help 🙂

0 Karma

Ant1D
Motivator

Try the following search:

index=Your_Index | stats sum(BytesReceivedPerSec) AS bytes_total

0 Karma
Get Updates on the Splunk Community!

New Year, New Changes for Splunk Certifications

As we embrace a new year, we’re making a small but important update to the Splunk Certification ...

Stay Connected: Your Guide to January Tech Talks, Office Hours, and Webinars!

What are Community Office Hours? Community Office Hours is an interactive 60-minute Zoom series where ...

[Puzzles] Solve, Learn, Repeat: Reprocessing XML into Fixed-Length Events

This challenge was first posted on Slack #puzzles channelFor a previous puzzle, I needed a set of fixed-length ...