Splunk Search

Extract the fields user and service account

Hema_Nithya
Explorer
Dec 2 08:46:55 server1 sudo[3461907]: ib12345 : TTY=pts/0 ; PWD=/home/ib12345 ; USER=root ; COMMAND=/bin/su - webadmin
 
I would like to extract the upi  from above ib12345

upi  ib12345
service_account webadmin 
 
Sometime after is empty COMMAND=/bin/su - 
Labels (2)
Tags (2)
0 Karma

Hema_Nithya
Explorer

I tried this working 

| rex "COMMAND=\/[a-z]*\/[a-z]*\s-\s(?<service_account>[^ ]+)"
0 Karma

Hema_Nithya
Explorer

Hi Thanks 

I also want to extract another field from the below  data "webadmin" as service_Account COMMAND=/bin/su - webadmin

Dec 2 08:46:55 server1 sudo[3461907]: ib12345 : TTY=pts/0 ; PWD=/home/ib12345 ; USER=root ; COMMAND=/bin/su - webadmin

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

Assuming your spacing is as shown in your example:

| rex "sudo\s*?:\s(?<upi>\S+)\s"
0 Karma
Career Survey
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.
Get Updates on the Splunk Community!

Tech Talk Recap | Mastering Threat Hunting

Mastering Threat HuntingDive into the world of threat hunting, exploring the key differences between ...

Observability for AI Applications: Troubleshooting Latency

If you’re working with proprietary company data, you’re probably going to have a locally hosted LLM or many ...

Splunk AI Assistant for SPL vs. ChatGPT: Which One is Better?

In the age of AI, every tool promises to make our lives easier. From summarizing content to writing code, ...