Splunk Search

How do display only the total row ?

rsathish47
Contributor

Hi all,

I would like to diplay only the row please help

ser Captured Processe Co1 col3 col4 .. .. ..
Serv01 482 84107
Serv02 497 84162
Serv03 482 84150
Serv04 457 84087
Serv05 500 84175
Serv06 494 84206
Total 2912 504887 .. . . .. . . . ..

I need

ser Captured Processe Co11 col13 col14 .. .. ..
Total 2912 504887 .. . . .. .. . .

Tags (1)
0 Karma
1 Solution

aweitzman
Motivator

Filter search result rows using where:

...your search... | where ser="Total"

View solution in original post

martin_mueller
SplunkTrust
SplunkTrust

Consider replacing ... | addcoltotals with ... | stats sum(*) as *.

rsathish47
Contributor

Thank You Martin it also works

0 Karma

aweitzman
Motivator

Filter search result rows using where:

...your search... | where ser="Total"

rsathish47
Contributor

Thanks aweitzman .. It works

0 Karma

bgaignon
Path Finder

Hi,
Not sure to understand your table.
Is this from your logs or the result of a search?

If it's a result of a search, try:

Your search | fields + Total

'Total' is the name of the field you want to display.

0 Karma

rsathish47
Contributor

Total is not a field. it added by addtolcol command.

I need to display column names row and total row

0 Karma
Get Updates on the Splunk Community!

Congratulations to the 2025-2026 SplunkTrust!

Hello, Splunk Community! We are beyond thrilled to announce our newest group of SplunkTrust members!  The ...

[Puzzles] Solve, Learn, Repeat: Nested loops in Event Conversion

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

Your Guide to Splunk Digital Experience Monitoring

A flawless digital experience isn't just an advantage, it's key to customer loyalty and business success. But ...