I am currently trying to build a report / query that will show a total number of virus attacks in a year that a perticual site has had. When building a query for site A I am getting results of 142 when I expect that it should be around 50. When looking at each result it turns out that they are are repeat of an earlier one a few minutes/seconds ago. Is there away of turning of duplicated virus treats.
I have created a multi-group summary table that is queriing System Name, Threat Name and Event Generated Time.
I am sorry if this has been answered before but I have spent the last two days looking for an answer