Splunk Search

REGEX for nullQueue in transforms.conf

asarolkar
Builder

We have a certain logfile (tied to sourcetype: syslog) inbound from a forwarder which has THIS line in it:

2012-07-02 15:29:52,190 DEBUG [http-0.0.0.0-8080-3]   LoggingFilter - url=[/healthCheck/status],

We want to filter out any events ON THE INDEXER SIDE that have this content -> /healthCheck/status.

We tried making the following changes to :

i) $SPLUNK_HOME/etc/system/local/props.conf

[sourcetype::syslog]
TRANSFORMS-null=ignore

and then over at

ii) $SPLUNK_HOME/etc/system/local/transforms.conf

[ignore]
REGEX=healthCheck
DEST_Key=queue
FORMAT=nullQueue

However that does not seem to work and I am certain its because the REGEX is not setup correctly.

I have tried the following alternatives that do not work out either:

1. REGEX= \[(healthCheck)\]
 2. REGEX= (^m)(healthCheck)
 3. REGEX= \healthCheck\status
4. REGEX= ^\S+\s+(?<healthCheck>\S+)

~~~

Also, is it likely that the changes ought to made to the props.conf and transforms.conf which resides at $SPLUNK_HOME/etc/apps/search/local instead ? Any suggestions ?

1 Solution

lguinn2
Legend

This regex should match /healthCheck/status

REGEX=/healthCheck/status

None of these characters are special characters to regex. If you want to match [/healthCheck/status], then this should do it

REGEX=\[/healthCheck/status]

If neither of these works, then perhaps the problem is elsewhere. For example it is not

DEST_Key=queue

But

DEST_KEY=queue

So check your transforms.conf and props.conf very carefully. Of course, perhaps that was just a typo in your question here, not in the original file...

HTH

View solution in original post

lguinn2
Legend

This regex should match /healthCheck/status

REGEX=/healthCheck/status

None of these characters are special characters to regex. If you want to match [/healthCheck/status], then this should do it

REGEX=\[/healthCheck/status]

If neither of these works, then perhaps the problem is elsewhere. For example it is not

DEST_Key=queue

But

DEST_KEY=queue

So check your transforms.conf and props.conf very carefully. Of course, perhaps that was just a typo in your question here, not in the original file...

HTH

asarolkar
Builder

I take that back it worked out indeed !

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!

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 ...