topic Re: How to configure props.conf and transforms.conf to select events containing a string of words? in Getting Data In

How to configure props.conf and transforms.conf to select events containing a string of words?

dseabury — Mon, 28 Sep 2020 18:06:08 GMT

I have scoured the 'Net, Splunk docs and the Answers and found lots of good information on setting up my indexer filtering to reduce the noise coming from my firewall syslog UDP feed. I feel like I'm really close, because now there is nothing coming through. What I WANT to see are only messages that contain "TCP access denied". I can apply a piped REGEX statement on the search and it works, but I don't seem to have props and transforms files set up quite right yet.

This works in search: source=firewall | regex _raw="TCP access denied"

Props.conf:
[source::firewall]
TRANSFORMS-set= setnull,setparsing

Transforms.conf:
[setnull]
REGEX = .
DEST_KEY = queue
FORMAT = nullQueue

[setparsing]
REGEX _raw="TCP access denied"
DEST_KEY = queue
FORMAT = indexQueue

Any additional insight would be welcome!

Re: How to configure props.conf and transforms.conf to select events containing a string of words?

martin_mueller — Wed, 05 Nov 2014 20:06:13 GMT

Replace this:

REGEX _raw="TCP access denied"

With this:

REGEX = TCP access denied

That's assuming the quotes aren't part of the to-be-matched event.

Re: How to configure props.conf and transforms.conf to select events containing a string of words?

richgalloway — Wed, 05 Nov 2014 20:11:23 GMT

Try reversing the order of your TRANSFORMS-set statement. The setnull transform is matching everything, leaving nothing for setparsing to index.

Re: How to configure props.conf and transforms.conf to select events containing a string of words?

martin_mueller — Wed, 05 Nov 2014 20:15:18 GMT

The order setnull,setparsing is correct. Both are run, nullQueue is always set and sometimes overwritten by indexQueue.

Re: How to configure props.conf and transforms.conf to select events containing a string of words?

dseabury — Wed, 05 Nov 2014 20:30:59 GMT

SUCCESS!!! Thanks for the responses. I made the change recommended by martin_mueller and restarted Splunk (is that necessary?).

This will throw open the door for me to add more filtering and get our firewall index fully tuned...

Re: How to configure props.conf and transforms.conf to select events containing a string of words?

martin_mueller — Wed, 05 Nov 2014 20:59:36 GMT

As a rule of thumb, restarting is necessary for all index-time configuration file changes, which this very much is.

Search-time config file changes may get along with a debug/refresh call.