So... after much stuffing about, I was informed about the 10k return limitation of subsearches.
As our NOT search was returning more then 10K, the overflow was impacting our final results.
But - I found this, but provided the solution to my issues:
https://answers.splunk.com/answers/207150/how-to-overcome-sub-search-limitation-only-10k-rec.html
I just came across this gem via a
co-worker. do:
dedup Order_Number
|search NOT [
| inputlookup Order_Details_Lookup.csv
| stats values(Order_Number) AS Order_Number]
| table Order_Number
That will make the subsearch return a
single row with a multi-value field
containing all of the order numbers
but the individual values will get
passed along correctly into the base
search.
... View more