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!

Troubleshooting the OpenTelemetry Collector

  In this tech talk, you’ll learn how to troubleshoot the OpenTelemetry collector - from checking the ...

Adoption of Infrastructure Monitoring at Splunk

  Splunk's Growth Engineering team showcases one of their first Splunk product adoption-Splunk Infrastructure ...

Modern way of developing distributed application using OTel

Recently, I had the opportunity to work on a complex microservice using Spring boot and Quarkus to develop a ...