Need to find hosts where an event of a type was not followed by event of another type within an hour
I need to find hosts where virus infection was detected and it failed to perform any action, where "None" is not followed up by of the other events " Blocked OR removed OR quarantined" in 1 hour
Fields available are
ComputerName=
VirusName=
Action Taken=
Sample log
10/11/2014 20:01 : ComputerName=test1 VirusName=conficker ActionTaken=None
10/11/2014 20:02 "ComputerName=test1 VirusName=conficker ActionTaken=blocked
10/11/2014 22:01 : ComputerName=test20 VirusName=conficker ActionTaken=None
10/11/2014 20:01 : ComputerName=test30 VirusName=conficker ActionTaken=None
10/11/2014 20:02 "ComputerName=test30 VirusName=conficker ActionTaken=removed
As you can seen above, no action was taken by antivirus on Computer test20. I need to write a search query to create a report or dashboard to find any such machine.
Any pointers in the right direction would be appreciated
... View more