Splunk Search

How to extract the user and move it to a field in Splunk?

LearningGuy
Motivator

How to extract the following user and move it to a field in Splunk?
message: xad="/home/andy"
message: xad="/home/george"
message: xad="/home/cindy"
and a lot more..
I would like to get an output as follows.    Because of the quote " before /home, Splunk rejected my regex. Please help. Thanks
user  
====    
andy
george
cindy

Labels (4)
0 Karma

yuanliu
SplunkTrust
SplunkTrust

You obviously has a field named xad.  From this, no need for rex.

| eval user = mvindex(split(xad, "/"), 1)
Tags (1)
0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

I think @yuanliu meant

| eval user = mvindex(split(xad, "/"), 2)

Having said that, can you share the failed rex and/or the full events (anonymised, of course) in a code block </> to preserve the format of the event?

0 Karma
Get Updates on the Splunk Community!

Splunk Mobile: Your Brand-New Home Screen

Meet Your New Mobile Hub  Hello Splunk Community!  Staying connected to your data—no matter where you are—is ...

Introducing Value Insights (Beta): Understand the Business Impact your organization ...

Real progress on your strategic priorities starts with knowing the business outcomes your teams are delivering ...

Enterprise Security (ES) Essentials 8.3 is Now GA — Smarter Detections, Faster ...

As of today, Enterprise Security (ES) Essentials 8.3 is now generally available, helping SOC teams simplify ...