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!

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

[Puzzles] Solve, Learn, Repeat: Character substitutions with Regular Expressions

This challenge was first posted on Slack #puzzles channelFor BORE at .conf23, we had a puzzle question which ...

Shape the Future of Splunk: Join the Product Research Lab!

Join the Splunk Product Research Lab and connect with us in the Slack channel #product-research-lab to get ...