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!

Splunk Observability Cloud's AI Assistant in Action Series: Auditing Compliance and ...

This is the third post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how to ...

Splunk Community Badges!

  Hey everyone! Ready to earn some serious bragging rights in the community? Along with our existing badges ...

What You Read The Most: Splunk Lantern’s Most Popular Articles!

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...