Not really sure how to title this, but here is the scenario. I have altered a canned report to run the first Monday of every month and dump a Word file w/links into a folder. The alteration of this report is simply changing the end date to be -30 from today. So I am getting a 30 day report of all computers that were infected. The report runs and looks to be accurate based on alerting I have setup. The problem comes when I take this report and start to drill down into the data using the links in the report. Let's say my report shows a virus name with an infection count of 3. I can click on 3 and see a list of PCs that were infected....well not so much. If between the time the PC was infected and the time I look at the report, any of the 3 PCs were cleaned of the infection, then they will not show up in the drilldown. So if a single PC was cleaned...the count still shows 3, but clicking on 3 only shows 2 computers now. This pretty much goes for any data on the main page.

So essentially the report is pretty useless to go back in time and see detailed info on the incidents since the status of every bit of info in that report has changed over time. I am not a SQL person, but I did have one of SQL team look at the database and she can't see anywhere that she can pull archived data from. Any idea what direction I can point her in to get the type of reports I am looking for?

Yes, I know this is an old post, but Im trying to clean them up. Did you solve this problem, if so what was the solution?

Since no one has answer this post, I recommend opening  a support case with Microsoft Customer Support Services (CSS) as they can work with you to solve this problem.<o:p></o:p>