08-18-2016 10:10 PM
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.
Example:
Client Last Successfull Full Backup date Last Successful Full Backup Size(GB)
------------------------------------------------------------------------------------------------------------------------
Client 1 18/08/2016 100
Client 2 13/08/2016 85
Client 3 14/07/2016 90
08-19-2016 05:02 AM - edited 08-19-2016 05:04 AM
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