Splunk Search

How to write regex to extract value in between two phrases?

syazwani
Path Finder

Hi, I need help to extract a value from field named "message".

Field "message" value is as below:

The process C:\Windows\system32\winlogon.exe (PRD01) has initiated the power off of computer PC01 on behalf of user ADMIN JABATAN for the following reason: No title for this reason could be found

The process C:\Windows\system32\shutdown.exe (PRD01) has initiated the restart of computer PC01 on behalf of user ADMIN\SUPPORT for the following reason: No title for this reason could be found

The process C:\Windows\system32\shutdown.exe (PRD01) has initiated the restart of computer PC01 on behalf of user admin for the following reason: No title for this reason could be found

The value i want to extract is:

newField
ADMIN JABATAN
ADMIN\SUPPORT
admin

 

Please assist. Thanks.

Labels (3)
0 Karma
1 Solution

batabay
Path Finder

Hi,

 

your search 

| rex field=message "of\suser\s(?<new_user>.+?)\sfor\sthe"

this command extract new_user field.

View solution in original post

syazwani
Path Finder

Hi @batabay, thank you for the response. It works!

0 Karma

batabay
Path Finder

Hi,

 

your search 

| rex field=message "of\suser\s(?<new_user>.+?)\sfor\sthe"

this command extract new_user field.

Get Updates on the Splunk Community!

Upcoming Webinar: Unmasking Insider Threats with Slunk Enterprise Security’s UEBA

Join us on Wed, Dec 10. at 10AM PST / 1PM EST for a live webinar and demo with Splunk experts! Discover how ...

.conf25 technical session recap of Observability for Gen AI: Monitoring LLM ...

If you’re unfamiliar, .conf is Splunk’s premier event where the Splunk community, customers, partners, and ...

A Season of Skills: New Splunk Courses to Light Up Your Learning Journey

There’s something special about this time of year—maybe it’s the glow of the holidays, maybe it’s the ...