Why are the same queries getting different result?

[indeed_2000]

Hi

I have exactly two SPL, same date range, one with "tracnsaction" command another wirhout it.

as you see in picture without transaction timechart show correctly but with transaction last part missed!

FYI: 1-I've check log file correctly indexed and available.

2-pair of eachtransaction availabe in log in  missing part.

what happen here? any idea?

Thanks

[ITWhisperer · Accepted solution]

transaction is limited to the number of open transactions it processes (see limits.conf) - you can override this with maxopentxns - this defaults to 5000 (hence only 4999 events). For example:

| transaction correlationfield maxopentxn=10000

[gcusello]

Hi @indeed_2000,

if you don't share your search and results I can only suppose something!

Anyway I think that the problem is that the transpose command uses as timestamp the first timestamp of the correlated events and probably all the events after 12.00 PM are in other grouped events.

But As I said it's difficoult withou  viewing your events.

To be sure, see if in the grouped events there are evevnts after 12.00 PM.

Ciao.

Giuseppe