Automating compilation of backup reports.
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,