One of the biggest weaknesses in DPM is its reporting capabilities. DPM doesn't offer an easy way to create custom reports, so in this section we will explain how to create a custom report using the reporting services.
Microsoft has included a bunch of SQL views in the DPM database by default. They have included them so that the DPM administrators can create some custom reports. These Custom Report Views for DPM can be found at http://technet.microsoft.com/en-us/library/hh757766.aspx. (This URL also describes what type of data each view will provide you for your report.) The following screenshot shows what the views look like and where they are stored in SQL Management Studio: