Database Reference
In-Depth Information
Creating a backup status report with a
community template
The recommended practice for creating reports is to use vendor-supplied views instead of
database tables. The use of tables is not officially supported by Microsoft. DPM, however,
is an exception to this recommendation, based on the versions leading up to 2012 R2. This
exception is due to the limited amount of views available to create the right kind of reports.
Two community gurus have combined their talent to create and provide a reporting solution
that targets the DPM tables with valuable data for organization reports. Steve Buchanan
(System Center MVP) and Brooks Lindall (business intelligence consultant) are the creat-
ors and authors of the
DPM_BackupSummary
report.
The focus of this recipe is to use this report as a basis for discussing modifications to an ex-
isting report.
