Splunk Search

How to build a tranform which applies to a events with a field value found in a provided list

juniormint
Communicator

I have a index time transform which is a bit loose in what it matches. I would like to limit it to a whitelist of indexes that I want to match against. I would very much appreciate your help with creating a clean regular expression to achieve the goal.

So I think I want REGEX = match any event with a embedded field of the form index="SomeIndexName" where SomeIndexName in (App1,App2,App3).

My current transform
[MyTransform]
REGEX=.index="(.?)"
DEST_KEY=_MetaData:Index
FORMAT=$1
CLEAN_KEYS
MV_ADD=0

0 Karma
1 Solution

lukejadamec
Super Champion

The OR operator for regex is the pipe:

REGEX= index="(App1|App2|App3)"

I changed .index to just index because I'm not sure you need it.

View solution in original post

lukejadamec
Super Champion

The OR operator for regex is the pipe:

REGEX= index="(App1|App2|App3)"

I changed .index to just index because I'm not sure you need it.

juniormint
Communicator

Yes. $1 will contain the value inside the parenthesis.

juniormint
Communicator

Will $1 still contain the field value?

0 Karma
Get Updates on the Splunk Community!

Join Us for Splunk University and Get Your Bootcamp Game On!

If you know, you know! Splunk University is the vibe this summer so register today for bootcamps galore ...

.conf24 | Learning Tracks for Security, Observability, Platform, and Developers!

.conf24 is taking place at The Venetian in Las Vegas from June 11 - 14. Continue reading to learn about the ...

Announcing Scheduled Export GA for Dashboard Studio

We're excited to announce the general availability of Scheduled Export for Dashboard Studio. Starting in ...