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
Couldn't you just use a subsearch?
index=A sourcetype=B app=C NOT [inputlookup users.csv | fields user] | ...
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.
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?
I'd say out of those two, join leads to worse performance.