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!

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 ...