V PS Script to get 30 day storage totals for each VM

[paul777]

Hello All,

I am trying to get the 30 day total (.vib and .vbk) for each VM. I can get the data from the VeeamOne Veeam Veeam Backup Capacity Planning\Backup Files Growth report, but it gives the daily storage with the total on the last day of the 30 days.

I am trying to get the output of one row for each VM that shows the 30 day total (which is the last day of the 30 days). For most VM's we do weekly Active Fulls or Synthetic Fulls so the 30 days usually has 4 Fulls in it. Thanks for any help.

[veremin]

Are you using per-VM backup chains or not? Thanks!

[paul777]

Per VM BU on 9.5. I can see the daily total per VM in the VeeamOne report but I'd have to copy the last day for each (of 1000 VM's) to have one row for each VM. The VeeamOne report has 30 rows for each VM. Thanks

[veremin]

You can get backup file names and their sizes, using this script:

Code: Select all

(Get-VBRBackup | where {$_.info.jobname -eq "Name of your backup job"}).GetAllStorages() | select {$_.PartialPath}, {$_.Stats.BackupSize/1GB}

Then, you will need to group files belonging to the same VM (use name as a grouping filter) and sum up their sizes.

Thanks!

[paul777]

I'm going to try it and report back soon. Thanks !