Automating backup reporting

[gklok]

In my work environment, we use BE on Win2K Advanced Server with SQLServer2000 as well. We've written apps & scripts to aid in our daily task of server maintanence and checks. Currently we finished half of our backup reporting tools. We are able to query all our SQL servers that perform their own backups (.log & .bak), but now our attention is on Backup Exec backups.

We would ultimately like to encorporate some method for reporting whether a job was successful, whether it failed, etc. Granted this information is easy to find in BE, but that requires human intervention. If you know of anyway to grab this information such that I could pump it into a DB or even into an Excel spreadsheet, that would be great.

Thank you for your time.

 

[Zelandakh]

Why not get BE to email you for success or failure - then you can specify further info you require in the failure reports...

 

[gklok]

E-mailing the report will still require a certain amount of human intervention to view the e-mail and then enter it into a DB or an Excel spreadsheet.

Your idea might be utilized in the interim, thank you. However, that does not solve our task at hand. If you or anyone else knows of a way to grab the logs and pump the data, or to have BE pump the data directly, that would be great. Code examples would be just marvelous. Thanks.

 

[Zelandakh]

Not emailing the report, but sending an email detailing whether it worked or not. I have Outlook move all emails from our backup servers to my backups folder. First thing in a morning as I get into email, I have one new email in there for each backup routine (including SQL dumps to disk) and the subject is either succeeded or failed.

That or share out the logs folder of BE on each server and because they are named sequentially, have Excel pick them up based on today's date.

Depends what sort of reporting you want.