Splunk Search

Does lookup command support OR Boolean operation?

Engager

Hello,
I have events in index 1 and I have lookup table 1 created from a CSV file. I want to lookup events from index 1 in lookup table 1 by following a hierarchical logic:

  1. lookup where tail number OR flight ID OR operator matches
  2. AND lookup where airport matches

My search currently looks like this and it works. Is there a way to simplify it so that one lookup checks tail number then flight id then operator?
index=index1
| lookup lookuptable1 id as tailNo airport as iataAirport OUTPUT start_date/time as start_date
| lookup lookuptable1 id as flightId airport as iataAirport OUTPUTNEW start_date/time as start_date
| lookup lookuptable1 id as operator airport as iataAirport OUTPUTNEW start_date/time as start_date

Tags (2)
0 Karma

Communicator

lookup does not, but you may be able to achieve what you're looking for by using a KV Store instead.

See this link for configuring a KV Store from a CSV file:

http://docs.splunk.com/Documentation/Splunk/6.4.2/Knowledge/ConfigureKVstorelookups

And see this link for examples of using a where clause with the KV Store (in the "Filters and queries" section):

http://dev.splunk.com/view/SP-CAAAEZH

0 Karma