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

SOC4Kafka - New Kafka Connector Powered by OpenTelemetry

The new SOC4Kafka connector, built on OpenTelemetry, enables the collection of Kafka messages and forwards ...

Event Series: Level up your SOC: Advancing with Splunk Enterprise Security

AI has fundamentally raised the stakes for security operations, and this three-part series is your guide to ...

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