Splunk Search

field extraction

ranjithan
Path Finder

name uuid sysfs size dm-st paths failures action path_faults vend prod rev

mpatha 360002ac000000000000010e30001c751 dm-1 120G active 4 0 0 3PARdata VV 3315

mpathb 360002ac000000000000010fb0001c751 dm-0 240G active 4 0 0 3PARdata VV 3315

 

The above is my multiline event in table format...

I need to extract the below values(mpath, uuid):

mpatha 360002ac000000000000010e30001c751

mpathb 360002ac000000000000010fb0001c751

Please help me. im new to this.. thank you so much..

Labels (1)
0 Karma
1 Solution

gcusello
SplunkTrust
SplunkTrust

Hi @ranjithan,

please try this regex

| rex "^(?<name>\w+)\s+(?<uuid>[^ ]+)"

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

Ciao.

Giuseppe

View solution in original post

gcusello
SplunkTrust
SplunkTrust

Hi @ranjithan,

please try this regex

| rex "^(?<name>\w+)\s+(?<uuid>[^ ]+)"

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

Ciao.

Giuseppe

ranjithan
Path Finder

thank you so much! 

0 Karma

gcusello
SplunkTrust
SplunkTrust

Hi @ranjithan,

good for you, see next time!

Ciao and happy splunking.

Giuseppe

P.S.: Karma Points are appreciated 😉

0 Karma
Get Updates on the Splunk Community!

Get ready to show some Splunk Certification swagger at .conf24!

Dive into the deep end of data by earning a Splunk Certification at .conf24. We're enticing you again this ...

Built-in Service Level Objectives Management to Bridge the Gap Between Service & ...

Now On-Demand Join us to learn more about how you can leverage Service Level Objectives (SLOs) and the new ...

Database Performance Sidebar Panel Now on APM Database Query Performance & Service ...

We’ve streamlined the troubleshooting experience for database-related service issues by adding a database ...