Splunk Search

How to use list of authorized users from a lookup file to search who is not logged in to a specific application?

splunkn
Communicator

Im having users list in lookup file, and using the index and sourcetype I can extract one set of users.
The requirement is i want to extract the authorised users in the list (lookup here) who are not logged in to the specific application (dat indicates no logs will be in events for that specific user).
I thought of using join here. But none works..

index=A sourcetype=B app=C | stats count as total by user | fields user,total | join type=outer user [ |inputlookup users.csv | table user ] | fillnull value=0 total | eval Reason if(total>0,"Userloggedin","UserNotlogged") | table user,Reason | fields - total

Any help??? Thanks in advance

Tags (2)
0 Karma

Ayn
Legend

Couldn't you just use a subsearch?

index=A sourcetype=B app=C NOT [inputlookup users.csv | fields user] | ...

martin_mueller
SplunkTrust
SplunkTrust

Any performance penalty related to NOT is usually caused by loading events you don't actually need off disk. However, the original search loads all the events anyway, so filtering out some stuff with NOT can't be worse than loading all the events.

splunkn
Communicator

Ayn thanks for your response. But using NOT leads to lack of performance isn't it?
And one more query is there any errors in my query with OUTER join, Why the results are not coming up?

0 Karma

Ayn
Legend

I'd say out of those two, join leads to worse performance.

Career Survey
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.
Get Updates on the Splunk Community!

Observe and Secure All Apps with Splunk

 Join Us for Our Next Tech Talk: Observe and Secure All Apps with SplunkAs organizations continue to innovate ...

What's New in Splunk Observability - August 2025

What's New We are excited to announce the latest enhancements to Splunk Observability Cloud as well as what is ...

Introduction to Splunk AI

How are you using AI in Splunk? Whether you see AI as a threat or opportunity, AI is here to stay. Lucky for ...