Splunk Enterprise

how to find ids which don't match with lookup

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


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!

Splunk Forwarders and Forced Time Based Load Balancing

Splunk customers use universal forwarders to collect and send data to Splunk. A universal forwarder can send ...

NEW! Log Views in Splunk Observability Dashboards Gives Context From a Single Page

Today, Splunk Observability releases log views, a new feature for users to add their logs data from Splunk Log ...

Last Chance to Submit Your Paper For BSides Splunk - Deadline is August 12th!

Hello everyone! Don't wait to submit - The deadline is August 12th! We have truly missed the community so ...