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:

http://www.buchatech.com/2011/01/building-custom-reports-in-dpm/

http://blogs.technet.com/b/dpm/archive/2013/01/22/how-to-create-a-custom-report-in-system-center-2012-data-protection-manager.aspx

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

SAMPLE OF REPORT:

clip_image001

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:

OVERVIEW

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.

clip_image001

FEATURES

  • 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

Featured on IT PRO Experts

Lee Berg a Systems Management Specialist, active member in the System Center community and now coworker of mine at Concurrency.com has a great YouTube channel https://www.youtube.com//LeeAlanBerg with Microsoft technology videos for the IT Pro community. It features Weekly Service Manager and Private Cloud round up’s, Demos, Reviews, and Interviews.

Lee has been doing these IT Pro Expert series for a while now. He has featured some great guys that are also MVP’s. Some include Chris Nackers, Chris Ross, and Adam Driscoll.

Recently Lee reached out to me to be in this series and we made it happen. During this episode we talked about System Center, consulting, writing books, TechEd, “HyperV the energy drink” and more! Check it out on Lee’s blog:

clip_image001

http://www.leealanberg...

Read More

Service Manager SP1 Update Rollup 4 Error

I recently ran across some problems when trying to update System Center Service Manager SP1 with Update Rollup 4 (UR4) (http://www.microsoft.com/en-us/download/details.aspx?id=40836). Here is the error: “Microsoft System Center 2012 Service Pack 1 Service M has stopped working“.

 

clip_image001

There is a Temp folder on management servers with SCSM setup logs like in the screenshot.

clip_image002

The UR seems to get hung up on something in one of these logs. To get past this try the following:

From the management server/s that the UR install failed on go into C:\Users\YOUR USERNAME OR USER SM WAS INSTALLED UNDER\AppData\Local\ and rename the Temp folder to something like Old-Temp. Reboot and then run the UR4 install again. Now the UR4 should go through without any problems.

Read More

Remove Orphaned Connectors in Service Manager

PROBLEM:

Recently I came across a Service Manager environment that had some old SCOM 2007 connectors that were no longer being used. These SCOM 2007 connectors would not remove from the SM console and would throw the following error when trying to remove.

clip_image001

This is an easy fix. Use the SMLets to remove this connectors using the -Force switch. You may have seen blogs on this for removing an orphaned Exchange connector. Well this works on any connector. Here are the steps:

FIX:

  1. Install SMLets (Link: https://smlets.codeplex.com).
  2. Open Service Manager PowerShell and Import-Module SMLets.
  3. Run: Get-SCSMObject –Class (Get-SCSMClass –Name Microsoft.SystemCenter.Connector)to show a list of current connectors.
  4. Note the connector/s you want to remove. BE SURE YOU HAVE THE RIGHT CONENCTOR...
Read More

FREE Modern Datacenter Event 3-28-14

There is a free System Center event coming up at the Microsoft office in Edina, Minnesota. At this event discover how Windows Server 2012 R2, System Center 2012 R2, and Windows 8.1 work together to help you to provision and manage cloud and data center infrastructure, provide business continuity, deliver services, and manage applications.

Both System Center MVP’s Nathan Lasnoski and Steve Buchanan will be presenting at the Minnesota Modern Datacenter event. More information about the presenters:

Microsoft MVP Nathan Lasnoski is the Director of Concurrency’s Infrastructure Practice, a Microsoft System Center MVP and a recognized leader in Core Infrastructure Design, System Center, Azure, and IT Management. His blog: http://www.concurrency.com/blog/author/nlasnoski/

Microsoft MVP S...

Read More

Windows Server 2003 Support Coming back to DPM 2012 R2

There have been some grumblings since the release of DPM 2012 R2 as it dropped support for Windows Server 2003 even though Windows Server 2003 is still supported by Microsoft. You can see a glimpse of the communities feedback on this at this TechNet thread:

http://social.technet.microsoft.com/Forums/en-US/c425421b-b726-4125-82fc-beae8947722c/dpm-2012-r2-agent-update-on-windows-2003-server-x64?forum=dpmsetup

Many environments out there (and usually not by the choice of the IT staff) still have Windows Server 2003 footprints in their environments. DPM 2012 R2 not supporting backup of Windows Server 2003 is a big problem. Many companies still run line of business applications on that OS.

There is good news today...

Read More

SYSTEM CENTER METRO ICONS

There is a cool new download on TechNet gallery of metro icons for System Center. There is an icon for every application in the suite. These can be used in Visio diagrams or other documentation for System Center. There even is an icon for Provance, Gridpro, and MBAM. Maybe we will see a Cireson and other third party vendor icons added in the future? Here is what the current icons look like:

image

Download link: http://gallery.technet.microsoft.com/System-Center-Metro-Icons-f220d543

Read More

Free Hyper-V and System Center Training from MVA

More free training coming soon on Hyper-V and System Center from Microsoft Virtual Academy (www.MicrosoftVirtualAcademy.com). This is going to be one event you don’t want to miss. I am also happy to announce I(@Buchatech) will also be a part of this event answering questions during the System Center 2012 R2 Datacenter session. Here is the list of what will be covered:

Details about the event:

If you’re new to virtualization, or if you have some experience and want to see the latest R2 features of Windows Server 2012 Hyper-V or Virtual Machine Manager, join us for a day of practical (and free!) online training. Learn how to build your infrastructure from the ground up on the Microsoft stack, using System Center to provide powerful management capabilities...

Read More

Monitor Scheduled Tasks with SCOM

Recently I was on a search for a management pack that would let me monitor Scheduled Tasks on Windows servers. A fellow System Center MVP Daniele Grandini let me know that his company Progel has one available. Progel has made the management pack available to the community for free that can monitor Scheduled Tasks on Windows Servers. It supports versions 2000, 2003, 2008, 2012, and 2012 R2. The Progel Windows Scheduled Tasks management packs monitor the performance, health, and availability of scheduled tasks. Even though this is a free management pack Progel even offers paid support if you need it.

Here are some screenshot from the management pack:

clip_image001

clip_image002

clip_image003

It can be downloaded here:

http://pinpoint.microsoft...

Read More