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!

Announcing Scheduled Export GA for Dashboard Studio

We're excited to announce the general availability of Scheduled Export for Dashboard Studio. Starting in ...

Extending Observability Content to Splunk Cloud

Watch Now!   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to leverage ...

More Control Over Your Monitoring Costs with Archived Metrics GA in US-AWS!

What if there was a way you could keep all the metrics data you need while saving on storage costs?This is now ...