Splunk Search

How to create a lookup subsearch with NOT IN

ub_ik
Explorer

I am facing following challenge. I have a lookup table myids.csv with ID's in it:

ID
1
2
3

I have and index also with IDs in it (less than in the lookup):

ID
1
2

I am lookup for a way to only show the ID from the lookup that is not present in the index.

ID
3

Any suggestions?

 

 

Labels (2)
Tags (1)
0 Karma
1 Solution

PickleRick
SplunkTrust
SplunkTrust

The usual - append two sets, count, find the ones that have too few occurrences.

https://www.duanewaddle.com/proving-a-negative/

View solution in original post

0 Karma

PickleRick
SplunkTrust
SplunkTrust

The usual - append two sets, count, find the ones that have too few occurrences.

https://www.duanewaddle.com/proving-a-negative/

0 Karma

ub_ik
Explorer

perfect, thx a lot.

0 Karma
Get Updates on the Splunk Community!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...