Splunk Search

Why is my transaction search grouping two start events together and no end?

brianlee12
Engager

Hi,

I am trying to create transactions that begin with a start event and end with an end event, so I can find events that only have a start event and no end. My current search is:

... | transaction maxspan=1d keeporphans=true maxevents=2 deviceID startswith(type="start") endswith(type="end")

However, Splunk keeps grouping together two start events when it can't find an end. For example, if the event log looks like ......start.......start..........end....... I want it to group the 2nd start and end together and leave the first start as an orphan but splunk groups the two starts together despite my startswith and endswith condition. Any help would be greatly appreciated! Thanks!

0 Karma
1 Solution

sundareshr
Legend

Try this

| transaction keepevicted=t deviceID startswith="start" endswith="end" | 

View solution in original post

sundareshr
Legend

Try this

| transaction keepevicted=t deviceID startswith="start" endswith="end" | 

brianlee12
Engager

Switching from startswith(type="start") endswith(type="end") to startswith="start" endswith="end" worked for me but could you explain why? I parse the type before the transaction so I don't see how this should affect it.

0 Karma
Get Updates on the Splunk Community!

Archived Metrics Now Available for APAC and EMEA realms

We’re excited to announce the launch of Archived Metrics in Splunk Infrastructure Monitoring for our customers ...

Detecting Remote Code Executions With the Splunk Threat Research Team

WATCH NOWRemote code execution (RCE) vulnerabilities pose a significant risk to organizations. If exploited, ...

Enter the Dashboard Challenge and Watch the .conf24 Global Broadcast!

The Splunk Community Dashboard Challenge is still happening, and it's not too late to enter for the week of ...