I am looking for a query that I can perform each day to determine the success of the backups from the night before. I have 10 servers and do not want to have to have to check each individually. Email notification doesn't always work, so that's not so reliable. ExecView carries it's own problems (at least for me).
Any help would be appreciated.