PowerShell script exchange
Post Reply
paul777
Novice
Posts: 9
Liked: never
Joined: Feb 21, 2016 9:07 pm
Full Name: Paul
Contact:

V PS Script to get 30 day storage totals for each VM

Post by paul777 »

Hello All,

I am trying to get the 30 day total (.vib and .vbk) for each VM. I can get the data from the VeeamOne Veeam Veeam Backup Capacity Planning\Backup Files Growth report, but it gives the daily storage with the total on the last day of the 30 days.

I am trying to get the output of one row for each VM that shows the 30 day total (which is the last day of the 30 days). For most VM's we do weekly Active Fulls or Synthetic Fulls so the 30 days usually has 4 Fulls in it. Thanks for any help.
veremin
Product Manager
Posts: 20415
Liked: 2302 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: V PS Script to get 30 day storage totals for each VM

Post by veremin »

Are you using per-VM backup chains or not? Thanks!
paul777
Novice
Posts: 9
Liked: never
Joined: Feb 21, 2016 9:07 pm
Full Name: Paul
Contact:

Re: V PS Script to get 30 day storage totals for each VM

Post by paul777 »

Per VM BU on 9.5. I can see the daily total per VM in the VeeamOne report but I'd have to copy the last day for each (of 1000 VM's) to have one row for each VM. The VeeamOne report has 30 rows for each VM. Thanks
veremin
Product Manager
Posts: 20415
Liked: 2302 times
Joined: Oct 26, 2012 3:28 pm
Full Name: Vladimir Eremin
Contact:

Re: V PS Script to get 30 day storage totals for each VM

Post by veremin »

You can get backup file names and their sizes, using this script:

Code: Select all

(Get-VBRBackup | where {$_.info.jobname -eq "Name of your backup job"}).GetAllStorages() | select {$_.PartialPath}, {$_.Stats.BackupSize/1GB}
Then, you will need to group files belonging to the same VM (use name as a grouping filter) and sum up their sizes.

Thanks!
paul777
Novice
Posts: 9
Liked: never
Joined: Feb 21, 2016 9:07 pm
Full Name: Paul
Contact:

Re: V PS Script to get 30 day storage totals for each VM

Post by paul777 »

I'm going to try it and report back soon. Thanks !
Post Reply

Who is online

Users browsing this forum: No registered users and 15 guests