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
Career Survey
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.

Can’t make it to .conf25? Join us online!

Get Updates on the Splunk Community!

Calling All Security Pros: Ready to Race Through Boston?

Hey Splunkers, .conf25 is heading to Boston and we’re kicking things off with something bold, competitive, and ...

Beyond Detection: How Splunk and Cisco Integrated Security Platforms Transform ...

Financial services organizations face an impossible equation: maintain 99.9% uptime for mission-critical ...

Customer success is front and center at .conf25

Hi Splunkers, If you are not able to be at .conf25 in person, you can still learn about all the latest news ...