Reporting

loadjob limits 1000lines

crazyeva
Contributor

hello
i am trying to load events from a saved search which contains 10000+ events
|load pid events=t
but this only return 1000 rows
how could i break the limitation?
thanks

Tags (2)

mrgibbon
Contributor

Same issue here.... 18,000 events, only 1,000 returned using loadjob.

0 Karma

tfletcher_splun
Splunk Employee
Splunk Employee

If you append a table command with the field list you are interested in it may work around your issue.

0 Karma

crazyeva
Contributor

To verify your suggestion, I tried this but can not repeat my issue again.

|loadjob SID events=t

It returned more than 1000 events. Splunk version 6.4
I forgot why I used "load" and "pid", and what I searched 3 years ago.
Any one have the same issue, could you plz post your search conditions?

0 Karma

tfletcher_splun
Splunk Employee
Splunk Employee

The issue was likely fixed in a more recent version of splunk. The table command was just a workaround because it transforms event data into results data and thus worked around the bug in loading all of the events data.

0 Karma

nickbloglovin
Engager

has anyone figured this out since 2013?

0 Karma

obhatti
Explorer

Hi,

Was this question answered? I am looking at a similar problem.

Thanks

kranzrm
Path Finder

Same problem, even with DalJeanis's suggestion... Any fix?

0 Karma

DalJeanis
Legend

|loadjob SID events=t

0 Karma

cdstealer
Contributor

Hi Eva,
I'm having the same issue. Did you get this resolved?

Steve

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!

SOK it to Me: Top 3 Benefits of Using Splunk Operator on Kubernetes that’ll Make ...

    Thursday, July 9, 2026  |  11:00AM–12:00PM PDT Duration: 1 hour (includes Q&A) Managing can feel like a ...

Upgrade Prep for 10.4, Network Observability Deep Dives, and More from Splunk Lantern

Splunk Lantern is Splunk’s customer success center that provides practical guidance from Splunk experts on key ...

Splunk Developer Day announcements: AI agents, MCP tools, Forecasting, and Custom ...

Splunk Developer Day was packed with product and platform updates for developers building in the AI ...