Script not returning all VM in backups

[jmertensnetuk]

Hi All,

Below returns some information I want, my aim is to search all backup (primary main backup jobs of which there are 6) and print out the VMName and latest creationtime.

However when I run the below script it only returns back about half the VM's that are in the backup files it is skipping some jobs completly and therefore the VM's inside those jobs.

Code: Select all

Add-PSSnapin VeeamPSSnapin
$jobs = Get-VBRBackup | where {$_.JobType -eq "Backup"}

ForEach ($job in $jobs) {
Get-VBRRestorePoint -Backup $job | Sort-Object –Property CreationTime –Descending | Select VMName, CreationTime -First 1
}

I am new to this so I have probably done something obvious wrong

[veremin]

Try this example:

Code: Select all

Add-PSSnapin VeeamPSSnapin
$VMs = Get-VBRJob | where {$_.JobType -eq "Backup"} | Get-VBRJobObject
Foreach ($VM in $VMs)
{
    Get-VBRRestorePoint -ObjectId $VM.ObjectId | sort creationtime -Descending | Select -First 1 | Select VMName, CreationTime
}

Thanks!

[jmertensnetuk]

Hello veremin,

Perfect this seems to do it.

If i wanted to output this to a .txt file for example what would be required?

[veremin]

Out-File cmdlet will help you with that. Thanks!