topic Re: Alternative without transaction in Splunk Search

Alternative without transaction- Is it possible?

btcs2 — Thu, 16 Jun 2022 18:20:43 GMT

Is it possible to do this query with out using transaction

index="prod" source="mysource" | transaction startswith="create happening for test" endswith=("create done " OR "create not done " )|stats count

Re: Alternative without transaction

fredclown — Wed, 15 Jun 2022 19:52:41 GMT

What are you trying to accomplish without transaction? Is there a reason you do not want to use transaction?

Re: Alternative without transaction

gcusello — Thu, 16 Jun 2022 06:59:02 GMT

Hi @btcs2,

the startswith and endswith without a correlation key is the only condition where there isn't any other solution than transaction command.

if you have a unique correlation key, you could try to use stats, but without it isn't possible

Ciao.

Giuseppe

Re: Alternative without transaction

btcs2 — Thu, 16 Jun 2022 07:17:27 GMT

it take so much time to load .

Re: Alternative without transaction

ITWhisperer — Thu, 16 Jun 2022 07:35:17 GMT

You appear to be counting the "transactions" which begin with one string and end with one of two other strings. Depending on your data, can you just not count the occurrences of the first string? If necessary, make sure this count is not greater than the sum of the occurrences of the two other strings?

Re: Alternative without transaction

gcusello — Thu, 16 Jun 2022 07:35:39 GMT

Hi @btcs2,

this is the main reason because I try to avoid to use transaction comman all the times I can, but, as I said, if you haven't a key to correlate you events, transaction command is the only solution.

If possible, try to limit the maxtime for correlate events, this is the only workaround (when possible) to limit response time.

Ciao.

Giuseppe

Re: Alternative without transaction

btcs2 — Thu, 16 Jun 2022 10:22:34 GMT

There can be different combinations . I just need the events that have this particular combination.

Re: Alternative without transaction

ITWhisperer — Thu, 16 Jun 2022 11:11:18 GMT