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.

Get Updates on the Splunk Community!

UCC Framework: Discover Developer Toolkit for Building Technology Add-ons

The Next-Gen Toolkit for Splunk Technology Add-on Development The Universal Configuration Console (UCC) ...

.conf25 Community Recap

Hello Splunkers, And just like that, .conf25 is in the books! What an incredible few days — full of learning, ...

Splunk App Developers | .conf25 Recap & What’s Next

If you stopped by the Builder Bar at .conf25 this year, thank you! The retro tech beer garden vibes were ...