Splunk Search

rex extraction user & module

indeed_2000
Motivator
Hi
Here is my log, what is the rex for extract "0000A0@#0000" and "mymodulename"
 
2021-07-14 23:59:05,185 INFO [APP] User: 0000A0@#0000 || module: mymodulename
 
any idea?
Thanks
 
Labels (3)
0 Karma
1 Solution

venkatasri
SplunkTrust
SplunkTrust

@indeed_2000 This one works for method. 

<your_search>
| rex "User\:\s+(?<user>\S+)\s+\|\|\s+method:\s+(?<method>\S+)$" 
| table user method

--

An upvote would be appreciated and accept solution if this reply helps!

View solution in original post

venkatasri
SplunkTrust
SplunkTrust

Hi @indeed_2000 

Can you try this?  

 

<your_search_goes_here> 
| rex "User\:\s+(?<user>\S+)\s\|\|\smodule\:\s+(?<module>.+)$" 
| table user module 

 

---

An upvote would be appreciated and Accept the solution if this reply helps!

 

Tags (1)
0 Karma

efika
Communicator

rex "User\:(?<user>.+)\s\|\|\smodule\:(?<module>.+)"

(field=_raw is added by default)

0 Karma

indeed_2000
Motivator

thank you for answer, it's not work on all user & module name (both might have capital word or special character)

e.g. 

2021-07-14 23:53:23,353 INFO [APP] User: A0000@#0000 || module: setNameDescription

2021-07-14 23:53:23,353 INFO [APP] User: A.Kay || module: setNameDescription

2021-07-14 23:53:23,353 INFO [APP] User: b_Kay || module: setNameDescription

 

any idea?

Thanks,

0 Karma

efika
Communicator

Not a problem. use:

 

rex "User\:(?<user>.+)\s\|\|\s(module\:(?<module>.+)|method\:(?<method>.+))"

0 Karma

indeed_2000
Motivator

sorry for miss spelling it is module I modify last reply.

and try this but not work

rex "User\:(?<user>.+)\s\|\|\s(module\:(?<module>.+)"

 

Any idea?

Thanks

 
 
0 Karma

venkatasri
SplunkTrust
SplunkTrust

@indeed_2000 What you have originally provided having different log structure. User: || module: 

These new logs having User: || method hence rex provided only works for module. Which one are correct events?

 

0 Karma

venkatasri
SplunkTrust
SplunkTrust

@indeed_2000 This one works for method. 

<your_search>
| rex "User\:\s+(?<user>\S+)\s+\|\|\s+method:\s+(?<method>\S+)$" 
| table user method

--

An upvote would be appreciated and accept solution if this reply helps!

indeed_2000
Motivator

it worked! thank you! 🙂

replace it with module

0 Karma
Get Updates on the Splunk Community!

Community Content Calendar, November Edition

Welcome to the November edition of our Community Spotlight! Each month, we dive into the Splunk Community to ...

October Community Champions: A Shoutout to Our Contributors!

As October comes to a close, we want to take a moment to celebrate the people who make the Splunk Community ...

Stay Connected: Your Guide to November Tech Talks, Office Hours, and Webinars!

What are Community Office Hours? Community Office Hours is an interactive 60-minute Zoom series where ...