Splunk Search

Simple regex

clymbouris
Path Finder

I'm just trying to get the CN name from what looks like the fields below
CN=John Smith,OU=Customer Service,OU=Users,OU=UK,DC=COMPANY,DC=LOCAL
CN=John Jr. Smith,OU=VIPs,OU=UK,DC=COMPANY,DC=LOCAL

I tried this

rex field=Name "CN=(?<Name>*),OU=" 

but didn't work out cause it kind of matches the last OU= instead of the first..

Tags (1)
0 Karma
1 Solution

alacercogitatus
SplunkTrust
SplunkTrust

I think a slightly more accurate regex would be CN=(?<cn>[^,]*), as this will capture any CNs within a CN, and not just OUs. It will also capture any CNs that have an O or U in them.

View solution in original post

alacercogitatus
SplunkTrust
SplunkTrust

I think a slightly more accurate regex would be CN=(?<cn>[^,]*), as this will capture any CNs within a CN, and not just OUs. It will also capture any CNs that have an O or U in them.

sbrant_splunk
Splunk Employee
Splunk Employee

try this one:

CN=(?<Name>[^OU]*),OU
Get Updates on the Splunk Community!

New Year. New Skills. New Course Releases from Splunk Education

A new year often inspires reflection—and reinvention. Whether your goals include strengthening your security ...

Splunk and TLS: It doesn't have to be too hard

Overview Creating a TLS cert for Splunk usage is pretty much standard openssl.  To make life better, use an ...

Faster Insights with AI, Streamlined Cloud-Native Operations, and More New Lantern ...

Splunk Lantern is a Splunk customer success center that provides practical guidance from Splunk experts on key ...