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!

.conf24 | Registration Open!

Hello, hello! I come bearing good news: Registration for .conf24 is now open!   conf is Splunk’s rad annual ...

ICYMI - Check out the latest releases of Splunk Edge Processor

Splunk is pleased to announce the latest enhancements to Splunk Edge Processor.  HEC Receiver authorization ...

Introducing the 2024 SplunkTrust!

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