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!

.conf24 | Registration Open!

Hello, hello! I come bearing good news: Registration for .conf24 is now open!   conf is Splunk’s rad annual ...

ICYMI - Check out the latest releases of Splunk Edge Processor

Splunk is pleased to announce the latest enhancements to Splunk Edge Processor.  HEC Receiver authorization ...

Introducing the 2024 SplunkTrust!

Hello, Splunk Community! We are beyond thrilled to announce our newest group of SplunkTrust members!  The ...