Splunk Search

Error in "sort" command

abhayneilam
Contributor

I have a search in which I am sorting my data based on "Location" field:

my search | sort Location + desc

My result is having 13,000 lines but I am getting only 10,000 lines as my result along with some msg:

sort is trucating only 10,000 rows

Could you please let me know how to solve this "sort" problem so that it should take all the lines in my result

Please help

Thanks in Advance

Tags (4)
0 Karma
1 Solution

Ayn
Legend

That is no error. A quick look in the docs entry for the sort command (http://docs.splunk.com/Documentation/Splunk/5.0/SearchReference/sort ) would have given you this:

sort [<count>] (<sort-by-clause>)+ [desc] 

...

<count>
Syntax: <int> 
Description: Specify the number of results to sort. If no count is specified, the default limit of 10000 is used. If "0" is specified, all results will be returned. 

View solution in original post

Ayn
Legend

That is no error. A quick look in the docs entry for the sort command (http://docs.splunk.com/Documentation/Splunk/5.0/SearchReference/sort ) would have given you this:

sort [<count>] (<sort-by-clause>)+ [desc] 

...

<count>
Syntax: <int> 
Description: Specify the number of results to sort. If no count is specified, the default limit of 10000 is used. If "0" is specified, all results will be returned. 
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!

Index This | What has goals but no motivation?

June 2026 Edition  Hayyy Splunk Education Enthusiasts and the Eternally Curious!   We’re back with this ...

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 ...