none
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



    RajKumar

    Monday, March 14, 2016 4:55 PM

All replies

  •                                              

    Hi,

    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]
                $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)
                {
                    $status='Critical'

                } else
                {
                    $status='Ok'
                }

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

                $cmd.ExecuteNonQuery()                 

        }
     }


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