DPM Backup Summary Report

For some time DPM reporting has been an area within DPM that has needed improvement. Since DPM version 2007 the community has asked for improved reporting or an easy way to create custom reports to fit their needs. A quick search will yield many forum threads discussing the need for better reporting in DPM.

Backup administrators need to get detailed reports on Data Protection Manager (DPM) backups. The reports that are included with DPM are not enough and do not contain the data that is often needed for reporting within organizations. Management of IT departments need to know if backup SLA’s are being met and need backup health trend reports. Backup reports and charts need the functionality to be printed, exported and scheduled. DPM already contains some of this functionality through SQL Reporting Services but as aforementioned the out of the box reports do not contain the needed data or charts.

There has been several blogs in the community on how to build your own custom reports for DPM using SQL Report Builder and the DPM SQL views (http://technet.microsoft.com/en-us/library/ff399120.aspx) that are default in the DPM SQL database. See these the following links on creating custom reports for DPM:



Even with the ability to create custom DPM reports the need for better reporting within DPM has not gone away. Creating custom reports is not a solution that is viable for all backup administrators out there in the community.

The solution is not viable for several reasons. The DPM SQL views are limited in the data that they allow someone to pull into a report. Therefore the person building the custom reports would need to write SQL queries to pull the data they need. The second reason is that most backup administrators do not have the SQL skills required to go in and build SQL queries. Backup administrators generally do not have the design skillset to build a report with the right charts, graphs and data using tools like SQL Report Builder or Business Intelligence Design Studio (BIDS).

I have teamed up with a buddy of mine that is a business intelligence expert. His name is Brooks Lindall and he is one of the smartest guys I know. A HUGE thanks goes out to him for joining me in trying to solve this problem. Together we created a solution that is the DPM Backup Summary Report. This report was designed with the community in mind. One goal was to make the report portable to any DPM environment so backup administrators could easily drop it in their environment and start reporting on their DPM data right away. With that in mind this report was built in a generic way so that no modifications to SQL are needed when it is installed. We also set out to incorporate as many of the data points that we could that DPM admins in the community have been asking for. We wanted to fit all of the data in a single view. The last goal was to give this report to the community for free.

This report works with DPM 2010 and DPM 2012/R2. For now the report is only for disk and tape based backups. In the future we are looking to extend this in the future to show online (Azure) as well. The features and data points contained in the report are:

  • Ability to select day, week, month (Time range)
  • Ability to select a single server or many
  • Ability to select a single protection group or many
  • Ability to select disk, tape or both backup type
  • Summary of the backup success and failures with a percentage of the successes (Success Rate/SLA)
  • Health trend of backups (day, week, month)
  • Backup detail including:Individual data sources (What was actually backed up)
    •      The status including the error (if there is an error)
    •      Date and time the backup was created
    •      How much data was transferred during the backup
    •      Total time it took to backup to complete



Read more

New SCOM DPM Dashboard Download Link

A company named AIO Technology published a SCOM DPM dashboard a while ago. They recently removed it as they no longer offer this. I was the one that built this dashboard. I am posting about it here for anyone that may be looking to download it. You can now find this on TechNet Gallery here: http://gallery.technet.microsoft.com/SCOM-DPM-Dashboard-8eef9b58

Information about the dashboard:


This dashboard shows the overall health of your Data Protection Manager (DPM) backups. It includes all DPM servers in your environment in a central location. Great for daily spot checking of your backup health and getting to the root of any problems faster.

Installing is as simple as importing into your Operations Manager (SCOM) server. You do need DPM management packs and central console deployed to your SCOM before installing this dashboard.

DPM Dashboard Example


  • Centralized health of all DPM servers
  • Protection Group health aggregate
  • Protected Data Source health aggregate
  • Storage Pool health aggregate
  • Tape/Tape Library health aggregate

Read more

DPM How to Videos

Are you new to System Center Data Protection Manager (DPM)? Here is a list of some videos from myITforums.com that will help you get up to speed on DPM: Overview of System Center Data Protection Manager http://www.myitforum.com/absolutevc/avc-view.aspx?videoid=922&categoryid= DPM 2007 SP1 — How does DPM really work http://www.myitforum.com/absolutevc/avc-view.aspx?videoid=1324&categoryid= TechNet Webcast: Protecting Microsoft SharePoint with Data Protection … Read more

Data Protection Manager 2010 Overview Poster

  I was honored to work with Microsoft DPM MVP Yegor Statsev and Sean O Farrell on a DPM 2010 poster. Both Yegor and Sean are great guys and run blogs with lot’s of good information on them. You can find  links to their blogs under the Tech Blog Sites section. Here is a a … Read more

Anonymous SMTP for DPM

Setting up anonymous SMTP in DPM has been an issue for some time. Anonymous SMTP notifications don’t work even if you have your Exchange server setup correctly to receive anonymous email from DPM. Let’s step through configuring this. Here are the steps to setup SMTP in DPM that does not require authentication: 1. In DPM … Read more

Clarification of SIS-Limited on DPM

I have seen some questions regarding SIS that is installed with DPM. After doing some investigating and talking with Microsoft and some of the DPM MVP’s I can offer some clarification. The SIS-Limited that is installed on a DPM server is actually a SIS Filter driver. The SIS Filter driver is what runs on DPM. … Read more

Backing up System State of Windows 7 with DPM

Yes the title of this post is misleading. That was intentional. I have seen many fellow IT Pros in the community asking if backing up system state of Windows clients is possible with DPM 2010. Well it is not and it will not be possible with DPM 2012 either. DPM was designed to protect client data but not the machine entirely. DPM does a great job of protecting client data but there is a real need in some environments to protect client PC’s as a whole.

There is not an officially supported solution for this but there is a work around to protect the entire client.

For XP clients you could backup system state of your XP machines to a network share or folder and then have DPM pick it up from there.

Windows Vista/7 does not have a system state backup option. That was replaced with “Complete PC Back up”. Complete PC Back up in Windows Vista/7 is an image of the computer so it achieves a similar goal to system state. You can schedule to run the Complete PC Back up out to a folder or network share and then let DPM pick it up from there.

Again this is not ideal but it is a good alternative when you need complete protection of your client.

Here is the process to set this up on Windows 7.

  • Go to Start>>>Control Panel>>>Backup and Restore

Note that Windows backup has not been setup yet.

  • Click on Set up backup.


The Windows Backup wizard will start. This can take a while to open so be patient here.


Read more

Better Reporting in DPM through Prism

Reporting for DPM has been a problem for many DPM administrators. You need better reporting on scheduled backup jobs, success/failures of backup jobs, details on tape jobs, SLA reports, and more. Your only other option was to create custom reports in DPM using the SQL views that come with DPM. I posted on how to do this a while back here:

Working with SQL views is not the easiest way to get custom reports if you are new to or not savvy with SQL Reporting services. Well the alternative to this is Prism.

A company named Bocada has developed a product called Prism that helps you get better reporting out of your backup solutions. They have a flavor for DPM. The nice folks at Bocada gave me a demo of this product live in action. Thanks Ralph!

I am going to give you some more details about Prism for DPM in this post.

There are many pros to Prism and only a couple of cons. One of the cons is that you still cannot bring the custom reports into the DPM console. They are however web based and easy enough to access. 
There still is a slight learning curve to learn how to customize reports.

Prism is a stand alone product that is deployed on a server and accessed via a web browser. It runs on top of IIS and accesses the DPM data directly through the DPM SQL database. Once Prism has collected information about DPM it is able to present the information as reports.

Prism can be setup to gather information from multiple DPM servers for reporting therefore it can be used in enterprises with many DPM servers.

Brocada  teamed up with Microsoft to create two default DPM specific reports in conjunction with reporting DPM related data in Prism. These reports are:

  • Recovery Point Summary
    Recovery Point Summary provides a summary of the number of Non-expired recovery points, Date of the last non-expired recovery point and the average recovery point in Range for all the clients being protected. 


  • Recovery Point Status
    Recovery Point Status lets you see the various success or failures of your daily recovery points. 


Read more