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
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Deep Dive: Accelerate threat investigation with Splunk’s AI Assistant in Security

AI is one of the biggest topics in the market today, and for security teams, its value goes far beyond the ...

Announcing Modern Navigation: A New Era of Splunk User Experience

We are excited to introduce the Modern Navigation feature in the Splunk Platform, available to both cloud and ...

Detection Engineering Office Hours: Real-World Troubleshooting & Q&A

[REGISTER HERE] This thread is for the Community Office Hours session on Detection Engineering Office Hours: ...