Need a script to get size of the last successful full backup of each NBU client

Question

Hello,I'm running NBU 7.7.2 on a Windows 2012 R2 Server, and I'm after a script which can email me a spreadsheet each month showing me the size of the last successful full backup for each client (partial backups included). Is something like this possible?I also have OPS Centre Analytics if there is any SQL magic that can be done on that.&nbsp;Example:Client&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Last Successfull Full Backup date &nbsp; &nbsp; &nbsp;&nbsp; Last Successful Full Backup Size(GB)------------------------------------------------------------------------------------------------------------------------Client 1&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 18/08/2016&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;&nbsp; 100Client 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; 13/08/2016 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp;&nbsp; 85Client 3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 14/07/2016&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; 90

dg-2005 · Answer

using bpimagelist you can gather that data, assuming pre deduplication as well.

something like this may do what you are looking for the gathering piece.

https://github.com/dgroeschen/NBUChecks/blob/master/audit_Last_Full.ps1

Forum Discussion

Need a script to get size of the last successful full backup of each NBU client

1 Reply

Related Content

IT Analytics - Backup Success Rate Percentage past 24 hours

enterprise vault elastic search index snapshot automatic backup script

Backup of passive node with script

Partial success backup almost daily

Re: ORA-12546: TNS:permission denied after moving to new server

Recent Discussions

"failed, status 6" error after increasing datastore (LUN) capacity

command: bperror

MS-SharePoint policy restore error (2804) .

How to restore a backup

How to configure RBAC