Getting Data In

Trying to drop Windows Events at the Indexer

rmcdougal
Path Finder

I am attempting to drop WinEventLog:Security EventCode's at the Indexer and I am not having any success. I have read a few SplunkBase questions concerning this very topic and attempted to follow the instructions with little success. This is what I have so far.

Props.conf


[WinEventLog:Security]
TRANSFORMS-set = dropevents

Transforms.conf


[dropevents]
REGEX = (?m)^EventCode=(4957|5154|5156|5158)
DEST_KEY = queue
FORMAT = nullQueue

Any ideas what I am doing wrong here?

1 Solution

Chubbybunny
Splunk Employee
Splunk Employee

we do it like this on our bunny farm:

$SPLUNK_HOME/etc/system/local:
Props.conf

 [WinEventLog:Security]
 TRANSFORMS = null, keep

Transforms.conf

[keep]
REGEX = .
DEST_KEY = queue
FORMAT = indexQueue

[null]
REGEX=EventCode=(4957|5154|5156|5158)
DEST_KEY = queue
FORMAT = nullQueue

View solution in original post

Chubbybunny
Splunk Employee
Splunk Employee

we do it like this on our bunny farm:

$SPLUNK_HOME/etc/system/local:
Props.conf

 [WinEventLog:Security]
 TRANSFORMS = null, keep

Transforms.conf

[keep]
REGEX = .
DEST_KEY = queue
FORMAT = indexQueue

[null]
REGEX=EventCode=(4957|5154|5156|5158)
DEST_KEY = queue
FORMAT = nullQueue

rmcdougal
Path Finder

Interestingly enough, even if I do this

props.conf


[WinEventLog:Security]
TRANSFORMS = setnull

transforms.conf


[setnull]
REGEX = .
DEST_KEY = queue
FORMAT = nullQueue

It doesn't drop anything. It has to be something with the sourcetype having a colon in it I imagine.

0 Karma

sowings
Splunk Employee
Splunk Employee

The location of the props.conf or transforms.conf matters. If this is a Universal Forwarder (UF), the rules which would trigger for placing these events in the nullQueue aren't processed there. You'll need these rules on the indexer(s) instead. By contrast, if the forwarder is "heavy" (i.e. a full Splunk forwarding its log data elsewhere), the props / transforms have to be on that forwarder itself.

0 Karma

rmcdougal
Path Finder

I appreciate the help, but for some reason this still isn't working for me. This is what I have on my box currently but is still isn't dropping anything.

props.conf


[WinEventLog:Security]
TRANSFORMS-set= setnull,setparsing

transforms.conf


[setnull]
REGEX = EventCode=(4957|5154|5156|5158)
DEST_KEY = queue
FORMAT = nullQueue

[setparsing]
REGEX = .
DEST_KEY = queue
FORMAT = indexQueue

Here is a sample event

http://i.imgur.com/FmxeK.png

0 Karma

Chubbybunny
Splunk Employee
Splunk Employee

Vote the Chubby bunny up if it helps!

(\__/)
(='.'=)
(")_(")
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!

Build the Future of Agentic AI: Join the Splunk Agentic Ops Hackathon

AI is changing how teams investigate incidents, detect threats, automate workflows, and build intelligent ...

[Puzzles] Solve, Learn, Repeat: Character substitutions with Regular Expressions

This challenge was first posted on Slack #puzzles channelFor BORE at .conf23, we had a puzzle question which ...

Splunk Community Badges!

  Hey everyone! Ready to earn some serious bragging rights in the community? Along with our existing badges ...