Splunk Search

How to extract a field from the text

Hema_Nithya
Explorer

Dec 2 09:02:17 server1 sudo: ib12345 : TTY=pts/0 ; PWD=/home/ib12345 ; USER=root ; COMMAND=/bin/su -

 

I need to extract ib12345 from the above data .

Labels (2)
Tags (2)
0 Karma

Hema_Nithya
Explorer

sudo: ib12345 

Value ib12345 will change not constant . It is upi . 

0 Karma

gcusello
SplunkTrust
SplunkTrust

Hi @Hema_Nithya ,

please try this:

! rex "sudo:\s+(?<field>[^ ]+)"

that you can test at https://regex101.com/r/uBkpRh/1

Ciao.

Giuseppe

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

Assuming your spacing in your example is consistent with your events, then this should work

| rex "sudo:\s(?<field>\S+)\s"
0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

This string appears twice, which one do you want to extract - in order for rex to find the right string, you need to define the pattern of characters around (either before, after or both) - unless you always want ib12345, in which case, this should work

| rex "(?<field>ib12345)"
0 Karma
Get Updates on the Splunk Community!

Prove Your Splunk Prowess at .conf25—No Prereqs Required!

Your Next Big Security Credential: No Prerequisites Needed We know you’ve got the skills, and now, earning the ...

Splunk Observability Cloud's AI Assistant in Action Series: Observability as Code

This is the sixth post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how to ...

Splunk Answers Content Calendar, July Edition I

Hello Community! Welcome to another month of Community Content Calendar series! For the month of July, we will ...