Splunk Search

Transaction not showing some events in table format

jinal24
New Member

I am using Transaction command to group events in one line and want to see this in a table format. Have the "order_number" as a unique identifier. All of the events related to the ordernumber are written at the same time except conformation info. For some reason conformation information is getting dropped. Is it because conformation doesn't occur till way past 1000 events and is there a way around it?

index=client1 (item=giftcard OR info=billing OR info=purchase_detail OR info=confirmation) | transaction Order_number keepevicted=true | where isnotnull(category)| table order_number, date, paytype, method, ip, confirmation_name

Tags (1)
0 Karma

mcmaster
Communicator

From the docs for the transaction command (http://docs.splunk.com/Documentation/Splunk/latest/SearchReference/Transaction):

maxevents=<int>
Description: The maximum number of events in a transaction. If the value is negative this constraint is disabled. By default, maxevents=1000.

So try adding maxevents=10000 to your transaction command. Not sure what impact this has on performance though.

0 Karma
Get Updates on the Splunk Community!

Tech Talk Recap | Mastering Threat Hunting

Mastering Threat HuntingDive into the world of threat hunting, exploring the key differences between ...

Observability for AI Applications: Troubleshooting Latency

If you’re working with proprietary company data, you’re probably going to have a locally hosted LLM or many ...

Splunk AI Assistant for SPL vs. ChatGPT: Which One is Better?

In the age of AI, every tool promises to make our lives easier. From summarizing content to writing code, ...