Splunk Search

Subsearch: How can we only see results when they are NOT found?

mattheuslima
Explorer

I running a subsearch where i use a ID to find events from the index B in the index A.

What I want to do is: list the ID's from the index B that was not found in the index A

The subsearch structure is : search index=A search index=B |table ID's

How can I list the ID's that wasn't found?

0 Karma
1 Solution

woodcock
Esteemed Legend

Skip the subsearch and do this:

index="A" OR index="B"
| stats dc(index) AS indexCount values(index) AS index BY ID
| where index="B" AND indexCount=1

View solution in original post

0 Karma

woodcock
Esteemed Legend

Skip the subsearch and do this:

index="A" OR index="B"
| stats dc(index) AS indexCount values(index) AS index BY ID
| where index="B" AND indexCount=1
0 Karma

manjunathmeti
Champion

You need to use NOT.

index=A NOT [search index=B | table ID's]
0 Karma
Get Updates on the Splunk Community!

Transform your security operations with Splunk Enterprise Security

Hi Splunk Community, Splunk Platform has set a great foundation for your security operations. With the ...

Splunk Admins and App Developers | Earn a $35 gift card!

Splunk, in collaboration with ESG (Enterprise Strategy Group) by TechTarget, is excited to announce a ...

Enterprise Security Content Update (ESCU) | New Releases

In October, the Splunk Threat Research Team had one release of new security content via the Enterprise ...