Splunk Search

How do I extract the latest occurrence of a field from multiple lines?

nkchaitanya
Explorer

Want to capture the latest occurrence of "working_condition_check - status -" which is "Stopped".

Please help me in getting the regex.

Below is the log message.

10/01/2018 15:01:04 Server_Name
working_condition_check - status - Started
working_condition_check - status - Running
working_condition_check - status - Stopped

0 Karma

harishalipaka
Motivator

hi @nkchaitanya

As @493669 answer follow that end of your query add this

| makeresults |eval hari="working_condition_check - status - Stopped" |rex field=hari ".*status - (?<status>\w+)" |where status="Stopped"
Thanks
Harish
0 Karma

493669
Super Champion

Hi @nkchaitanya,
Try this:

...|rex ".*status - (?<status>\w+)"
0 Karma
Get Updates on the Splunk Community!

Introduction to Splunk Observability Cloud - Building a Resilient Hybrid Cloud

Introduction to Splunk Observability Cloud - Building a Resilient Hybrid Cloud  In today’s fast-paced digital ...

Observability protocols to know about

Observability protocols define the specifications or formats for collecting, encoding, transporting, and ...

Take Your Breath Away with Splunk Risk-Based Alerting (RBA)

WATCH NOW!The Splunk Guide to Risk-Based Alerting is here to empower your SOC like never before. Join Haylee ...