Splunk Search

Find Transaction time with same startswith log string.

sethuk555
Engager

Hi,

I need to find the transaction time between these 2 statements which has same startswith Log strings(different endswith) and hence its ignoring the first event.

2014-07-04 09:48:00-System Up - Node1 is down
2014-07-04 09:43:00-System Up

How could I find the transaction time between these 2 events.

Tags (1)
0 Karma

somesoni2
Revered Legend

My suggestion would be to create a field called message which will store the message after "System Up -", so that it would be blank/null for 2nd event and you can use that as startswith (different in both entries).

something like this

Your base search | rex "System Up\s*-\s*(?<message>.*)$" | transaction startswith="System Up AND NOT message=*" endswith="System Up message=*"
0 Karma
Get Updates on the Splunk Community!

Splunk Observability for AI

Don’t miss out on an exciting Tech Talk on Splunk Observability for AI! Discover how Splunk’s agentic AI ...

[Puzzles] Solve, Learn, Repeat: Dereferencing XML to Fixed-length events

This challenge was first posted on Slack #puzzles channelFor a previous puzzle, I needed a set of fixed-length ...

Stay Connected: Your Guide to December Tech Talks, Office Hours, and Webinars!

What are Community Office Hours? Community Office Hours is an interactive 60-minute Zoom series where ...