A Powershell script has been prepared to address this issue. The script has the limitation of assuming that all agents are protected with just one protection group. However, this is the most common situation. If the need arises, it can be extended to get the last recovery point for all the protection groups for each agent.
The script receives a parameter which is the path of the file to record the results. By default this is "c:\temp\LastRP.txt". The report file is opened automatically after the script is executed.
The code is presented below between horizontal lines and attached to the KB.
_______________________________________________________________________
<#
.Synopsis
Newest Recovery Points List
.Description
Creates a list of the newest recovery points for each protected agent on the core
.Parameter file
default value c:\temp\LastRP.txt
.Example
.\newestRPs -file <desiredpath>
#>
param ($file="c:\temp\LastRP.txt")
$reportdate=Get-date
$title = "Newest Recovery Points as of $($reportdate.ToString("MMMM dd yyyy"))"
$uline = "-" * $title.length
Write-Host "`r`n`r`n$title`r`n$uline"
$agents = get-protectedservers | sort-object -property displayname | select-object displayname
$RPs = @()
foreach ($agent in $agents){
Write-host "Getting info for <$($agent.displayname)>" -f Yellow
$r = get-recoverypoints -protectedserver ($agent.displayname) -number l1 #-ErrorAction SilentlyContinue
$z = $r | Select-Object -property AgentHostName,DateTimeStamp,Status,Number,AgentVolumes
$RPs +=$z
}
"--------------------------------------"
$RPs | ft -AutoSize -Wrap
$title > $file
$RPs | ft -AutoSize -Wrap | out-string >> $file
Invoke-Item $file
_______________________________________________________________________