My company is responsible for backups on a number of servers for one of our clients. The backup servers are all running Backup Exec 2010. At the end of each month we need to provide a report on how many jobs failed during the month, the reason etc. Currently our techs check a number of success/fail emails each day and record the results in a database. The monthly report then pulls the data from here.
What I am looking at doing now is automating the procedure of a human having to read the success/fail emails every day. Backup Exec allows you access to the SQL database it runs on so that is one way to go. The other would be to direct the success/fail emails to a mailbox and run a script to programatically parse the emails and get the stats that way.
Has anyone had any experience with something similar and can you offer any tips? My background is php/mysql and I will likely be using php to gather the data one way or the other. Thanks.