Splunk Search

Transaction Events Issue

jberlin
Path Finder

My search is partially working in the aspect that it returns event data, however all of the events are mashed into one and the duration is calculated off the first event and the last event.

Search Command:
(index=jjj host=server OR host=server2 (inbound OR outbound)) | xmlkv | table _time, host, TokenId, inbound, outbound, _raw | transaction TokenId | search TokenId="$tokenId$"

I would like to the returned data to show each event as they occur or inbound event and outbound event for 1 duration time. Then move on to the next event and so on.

jb

Tags (1)
0 Karma
1 Solution

jberlin
Path Finder

Adding maxspan and maxpause to the transaction resolved the problem.

View solution in original post

0 Karma

jberlin
Path Finder

Adding maxspan and maxpause to the transaction resolved the problem.

0 Karma

lguinn2
Legend

Don't use the transaction command, then. It might also be helpful if you explained your data a little more. What do you mean "for 1 duration time"? What exactly do you want the output to look like?

In the meantime, I suggest this:

(index=jjj host=server OR host=server2 (inbound OR outbound)) "$tokenId$" 
| xmlkv 
| search TokenId="$tokenId$"
| table  _time, host, TokenId, inbound, outbound, _raw 
0 Karma
Get Updates on the Splunk Community!

Best Strategies to Optimize Observability Costs

 Join us on Tuesday, May 6, 2025, at 11 AM PDT / 2 PM EDT for an insightful session on optimizing ...

Fueling your curiosity with new Splunk ILT and eLearning courses

At Splunk Education, we’re driven by curiosity—both ours and yours! That’s why we’re committed to delivering ...

Splunk AI Assistant for SPL 1.1.0 | Now Personalized to Your Environment for Greater ...

Splunk AI Assistant for SPL has transformed how users interact with Splunk, making it easier than ever to ...