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

[KingKRool]

Thanks for your reply David, I get an error on the GetAllChildrenStorages part of the script, other than that the script seems to be fine
(error is Cannot call a method on a null-valued expression)
So theres no children storage? either way I'll play around with other plug ins on that part

For Veeam One it only looks like i can download a trial, is there a way i can get this as part of the enterprise license my org has or is this a separate feature?

[david.domask]

Happy to help King,

If GetAllChildrenStorages returned a null-value error, means that $agentBackups was not populated with a backup. Check the name you provided and check the variable by simply writing $agentBackup in the shell and checking if it has any results.

As for Veeam One, depends on your license package. It would be best to open a Support Case to review your license options.

[brithelm]

I made a powershell script that runs on a local repo that emails me table with a summary of each folder that looks like this:

Client Storage
client one 730.36 GB
client two 1639.31 GB
And so on

It has some parameters for email stuff and which folders the repos are in.
If you are interested i can post the script here