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!

Application management with Targeted Application Install for Victoria Experience

  Experience a new era of flexibility in managing your Splunk Cloud Platform apps! With Targeted Application ...

Index This | What goes up and never comes down?

January 2026 Edition  Hayyy Splunk Education Enthusiasts and the Eternally Curious!   We’re back with this ...

Splunkers, Pack Your Bags: Why Cisco Live EMEA is Your Next Big Destination

The Power of Two: Splunk + Cisco at "Ludicrous Scale"   You know Splunk. You know Cisco. But have you seen ...