topic Re: Outer query should display the results based on the inner query count in Splunk Search

Outer query should display the results based on the inner query count

sravankaripe — Mon, 10 Apr 2017 18:00:43 GMT

i want to display the events based on subquery's count(say Mycount) .
please help me with search query.

index=abc sourcetype=xyz [search index=pqr sourcetype=pqrs | return 100 $ID|eventstats count as MyCount]
| where MyCount>0

somesoni2 — Mon, 10 Apr 2017 18:55:52 GMT

Something like this??

index=abc sourcetype=xyz | where [search index=pqr sourcetype=pqrs | return 100 $ID | stats count as query]>0

sravankaripe — Mon, 10 Apr 2017 19:11:18 GMT

index=abc sourcetype=xyz | where [search index=pqr sourcetype=pqrs | return 100 $ID | stats count|return 1 $count]>0

its working like this