Dear @ITWhisperer Thank you for your response. As for the where clause, I agree. date_hour does not hold the data, hour field is ok. we need to now about working in forbidden hours, which is after 11 PM until 6 AM. The result I have has same hostname, same event code 4624. This is main search I have with results attached: index=main source="WinEventLog:Security" EventCode="4624" OR EventCode="539" OR (EventCode="529" AND EventCode="537") OR (EventCode="547" AND EventCode="549") |where (Logon_Type!=3 OR ( NOT LIKE(host,"DC%"))) AND Logon_Type!=9 | eval Signed_Account=mvindex (Account_Name,1) |eval hour=strftime(_time,"%H") |regex Signed_Account!="\$" | search Signed_Account=* Signed_Account!="SYSTEM" Signed_Account!="ANONYMOUS LOGON" Signed_Account!="Administrator" (hour>23 OR hour<6) | table host,Signed_Account,EventCode,_time
... View more