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

Get Updates on the Splunk Community!

Stay Connected: Your Guide to May Tech Talks, Office Hours, and Webinars!

Take a look below to explore our upcoming Community Office Hours, Tech Talks, and Webinars this month. This ...

They're back! Join the SplunkTrust and MVP at .conf24

With our highly anticipated annual conference, .conf, comes the fez-wearers you can trust! The SplunkTrust, as ...

Enterprise Security Content Update (ESCU) | New Releases

Last month, the Splunk Threat Research Team had two releases of new security content via the Enterprise ...