Splunk Search

Dispatch limited to 10000 when outputting a CSV via Python

BrendanMcE
Path Finder

If dispatch is used via Python rather than any saved search for a query and that query uses outputcsv the results are limited to 10000 rows. The query includes a stats section.

How can the number of rows output from dispatch be increased in the CSV without effecting the GUI.

Tags (2)
1 Solution

sumnerm
Path Finder

If you're dispatching directly through Python, there should be no limits, however there may be hidden limits depending on the search terms used.

Have a look at your search query string and see if it contains any terms which may contain any limits - for example is you pipe to sort this will be default be limited to 10000 rows regardless of how the search is run (the behaviour can then be changed within the query).

View solution in original post

0 Karma

sumnerm
Path Finder

If you're dispatching directly through Python, there should be no limits, however there may be hidden limits depending on the search terms used.

Have a look at your search query string and see if it contains any terms which may contain any limits - for example is you pipe to sort this will be default be limited to 10000 rows regardless of how the search is run (the behaviour can then be changed within the query).

0 Karma
Career Survey
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.

Can’t make it to .conf25? Join us online!

Get Updates on the Splunk Community!

Can’t Make It to Boston? Stream .conf25 and Learn with Haya Husain

Boston may be buzzing this September with Splunk University and .conf25, but you don’t have to pack a bag to ...

Splunk Lantern’s Guide to The Most Popular .conf25 Sessions

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

Unlock What’s Next: The Splunk Cloud Platform at .conf25

In just a few days, Boston will be buzzing as the Splunk team and thousands of community members come together ...