Automating compilation of backup reports.
Hi All,
I manage a distributed network of independent backup servers at approximately thirty (30) locations. The majority of these servers have Backup Exec v11d and a few have Backup Exec 2010R2 installed. All installations report success or failure of (backup) jobs by email, to a designated mailbox. The total number of jobs monitored is approximately one hundred and fifty (150). I currently collate this information manually, into a Excel spreadsheet. I convert the 'Success', 'Completed with Exceptions' and 'Failed' messages into coloured infills in the spreadsheet - green for success, amber for CwE, red for failed, blue for cancelled etc, to produce a 'traffic-light' display that highlights anomolies and trends over time. Compiling this spreadsheet daily is a multi-step process and while I utilise a couple of macros to automate some things, I'm really looking for a way to automate the entire process.
Is there a BE report that can be configured to produce output like I describe? or;
Is there a script or third-party application that can take the raw data (emails), extract the relevant data points and collate them into a spreadsheet?
Thanks in anticipation,
Paul
Paul, though this question is not directly associated to BE, you could try any software that helps monitor the Event Viewer. (Spiceworks has such a software). Every Job Success, Job failure, etc has a alert that is configurable. These alerts can also generate an event id in the Application log of the server.
The softwares like the one mentioned above use these event ids to generate automated reports. Here are a few links that might help -
http://community.spiceworks.com/topic/282231-can-spiceworks-monitor-and-generate-event-log-reports
http://community.spiceworks.com/topic/246732-event-log-management
...for 3rd party software to report from Backup Exec, I used Solarwinds Backup Profiler (now Storage Manager). That application really works well, and the reports are excellent too. You automatically get a dashboard-type report when logging on, and it has user-level security to allow certain users to access only specific sections of the application. I would recommend this.
You can run canned reports, or create your own and simply hit a "play" button that runs it for you.
Thanks!
