Splunk Search

How to get the first transaction after an event of a different kind occurs (e.g. service starts up)?

marnee
Explorer

I want to find the first transaction that occurs after a different type of event.

Let's say we have this event:

"Service ready"

Then we have these events:

traceId=123 "Authentication started"

traceId=123 "Authentication complete"

I want to find this transaction:

sourcetype=mytype

| transaction traceId startswith="Authentication started" endswith="Authentication complete"

But I want to filter these transaction and only see the first one that occurs after the "Service ready" event.

Labels (2)
0 Karma
Career Survey
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.
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, ...