Splunk Search

How do I extract a multivalued field from a windows event

MonkeyK
Builder

I don't know why I'm finding it so hard, but I want to put the accessess from Windows Event 5145 into a multivalued field and I just can't seem to figure it out.

 

By default, Splunk just assigns the first value. 

So I've been trying to work with this

| rex "Accesses:[\s]+(?<AccessList>[^v]*)[\v]+Access Check Results:"

 

 

 

04/25/2022 01:23:16 PM
LogName=Security
SourceName=Microsoft Windows security auditing.
EventCode=5145
EventType=0
Type=Information
ComputerName=test.act.root
TaskCategory=Detailed File Share
OpCode=Info
RecordNumber=984613134
Keywords=Audit Success
Message=A network share object was checked to see whether client can be granted desired access.
	
Subject:
	Security ID:		S-1-5-99-99999999-999999999-999999999-99999
	Account Name:		XXXX
	Account Domain:		act
	Logon ID:		0x999999

Network Information:
	Object Type:		File
	Source Address:		10.1.1.100
	Source Port:		60000
	
Share Information:
	Share Name:		\\fileshare\file.xxx
	Share Path:		\??\O:\Shared\fileshare\file.xxx
	Relative Target Name:	target\share

Access Request Information:
	Access Mask:		0x100081
	Accesses:		SYNCHRONIZE
				ReadData (or ListDirectory)
				ReadAttributes
				
Access Check Results:

 

 

 

 

Labels (2)
0 Karma
1 Solution

bowesmana
SplunkTrust
SplunkTrust

That appears to return the following in AccessList

SYNCHRONIZE
				ReadData (or ListDirectory)
				ReadAttributes

Are you wanting to turn that into an MV field?

You could add this to clean up the data

| eval AccessList=trim(split(replace(AccessList, "\n", "_"), "_"))
| eval AccessList=mvfilter(len(AccessList)>0)

 

View solution in original post

0 Karma

bowesmana
SplunkTrust
SplunkTrust

That appears to return the following in AccessList

SYNCHRONIZE
				ReadData (or ListDirectory)
				ReadAttributes

Are you wanting to turn that into an MV field?

You could add this to clean up the data

| eval AccessList=trim(split(replace(AccessList, "\n", "_"), "_"))
| eval AccessList=mvfilter(len(AccessList)>0)

 

0 Karma

MonkeyK
Builder

I guess that works.  Funny because my rex has an error.  I didn't mean to look for "not v" I'd been trying to say not vertical space 

[^\v]*

but it does still work to do what you suggested.  Thanks!

0 Karma
Career Survey
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.

Can’t make it to .conf25? Join us online!

Get Updates on the Splunk Community!

Community Content Calendar, September edition

Welcome to another insightful post from our Community Content Calendar! We're thrilled to continue bringing ...

Splunkbase Unveils New App Listing Management Public Preview

Splunkbase Unveils New App Listing Management Public PreviewWe're thrilled to announce the public preview of ...

Leveraging Automated Threat Analysis Across the Splunk Ecosystem

Are you leveraging automation to its fullest potential in your threat detection strategy?Our upcoming Security ...