PowerShell script exchange
Post Reply
Stabz
Veeam Legend
Posts: 131
Liked: 11 times
Joined: Apr 07, 2017 7:40 am
Full Name: Philippe DUPUIS
Contact:

Report of tenants disk usage SOBR

Post by 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
Veeam Software
Posts: 2010
Liked: 670 times
Joined: Sep 25, 2019 10:32 am
Full Name: Oleg Feoktistov
Contact:

Re: Report of tenants disk usage SOBR

Post by 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
Veeam Legend
Posts: 131
Liked: 11 times
Joined: Apr 07, 2017 7:40 am
Full Name: Philippe DUPUIS
Contact:

Re: Report of tenants disk usage SOBR

Post by 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
Veeam Software
Posts: 2010
Liked: 670 times
Joined: Sep 25, 2019 10:32 am
Full Name: Oleg Feoktistov
Contact:

Re: Report of tenants disk usage SOBR

Post by 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
Post Reply

Who is online

Users browsing this forum: No registered users and 9 guests