I'm running the below query across the network and would like it to pinpoint that search towards two users rather than run the search across the entire network and have hundreds of users. When I use the "where" clause and enter in both users that I'd like to search under, nothing comes back. The moment I remove the "where" clause, data comes back. Should my where clause positioned elsewhere up the pipe? Or is it just a matter of incorrect syntax? | from datamodel:"Authenticate" | eval host=upper(host) | search [| inputlookup hosts_upper.csv] | search user!=svc* NOT src_user IN (system, dbagent, svc*) | search NOT signature_id IN (4769, 4672, 4648) | eval "Logon Type" = case(Logon_Type == 2, "Interactive", Logon_Type == 3, "Network", Logon_Type == 4, "Batch", Logon_Type == 5, "Service", Logon_Type == 7, "Unlock", Logon_Type == 8, "Clear Text", Logon_Type == 9, "New Credentials", Logon_Type == 10, "Remote Interactive", Logon_Type == 11, "Cached Interactive") | fillnull value=NULL "Unknown" | table _time action host user src app Logon_Type "Logon Type" host signature sourcetype | where user="johndoe" OR user="janesmith" | sort -_time
... View more