Jun 12, 2009 at 4:45 PM
Edited Jun 12, 2009 at 4:55 PM
Thanks for the reply. It does seem odd that the GUI allows for an export of the results, but once exported, you reach a dead end.
The results can't be parsed, can't be displayed in an HTML file, can't be emailed, can't be imported into a GUI viewer, and basically are useless.
I wonder why the "export results" button even exists on the GUI.
From what I can tell, in the scenario where you want to view the details, you can't even go to the policy.PolicyHistory (or Policy.PolicyHistoryDetail)
table and process the results. You actually have to manually, via the GUI, re-evaluate the policy if you want to dive the full depth into the details
(finding out if the last backup time was 2 days or 2 years ago, for example.).
To your other point- yes, I misspoke. The fact that database "Northwind" failed the policy is revealed, but you can't tell that the last backup was
6/11/2009 or 6/11/2004. There's no way to see the date the policy was actually evaluated against. A database backup may have been missed
yesterday or a database may have never been backed up; you can't tell. The GUI reveals this detail.
Thanks for looking into it!