topic Why are the same queries getting different result? in Splunk Search

Why are the same queries getting different result?

indeed_2000 — Tue, 31 May 2022 14:08:16 GMT

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

Re: same query different result

gcusello — Tue, 31 May 2022 09:00:50 GMT

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

Re: same query different result

ITWhisperer — Tue, 31 May 2022 09:11:21 GMT

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