Report of tenants disk usage SOBR

[Stabz]

Hello guys,

I m working for a service providers, we need to calculate disk space usage for each tenant.

We use SOBR for the backup storage.

I found this script in a topic:

Code: Select all

Get-VBRBackup | Select @{N="Job Name";E={$_.Name}}, @{N="Size (GB)";E={[math]::Round(($_.GetAllStorages().Stats.BackupSize | Measure-Object -Sum).Sum/1GB,1)}} | Format-Table -AutoSize

This script give me the utilization for " Classic Backup repository" but not for the object storage in my SOBR.

I did'nt find yet how to find this value. For me in the object storage it should be the same value but I'm not sure about that.

After that my tenant could have more that one backup job so I have to find a solution to addition all backup jobs for one client...

Help would be much appreciate

[oleg.feoktistov]

Hi Philippe,

Can you, please, elaborate on your goal? Is it to find the total size of backups on all SOBR extents including object storage or only on object storage?

Best regards,
Oleg

[Stabz]

Hello Oleg,

I need a CSV file with this informations:
Customer Name | Job Description | Repository Used in GB | Object Used GB | Total Size

I need the total size of backups on all SOBR extents including object storage.

Regards
Philippe

[oleg.feoktistov]

Hi Philippe,

Please check the code sample I provided here, it should get you started. You can then adjust that query to also return storage sizes like in the line you shared in this thread. The problem, however, arises with copied storages. We cannot obtain their dehydrated sizes through powershell unless going with SQL directly to Backup.Model.StorageCopies table.

Best regards,
Oleg