Export CSV of all backup job sizes?

[KingKRool]

Hello all, I have been searching for 2 days, trying scripts, trying to install the service provider etc

I cannot find a reliable way to get the individual PC backup sizes in 1 format. I am aware we can go see them in the Disk -> properties portion of the Backup/Replication console but we have 50 machine backup jobs to go through, there must be a way i can export the backup jobs sizes or script them? All methods I've found so far have not been successful (some looked like they can work but the articles are from 2012-16 and gives me a ton of errors in powershell)

Any help is appreciated, thank you!

[david.domask]

Hi KingKRool, welcome to the forums!

You're talking about Agent Backups?

Usually would recommend do this with Veeam One, for example the Backups on Repository report gives you very nice stats on this, but check the Pre-Defined Reports as there may be one closer to your expectations.

If you want to hand-roll it, the way to go about this is in PowerShell is:

Code: Select all

$agentBackups = Get-VBRBackup -Name "Name of backup"
$storages = $agentBackups.GetAllChildrenStorages()
$storageSizeReportData = @()
Foreach($s in $storages){
	$machineName = $s.GetOibs().Name
	$backupFileName = $s.PartialPath.Elements
	$backupFileSizeGb = $s.stats.BackupSize/1GB
	$creationDate = $s.CreationTime.ToString()
	$data = [PSCustomObject]@{
		Machine_name = $machineName
		Creation_date = $CreationDate
		Backup_file_name = $backupFileName
		Backup_file_sizeGB = $backupFileSizeGb
	}
	$storageSizeReportData += $data
	Remove-Variable data
	Remove-Variable machineName 
	Remove-Variable backupFileName 
	Remove-Variable backupFileSizeGb 
	Remove-Variable creationDate 
}

$storageSizeReportData | Sort -Property Creation_date -Descending | Export-CSV -NoTypeInformation C:\path\to\export.csv