Splunk Search

Correct Syntax for rex for a user

LizAndy123
Explorer

I have a simple search 

index=xxxxx "User ID" and I need the correct syntax to get the actual username in the results.

Sample Event

INFO xcvxcvxcvxcvxcvxcvxcvxcvxcvxcvvcx - Logged User ID-XXXXXX

Now I can easy do a count of how many people logged on but need to report on the XXXXXX

I thought about doing

index=xxxxx 'User ID" | rex field=_raw "User\/s\ID\/-\(?<username>\d+)" | stats count by username

The search is returning the results and just a count but I need to see the username in my stats.

I am new to this so please mind the ignorance 

Labels (1)
0 Karma
1 Solution

richgalloway
SplunkTrust
SplunkTrust

The regular expression in the rex command has some misplaced escape characters that are preventing matches.  Try this query

index=xxxxx 'User ID" 
| rex field=_raw "User\sID-(?<username>\w+)" 
| stats count by username

 

---
If this reply helps you, Karma would be appreciated.

View solution in original post

0 Karma

richgalloway
SplunkTrust
SplunkTrust

The regular expression in the rex command has some misplaced escape characters that are preventing matches.  Try this query

index=xxxxx 'User ID" 
| rex field=_raw "User\sID-(?<username>\w+)" 
| stats count by username

 

---
If this reply helps you, Karma would be appreciated.
0 Karma
Get Updates on the Splunk Community!

.conf24 | Day 0

Hello Splunk Community! My name is Chris, and I'm based in Canberra, Australia's capital, and I travelled for ...

Enhance Security Visibility with Splunk Enterprise Security 7.1 through Threat ...

(view in My Videos)Struggling with alert fatigue, lack of context, and prioritization around security ...

Troubleshooting the OpenTelemetry Collector

  In this tech talk, you’ll learn how to troubleshoot the OpenTelemetry collector - from checking the ...