Backup storage reporting

[jround]

We are undertaking a review of our backup storage as we need to build a business case for potential future options cloud / air gap

What we need to do is produce a report of all our VMs, how much space their backups currently take up on disk so we can split them down into live VMs / test VMs

Through Veeam it is easy enough to report on repository total size, used space, free space but not an easy way to dig down into a per VM basis and export a report

Are there any possible solutions? Veeam One perhaps? (I suspect we wouldn't get funding for this at the moment however so either the 30 day trial or community edition but I think that would only cover 10 VMs?)

I could of course just go into Windows file explorer and report on the repository folder sizes for each backup but that starts to get confusing as individual VM backups can be spread out across multiple volumes due to us using SOBR

[HannesK]

Hello,
I guess some people will come up with some powershell scripts, so I leave the topic in the VBR section of the forum.

In general, you are right, Veeam ONE is the way to go. Some reports come up into my mind first
- Backup Billing https://helpcenter.veeam.com/docs/one/r ... ml?ver=100
- Backups on Repository https://helpcenter.veeam.com/docs/one/r ... ml?ver=100

The trial should cover more than 10 VMs (when I did a trial for the last time it was 32 sockets)

Best regards,
Hannes

[oleg.feoktistov]

When it comes to Powershell, you can start with the script below:

Code: Select all

 $backups_stat = @()
$jobs = Get-VBRJob
foreach ($job in $jobs) {
    $backup = Get-VBRBackup -Name $job.Name
    $repo = $backup.GetRepository()
    $files = $backup.GetAllStorages()
    if ($repo.Type -eq 'ExtendableRepository') {
    foreach ($file in $files) {
        $backups_stat += $file | select FilePath, @{n='Backup Size';e={$_.Stats.BackupSize}}, `
        @{n='Data Size';e={$_.Stats.DataSize}}, @{n='Repository';e={$repo.Name}}, `
        @{n='Repository Type';e={'Scaleout'}}
   }
}
   else {     
   
        foreach ($file in $files) {

        $backups_stat += $file | select FilePath, @{n='Backup Size';e={$_.Stats.BackupSize}}, `
        @{n='Data Size';e={$_.Stats.DataSize}}, @{n='Repository';e={$repo.Name}}, `
        @{n='Host Name';e={$repo.Host.Name}}, @{n='Repository Type';e={$repo.Type}}
      }
    }
  }

Cheers!