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!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...