Splunk Enterprise

how to find ids which don't match with lookup

rimi_splunk
New Member

I'm a  newbie on splunk, trying the basic thing but didn't find any solution. Reaching out if I get the direction/solution.

I have the search results with userid using the query. Lookup file(master_users) has all users with column name userid.  I want tonly those userids which are in lookup but not in my search result. 

Tried multiple options but didn't find the right solution. 

Labels (1)
Tags (1)
0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

Assuming your lookup has another field other than userid which is not in your first search e.g. role, then you do lookup with userid and add where isnotnull(role)

0 Karma
Get Updates on the Splunk Community!

Fun with Regular Expression - multiples of nine

Fun with Regular Expression - multiples of nineThis challenge was first posted on Slack #regex channel ...

[Live Demo] Watch SOC transformation in action with the reimagined Splunk Enterprise ...

Overwhelmed SOC? Splunk ES Has Your Back Tool sprawl, alert fatigue, and endless context switching are making ...

What’s New & Next in Splunk SOAR

Security teams today are dealing with more alerts, more tools, and more pressure than ever.  Join us on ...