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:
https://www.buchatech.com/2011/01/building-custom-reports-in-dpm/.

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. 

image

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

image

Read more

Building Custom Reports in DPM

The Need:

You need to get detailed reports on your Data Protection Manager. The reports that are included with DPM are not enough and do not contain the data that you need to report on.

The Solution:

There is a way to create custom reports for DPM. I am not a SQL guy and will never claim to be but I was still able to figure out how to generate custom reports for DPM thanks to Microsoft SQL reporting services. Let’s cover the process of doing this.

The DPM Report Views

Views are like tables in SQL in the way they look. Views can be considered virtual tables that pull data from multiple tables. They dynamically generate their data when the view is referenced. Someone typically will build a view for non-SQL users that do not know how to write SQL queries but need to pull data together.

Microsoft has included a bunch of SQL views in the DPM database by default. They included these so that DPM administrators could create custom reports. These Custom Report Views for DPM can be found here: http://technet.microsoft.com/en-us/library/ff399120.aspx . On that link it will also describe what type of data each view will give you in your report. This is what the views look like and where they are stored in SQL management studio.

clip_image002

These views need to be used by SQL Reporting Services to generate the custom DPM reports.

Read more