Deployment Architecture

How to implement "not in" in splunk?

flzhang132
Explorer

How to implement "not in" in splunk?
I want to find out the data that is not in the collection, as shown below
alt text
But always make mistakes, as shown below.
alt text

Tags (1)
0 Karma

vishaltaneja070
Motivator

Hello @flzhang132,

Just try this:

index="feeindex" sourcetype=csv dmon=201809
| search NOT [|search index="di_project_map_merger"] | fields project

Just make sure field name in both the index feeindex and "di_project_map_merger" have same field name project

Other wise rename field name in the subsearch

0 Karma

kristian_kolb
Ultra Champion

Assuming that these strings ("App", "APP", "001" etc) are field values of the same field in both indexes - lets call it 'blah' - you could make a subsearch like so;

index=feeindex NOT [search index=di_project_map_merge | dedup blah | table blah] | table blah

But perhaps you are looking for something different?

0 Karma
Get Updates on the Splunk Community!

Splunk Observability Cloud’s AI Assistant in Action Series: Analyzing and ...

This is the second post in our Splunk Observability Cloud’s AI Assistant in Action series, in which we look at ...

Elevate Your Organization with Splunk’s Next Platform Evolution

 Thursday, July 10, 2025  |  11AM PDT / 2PM EDT Whether you're managing complex deployments or looking to ...

Splunk Answers Content Calendar, June Edition

Get ready for this week’s post dedicated to Splunk Dashboards! We're celebrating the power of community by ...