Knowledge Management

Field Extraction help!!!

splunker9999
Path Finder

Hi,

I am newbie to splunk,We are looking to extract a field from below event format.

"PDR Message Listener Completed Processing Message"

From above , we need to extract a field after "PDR Message Listener" as field called status as "Completed", Can someone help extraction using Rex command.

we tried using field extrcation from events ,but it is giving us some false results.

Tags (1)
0 Karma
1 Solution

somesoni2
Revered Legend

If you always have "PDR Message Listener" before the status value you want to capture, try this

your base search | rex "PDR Message Listener Completed (?<status>\s+)"

If the string before status value is not constant but always 3 words, then try this

your base search | rex "^(\w+\s){3}(?<status>\s+)"

View solution in original post

0 Karma

somesoni2
Revered Legend

If you always have "PDR Message Listener" before the status value you want to capture, try this

your base search | rex "PDR Message Listener Completed (?<status>\s+)"

If the string before status value is not constant but always 3 words, then try this

your base search | rex "^(\w+\s){3}(?<status>\s+)"
0 Karma

vasildavid
Path Finder

I think the capture group should be (?<status>\w+) and not use \s+, right?

edit: formatting

0 Karma

MuS
SplunkTrust
SplunkTrust

or if you want to use \s then it should be "^(\w+\s){3}(?<status>[^\s]+)"

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 ...

Splunk Enterprise Security 8.x: The Essential Upgrade for Threat Detection, ...

Watch On Demand the Tech Talk, and empower your SOC to reach new heights! Duration: 1 hour  Prepare to ...

Splunk Observability as Code: From Zero to Dashboard

For the details on what Self-Service Observability and Observability as Code is, we have some awesome content ...