Splunk Search

How can I report on userid's that are on event file but not CSV Lookup?

cxfuent29
New Member

I am using a lookup csv file.

events have userid and CSV file has userid.

Some of the event file userid's are not on CSV file (timing issue)

The output produces event count by userid.

I need to report on userid's that are on event file but not CSV,

Thanks ahead

0 Karma

elliotproebstel
Champion

Try appending this to your current search (but replace my_lookup.csv with the name of your actual lookup file):

| search NOT 
 [| inputlookup my_lookup.csv 
 | fields userid ]
0 Karma
Get Updates on the Splunk Community!

Data Management Digest – December 2025

Welcome to the December edition of Data Management Digest! As we continue our journey of data innovation, the ...

Index This | What is broken 80% of the time by February?

December 2025 Edition   Hayyy Splunk Education Enthusiasts and the Eternally Curious!    We’re back with this ...

Unlock Faster Time-to-Value on Edge and Ingest Processor with New SPL2 Pipeline ...

Hello Splunk Community,   We're thrilled to share an exciting update that will help you manage your data more ...