• You can use powershell to execute a script on multiple servers. This article shows how to do this, populating an excel worksheet with information on failed jobs: http://www.mssqltips.com/tip.asp?tip=1798

    I modified that script, adding sheets showing backups, database data file space, and recent lines in the error log, filtering out mundane messages. Failed jobs, failed backups and data files with less than a certain percentage of free space are in red.

    I then scheduled a job executing this script each morning before I come in, resulting in a quick summary of our servers.