Splunk Search

How to use rex command to extract this field from my sample log?

Abilan1
Path Finder

Hi ,

COSE#1017 Associated kernel not found. Please see Enterprise Server log for details: SocID:19041 PID:13695 BSFN:CustomShipConfirmWrapper user:AIAINBND

I want to create that highlighted term as a new event field. It may vary in length in following events. Could anyone help me?

Thanks

0 Karma
1 Solution

MuS
Legend

Hi Abilan1,

try something like this, which is based on your provided example:

your base search here | rex "\sBSFN:(?<myField>[^\s]*)" | table myField

cheers, MuS

View solution in original post

Richfez
SplunkTrust
SplunkTrust

If BSFN is a constant, which it appears to be, something as simple as

 ... | rex "BSFN:(?<GiveMeAName>\w+)"

That says

BSFN: Match the string "BSFN:" (including the colon)

(? Then extract a field named "GiveMeAName"

\w+ Which consists of one or more "word" type characters (letters)

) And finally close off this extraction.

Abilan1
Path Finder

Thank You rich!!! it worked

0 Karma

MuS
Legend

Hi Abilan1,

try something like this, which is based on your provided example:

your base search here | rex "\sBSFN:(?<myField>[^\s]*)" | table myField

cheers, MuS

Abilan1
Path Finder

Thank You MuS!!

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