Splunk Search

How to combine two queries into one?

dwibedi03
Explorer

I have two query that is exact same except the use of the lookup for each search. The one query includes data from a lookup and the other one excludes data from the same lookup. Is there a way I can combine two queries into one.

The first one is

 

index=abc dest="xyz.com" uri_path="access.html" http_method=POST NOT 
    [| inputlookup filter_ips 
    | fields src] | stats count by _time src

 

The second one is

 

index=abc dest="xyz.com" uri_path="access.html" http_method=POST 
    [| inputlookup filter_ips 
    | fields src] | stats count by _time src

 

The only difference is the Not in the first one. Can someone help me combine it? I tried using braces around the searches and combining it but didnt work.

Example

 

(index=abc dest="xyz.com" uri_path="access.html" http_method=POST NOT 
    [| inputlookup filter_ips 
    | fields src] | eval test= a1) OR (index=abc dest="xyz.com" uri_path="access.html" http_method=POST 
    [| inputlookup filter_ips 
    | fields src] | eval test=a2) | stats count by _time src test

 

But it gives error as eval expression malfunction.

Labels (4)
0 Karma

tscroggins
Influencer

The union of the two searches is simply the base search:

index=abc dest="xyz.com" uri_path="access.html" http_method=POST | stats count by _time src

0 Karma

to4kawa
Ultra Champion

If you combine them, you won't get any results.

0 Karma
Get Updates on the Splunk Community!

Index This | I’m short for "configuration file.” What am I?

May 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with a Special ...

New Articles from Academic Learning Partners, Help Expand Lantern’s Use Case Library, ...

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

Your Guide to SPL2 at .conf24!

So, you’re headed to .conf24? You’re in for a good time. Las Vegas weather is just *chef’s kiss* beautiful in ...