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!

Splunk Observability Cloud's AI Assistant in Action Series: Auditing Compliance and ...

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

Splunk Community Badges!

  Hey everyone! Ready to earn some serious bragging rights in the community? Along with our existing badges ...

What You Read The Most: Splunk Lantern’s Most Popular Articles!

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...