Splunk Search

Regex expression to extract fields

cgbsplunk
Explorer

I have two fields below that show up in our log files.  I used Splunk tool to create the Regex to extract the fields and at first I thought it worked until we had fields with different values that didn't extract.  Is there a simple Regex I can use to extract ObjectType and Domain Controller fields in example below?  Values should never have space so we can end value after first space.

ObjectType User

Domain Controller TSTETCDRS001

Labels (2)
0 Karma
1 Solution

PickleRick
SplunkTrust
SplunkTrust

And simple

Object\s+Type\s+(?<Object Type>\w+)

Doesn't work?

Same for the other one

Domain\s+Controller\s+(?<Domain Controller>\w+)

Check your regexes on https://regex101.com

View solution in original post

0 Karma

PickleRick
SplunkTrust
SplunkTrust

And simple

Object\s+Type\s+(?<Object Type>\w+)

Doesn't work?

Same for the other one

Domain\s+Controller\s+(?<Domain Controller>\w+)

Check your regexes on https://regex101.com

0 Karma

cgbsplunk
Explorer

Really appreciate the help.  That worked for those 2.  I also need one for Target.  I tried this:

Target\s+(?<Target>\w+)

But with a value of this:

Target ABCDE\test.user

I only get the ABCDE.  How do I change the expression to get the entire ABCDE\test.user

 

0 Karma

cgbsplunk
Explorer

I was able to get this to work by changing w to S like this:

Target\s+(?<Target>\S+)

Thanks again for the help

 

0 Karma

PickleRick
SplunkTrust
SplunkTrust

Show us a sample of your full events.

0 Karma

cgbsplunk
Explorer

These are coming from windows event logs.  Some of the fields are in name value pairs and extract on their own but last 4 fields are the ones I need expressions for.  Here is example of entire message:

10/27/2021 02:39:17 PM
LogName=Application
EventCode=16117
EventType=0
ComputerName=XXXXXXXXX002.xxxx.com
User=NOT_TRANSLATED
Sid=S-1-5-21-114000000-41296648-3127784425-637889
SidType=0
SourceName=AdminSvc
Type=Information
RecordNumber=1502524
Keywords=Audit Success, Classic
TaskCategory=SetInfo
OpCode=None
Message=Action SetInfo
ObjectType Computer
AssistantAdmin xxxx\xxxxx
Target xxxxx\xxxx-xxxx$
Domain Controller xxxxxx06
AccountDisabled

0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Your Feedback. Our Roadmap. Visit the PX Feedback Booth at .conf26

You use Splunk every day, come and help shape what's next.  Save Your Seat: Product-Focused Sessions at ...

Agentic SOC Triage: Investigating Splunk ES Notables with MCP Server and a Local LLM

The Problem: Too Many Alerts, Too Little Context Security operations teams running Splunk Enterprise Security ...

Painting a Clearer Picture: Creating Cross-Domain Visibility with AI Canvas

Watch Now Painting a Clearer Picture: Creating Cross-Domain Visibility with AI Canvas     Do you ever feel ...