Daily Status Report for all DPM Servers RRS feed

  • Question

  • hi Team,

    We have 4 DPM 2012 r2 Servers in our environment and we configured the default status report to send us on daily basis which is working fine.

    we are getting all 4 daily status reports.

    we would like consolidate in such a way that all 4 reports are combined in to one report instead of 4 reports.

    brief about our environment

    4 individual DPM servers with  individual databases on their local servers. (4 different databases)

    please suggest


    Monday, March 14, 2016 4:55 PM

All replies



    I did my own solution for this problem:
    1) scheduled powershell script gets last recovery points from all DPM servers every morning and inserts to SQL 
    2) SQL report + subscription mail 8:00 for admins team

    My script not prepared for universal use, but I can show main script part:

    $pg = Get-ProtectionGroup -DPMServerName $DPMServerName
    for($pgi=0;$pgi-le $pg.length-1;$pgi++) 
        $ds = Get-Datasource -ProtectionGroup $pg[$pgi] | Sort-Object computer, name  
        for($dsi=0;$dsi-le $ds.length-1;$dsi++) 
                $rp = Get-RecoveryPoint -Datasource $ds[$dsi]
                $rpi= $rp.length-1
                $time = "{0:yyyy-MM-dd HH:mm:ss}" -f $rp[$rpi].RepresentedPointInTime

                IF( $rp[$rpi].RepresentedPointInTime -lt $time_yesterday)

                } else

                $cmd.CommandText ="INSERT dpm_rp_status VALUES ('"+$DPMServerName+"', '"+$pg[$pgi].FriendlyName+"','"+ $time+"','"+ $ds[$dsi].computer+"','"+ $ds[$dsi].Name+"','"+ $status+"','"+ $status_time+"','"+$today+"')"



    • Edited by Gerardas Wednesday, March 16, 2016 11:26 AM
    Wednesday, March 16, 2016 11:26 AM