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!

Index This | Why did the turkey cross the road?

November 2025 Edition  Hayyy Splunk Education Enthusiasts and the Eternally Curious!   We’re back with this ...

Enter the Agentic Era with Splunk AI Assistant for SPL 1.4

  &#x1f680; Your data just got a serious AI upgrade — are you ready? Say hello to the Agentic Era with the ...

Feel the Splunk Love: Real Stories from Real Customers

Hello Splunk Community,    What’s the best part of hearing how our customers use Splunk? Easy: the positive ...