Splunk Search

How to run a search if another search does not return any results?

drautb
Explorer

Hey all,

I have two searches that both run independently of one another. They both work fine by themselves. Now, I would like the run the second search, if and only if, the first search does NOT return any results. I'm trying to do something like this right now:

<first search> | stats count | where count=0 | <second search>

But that doesn't quite work, the events from are returned, but no others are. What I'd like is for the events from to just be dropped, and the events from to be returned if there were NOT any results for . Has anyone done this before?

Tags (2)

the_wolverine
Champion

If you schedule the first search, you could schedule a second search which looks for result_count=0 in the internal log:

index=_internal startminutesago=5 sourcetype=scheduler savedsearch_name="name_of_first_scheduled_search" status=success result_count=0 | append [ search "second search query" ]

drautb
Explorer

I apologize, thanks for catching that. I've edited my question.

0 Karma

strive
Influencer

What if there are no results from first search? In that case you want your second search to be executed or not executed?

You have contradicting statements in your question.

"Now, I would like the run the second search, if and only if, the first search doesn't return any results."

"What I'd like is for the events from to just be dropped, and the events from to be returned if there were any results for "

Get Updates on the Splunk Community!

Enterprise Security Content Update (ESCU) | New Releases

In December, the Splunk Threat Research Team had 1 release of new security content via the Enterprise Security ...

Why am I not seeing the finding in Splunk Enterprise Security Analyst Queue?

(This is the first of a series of 2 blogs). Splunk Enterprise Security is a fantastic tool that offers robust ...

Index This | What are the 12 Days of Splunk-mas?

December 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...