Up to now, I am using this, but it only provides vm name and job name.
Code: Select all
Get-VBRRestorePoint | select name, {$_.FindSourceJob().name} | Export-Csv c:\temp\RestorePoints\result.csv
Code: Select all
Get-VBRRestorePoint | select name, {$_.FindSourceJob().name} | Export-Csv c:\temp\RestorePoints\result.csv
Code: Select all
$ErrorActionPreference = "SilentlyContinue"
$jobs = Get-VBRJob
$backups = Get-VBRBackup
foreach ($job in $jobs) {
$backup = $backups | where {$_.JobId -eq $job.Id}
$childBackups = $backup.FindChildBackups()
foreach ($child in $childBackups) {
$lastRp = Get-VBRRestorePoint -Backup $child | sort -Property CreationTime -Descending | select -First 1
$lastRp | select @{n='LastRestorePointId';e={$lastRp.Id}}, @{n='JobName';e={$job.Name}}, Type
}
}
Code: Select all
$RPReport = [System.Collections.Generic.List[PSObject]]@()
$RPs = Get-VBRRestorePoint | Sort-Object -Property BackupID, CreationTime -Descending
Foreach($r in $RPs){
$JobName = (Get-VBRBackupSession -ID $r.JobRunID).JobName
$RPReportData = [PSCustomObject]@{
JobName = $JobName
RestorePointID = $r.id
VMName = $r.VMName
CreationTime = $r.CreationTime
}
$RPReport.Add($RPReportData)
}
Code: Select all
$ErrorActionPreference = "SilentlyContinue"
$RPReport = [System.Collections.Generic.List[PSObject]]@()
$RPs = Get-VBRRestorePoint | Sort-Object -Property BackupID, CreationTime -Descending
Foreach($r in $RPs){
$JobName = (Get-VBRBackupSession -ID $r.JobRunID).JobName
$RPReportData = [PSCustomObject]@{
JobName = $JobName
RestorePointID = $r.id
VMName = $r.VMName
CreationTime = $r.CreationTime
}
$RPReport.Add($RPReportData)
}
$AllJobNames = $RPReport.JobName | Sort-Object -Unique
Foreach($jn in $AllJobNames){
$JobRPs = $RPReport | Where-Object {$_.JobName -eq $jn}
$RPGroup = $TestRP | Group-Object -Property VMName
$RPGroup | Select Name, Count, @{n='Job Name';e={$jn}}
}
Code: Select all
Name Count Job Name
---- ----- --------
ddom-tinyvm_replica 111 ddom-test
ddom-tinyvm 112 ddom-test
ddom-tinyvm_replica 111 ddom-tinyvm_2023-04-26T151641
ddom-tinyvm 112 ddom-tinyvm_2023-04-26T151641
ddom-tinyvm_replica 111 ddom-tinyvm_2023-04-26T152525
ddom-tinyvm 112 ddom-tinyvm_2023-04-26T152525
ddom-tinyvm_replica 111 ddom-tinyvm_2023-04-26T152743
ddom-tinyvm 112 ddom-tinyvm_2023-04-26T152743
ddom-tinyvm_replica 111 ddom-tinyvm_2023-08-11T121553
ddom-tinyvm 112 ddom-tinyvm_2023-08-11T121553
ddom-tinyvm_replica 111 ddom-tinyvm_2023-08-11T121655
ddom-tinyvm 112 ddom-tinyvm_2023-08-11T121655
ddom-tinyvm_replica 111 ddom-tiny-vm-offload-manual
ddom-tinyvm 112 ddom-tiny-vm-offload-manual
ddom-tinyvm_replica 111 gfs-direct-test
ddom-tinyvm 112 gfs-direct-test
ddom-tinyvm_replica 111 gfs-direct-test_clone1
ddom-tinyvm 112 gfs-direct-test_clone1
ddom-tinyvm_replica 111 gfs-test_clone1
ddom-tinyvm 112 gfs-test_clone1
ddom-tinyvm_replica 111 quick-encrypt
ddom-tinyvm 112 quick-encrypt
ddom-tinyvm_replica 111 script-test
ddom-tinyvm 112 script-test
ddom-tinyvm_replica 111 sstest
ddom-tinyvm 112 sstest
ddom-tinyvm_replica 111 vmware-direct-objstg
ddom-tinyvm 112 vmware-direct-objstg
ddom-tinyvm_replica 111 vmware-ffi-cap-bb
ddom-tinyvm 112 vmware-ffi-cap-bb
ddom-tinyvm_replica 111 vmware-per-job
ddom-tinyvm 112 vmware-per-job
Users browsing this forum: No registered users and 12 guests