{"id":4672,"date":"2020-05-21T05:06:18","date_gmt":"2020-05-21T05:06:18","guid":{"rendered":"https:\/\/pariswells.com\/blog\/?p=4672"},"modified":"2022-12-02T03:19:38","modified_gmt":"2022-12-02T03:19:38","slug":"calculating-previous-job-rate-of-change-as-well-as-averaging-history-in-powershell","status":"publish","type":"post","link":"https:\/\/pariswells.com\/blog\/research\/calculating-previous-job-rate-of-change-as-well-as-averaging-history-in-powershell","title":{"rendered":"Calculating Veam Previous Job Rate of Change as well as Averaging History in Powershell"},"content":{"rendered":"\n

Report % Rate of change from the last Backup Job Run<\/p>\n\n\n

\n\t
Add-PSSnapin -Name VeeamPSSnapIn -ErrorAction SilentlyContinueDisconnect-VBRServer | out-nullconnect-vbrserver -server localhost$JobsOutput = @()Foreach ($JobObject in Get-VBRJob | ?{$_.JobType -eq "Backup"}){$LastSession = $JobObject.FindLastSession()$ChangeRate = ($LastSession.Info.Progress.TransferedSize\/$LastSession.Info.Progress.TotalUsedSize)*100$JobOutput = New-Object -TypeName PSObject$JobOutput | Add-Member -Name "Jobname" -MemberType Noteproperty -Value $JobObject.Name$JobOutput | Add-Member -Name "Endtime" -MemberType Noteproperty -Value $LastSession.endtime$JobOutput | Add-Member -Name "TotalUsedSize" -MemberType Noteproperty -Value $LastSession.Info.Progress.TotalUsedSize$JobOutput | Add-Member -Name "ReadSize" -MemberType Noteproperty -Value $LastSession.Info.Progress.ReadSize$JobOutput | Add-Member -Name "TransferedSize" -MemberType Noteproperty -Value $LastSession.Info.Progress.TransferedSize$JobOutput | Add-Member -Name "ChangeRate" -MemberType Noteproperty -Value $ChangeRate$JobsOutput += $JobOutput}$JobsOutput | Out-GridViewDisconnect-VBRServer | out-null<\/code><\/pre> 
 <\/div> <\/div><\/div>\n\n\n\n
However one result is not a fair estimate of rate of change , and I don\u2019t have a Veeam One license so I decided to Average Stuff<\/p>\n\n\n\n
You can run on One VM or all the VM\u2019s in a Backup Job<\/p>\n\n\n
\n\t
 
Add-PSSnapin -Name VeeamPSSnapIn -ErrorAction SilentlyContinueconnect-vbrserver -server localhost#Query to get all jobs in the time period in hours that have processed data (Data ne 0 ) and have completed$vbrtasksessions = (Get-VBRBackupSession |Where-Object {($_.EndTime -ge (Get-Date).addhours(-168) -or $_.CreationTime -ge (Get-Date).AddHours(-168) -or $_.State -eq "Working")}) | Get-VBRTaskSession | Where-Object {$_.Status -notmatch "Idle|InProgress|Pending|Fail"-and $_.Info.Progress.TotalSize -ne "0"}#Get Backup Job and VM#$getOne = $vbrtasksessions | ? {$_.JobName -eq "%Veeam Backup or Backup Copy Name%" -and $_.Name -eq "%Name of Server%"}#Or Get Whole Backup Job and average between all the machines#$getOne = $vbrtasksessions | ? {$_.JobName -eq "%Veeam Backup or Backup Copy Name%"}#Cannot Get Total usedSize in BackupEcho ListofAllFullSizesInBytes $getOne.Info.Progress.TotalSize#Echo AverageTotalFullBackupSizeInGB $([Math]::Round([Decimal]($getOne.Info.Progress.TotalSize | Measure-Object -Average).Average\/1GB, 2))Echo ListofIntcrementalSizeinBytess $getOne.Info.Progress.TransferedSize#Echo AverageIntSizeinGB $([Math]::Round([Decimal]($getOne.Info.Progress.TransferedSize | Measure-Object -Average).Average\/1GB, 2))Echo RateofChangein% ((($getOne.Info.Progress.TransferedSize | Measure-Object -Average).Average\/($getOne.Info.Progress.TotalSize | Measure-Object -Average).Average)*100)Disconnect-VBRServer | out-null<\/code><\/pre> 
 <\/div> <\/div><\/div>\n","protected":false},"excerpt":{"rendered":"
Report % Rate of change from the last Backup Job Run However one result is not a fair estimate of rate of change , and I don\u2019t […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[3274,1120,576,3273,739],"class_list":["post-4672","post","type-post","status-publish","format-standard","hentry","category-research","tag-caculate","tag-history","tag-powershell","tag-rate-of-change","tag-veeam"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts\/4672","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/comments?post=4672"}],"version-history":[{"count":3,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts\/4672\/revisions"}],"predecessor-version":[{"id":6466,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/posts\/4672\/revisions\/6466"}],"wp:attachment":[{"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/media?parent=4672"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/categories?post=4672"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pariswells.com\/blog\/wp-json\/wp\/v2\/tags?post=4672"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}