This widget could not be displayed.
This widget could not be displayed.
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)
This widget could not be displayed.
0 Karma
This widget could not be displayed.
Reply
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

This widget could not be displayed.
This widget could not be displayed.
This widget could not be displayed.
Reply

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.

This widget could not be displayed.
This widget could not be displayed.
This widget could not be displayed.
Reply

sbrant_splunk
Splunk Employee
Splunk Employee

try this one:

CN=(?<Name>[^OU]*),OU
This widget could not be displayed.
This widget could not be displayed.
This widget could not be displayed.
Reply
This widget could not be displayed.
This widget could not be displayed.
This widget could not be displayed.
This widget could not be displayed.
This widget could not be displayed.
This widget could not be displayed.
Get Updates on the Splunk Community!