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!

(\__/)
(='.'=)
(")_(")
Get Updates on the Splunk Community!

[Puzzles] Solve, Learn, Repeat: Dynamic formatting from XML events

This challenge was first posted on Slack #puzzles channelFor a previous puzzle, I needed a set of fixed-length ...

Enter the Agentic Era with Splunk AI Assistant for SPL 1.4

  🚀 Your data just got a serious AI upgrade — are you ready? Say hello to the Agentic Era with the ...

Stronger Security with Federated Search for S3, GCP SQL & Australian Threat ...

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...