Splunk Search

Is it possible to use a lookup for a field that has OR condition?

xbbj3nj
Path Finder

How do I lookup for a field which has Or condition.

example
Source Destination File name
act bank indexes_%
bank act indices_% OR integer_%

OR does not work, should I use pipe character ?

Tags (1)
0 Karma

Ayn
Legend

Lookups don't implement boolean functions like that - they're just doing straightforward matching. You can optionally configure them to do wildcard matching or CIDR matching but that's it.

What you could do instead is to have separate lines in your lookup for the statements instead. Like this:

source,destination,file_name
act,bank,indexes_*
bank,act,indices_*
bank,act,integer_*

Note that in order for this to work, you need to configure the match_type to be WILDCARD(file_name) in the lookup definition in transforms.conf.

0 Karma
Get Updates on the Splunk Community!

Routing Data to Different Splunk Indexes in the OpenTelemetry Collector

This blog post is part of an ongoing series on OpenTelemetry. The OpenTelemetry project is the second largest ...

Getting Started with AIOps: Event Correlation Basics and Alert Storm Detection in ...

Getting Started with AIOps:Event Correlation Basics and Alert Storm Detection in Splunk IT Service ...

Register to Attend BSides SPL 2022 - It's all Happening October 18!

Join like-minded individuals for technical sessions on everything Splunk!  This is a community-led and run ...