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!

Index This | What travels the world but is also stuck in place?

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

Discover New Use Cases: Unlock Greater Value from Your Existing Splunk Data

Realizing the full potential of your Splunk investment requires more than just understanding current usage; it ...

Continue Your Journey: Join Session 2 of the Data Management and Federation Bootcamp ...

As data volumes continue to grow and environments become more distributed, managing and optimizing data ...