none
Generate Report with Name of backed up Virtual machines and there status RRS feed

  • Question

  • Hi,

    I have configured default report of DPM to send me the  status of backed up machines everyday via email. However, that report just tells the number of successful or failed backup.

    I am looking for something in which we can get name of the machine along with its backup status. For example below:

    MachineName         BackupStatus         LastBackup(Date)

         VM1              Completed/Failed          21-Jan-2020 

    Could someone please help me with some script or other method with which I can get this kind of report on daily basis.

    Tuesday, January 21, 2020 9:54 AM

Answers

All replies

  • Hi,

    Unfortunately the builtin reports in DPM do not provide much information, you will likely have to create custom reports to achieve this, unless you are using Operations Manager (SCOM) to monitor your DPM environment, you can create better reports with the help of SCOM.

    Here's a few links to get you started on creating custom reports in DPM:

    daily Backup Report for SC DPM

    BUILDING CUSTOM REPORTS IN DPM

    DPM Backup Summary Report

    Best regards,
    Leon


    Blog: https://thesystemcenterblog.com LinkedIn:


    • Edited by Leon Laude Tuesday, January 21, 2020 10:21 AM
    • Marked as answer by SC2317 Monday, January 27, 2020 1:48 PM
    Tuesday, January 21, 2020 10:20 AM
  • Hi Leon,

    Many thanks, I believe "https://www.burkard.it/2015/11/daily-backup-report-for-sc-dpm/" could be helpful for me, However I have one issue while running DPM commands on Powershell.

    I can connect to DPM server via DPM Management shell without any issues. However, after running "Import-Module  DataProtectionManager" when I run the Connect-DPMServer -DPMServerName $DPMServer then I get below error.

    Connect-DPMServer : Unable to connect to $DPMServer.(ID: 948).

    I have restarted the DPM services as per error ID, however still the issue exists. Could you please suggest on how to make sure that when I run the script, it recognizes DPM commands. 

    I ran "C:\Program Files\Microsoft System Center\DPM\DPM\bin\DpmCliInitScript.ps1", which open DPM management shell in powershell, however still I get the same error when I connect to DPM server.

    Wednesday, January 22, 2020 12:28 PM
  • To connect to DPM the user needs permissions to DPM/SQL Server DPMDB. If the user account you are using can't connect to SQL, then you can get the error above.

    Blog: https://thesystemcenterblog.com LinkedIn:

    Wednesday, January 22, 2020 12:38 PM
  • Hi Leon,

    User account has permission and also same account is able to connect to DPM server via DPM Management shell.

    Wednesday, January 22, 2020 12:42 PM
  • Is the user also local admin on the DPM server?

    Make sure you run the PowerShell with run as administrator.


    Blog: https://thesystemcenterblog.com LinkedIn:

    Wednesday, January 22, 2020 12:44 PM
  • Hi Leon,

    Running powershell as an administrator working. I'll test by scheduling the script and see the results.

    Many thanks.

    Wednesday, January 22, 2020 4:37 PM
  • Hi Leon,

    Many thanks for you help. I have successfully been able to configure the report.

    Monday, January 27, 2020 1:48 PM