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!

Accelerating Observability as Code with the Splunk AI Assistant

We’ve seen in previous posts what Observability as Code (OaC) is and how it’s now essential for managing ...

Integrating Splunk Search API and Quarto to Create Reproducible Investigation ...

 Splunk is More Than Just the Web Console For Digital Forensics and Incident Response (DFIR) practitioners, ...

Congratulations to the 2025-2026 SplunkTrust!

Hello, Splunk Community! We are beyond thrilled to announce our newest group of SplunkTrust members!  The ...