Splunk Search

Putting count first in top results

willthames
Path Finder

I would like count to be the first field when I use top, rather than the last (one of my fields is very long and so count scrolls off the right hand side)

I've tried

sourcetype="server" | top limit=10 count, status, message

But that reports a clash in name between input and output field

Error in 'top' command: The output count field conflicts with the input field 'count'. Use the 'countfield' option to specify a different name.

If I try

sourcetype="server" | top limit=10 countfield=countxz countxz, status, message

I get the same message.

Tags (1)

gkanapathy
Splunk Employee
Splunk Employee
sourcetype="server" | top limit=10 countfield=countxz count, status, message
0 Karma

carasso
Splunk Employee
Splunk Employee

i can't tell if the question is the result of him having a field called "count" as you think, or whether he just wants the "count" field to be the first field. "top" returns fields as ", count, percent"

0 Karma

carasso
Splunk Employee
Splunk Employee
sourcetype="server" | top 10 status message | fields count, percent, status, message
0 Karma
Get Updates on the Splunk Community!

OpenTelemetry for Legacy Apps? Yes, You Can!

This article is a follow-up to my previous article posted on the OpenTelemetry Blog, "Your Critical Legacy App ...

UCC Framework: Discover Developer Toolkit for Building Technology Add-ons

The Next-Gen Toolkit for Splunk Technology Add-on Development The Universal Configuration Console (UCC) ...

.conf25 Community Recap

Hello Splunkers, And just like that, .conf25 is in the books! What an incredible few days — full of learning, ...