Leonard Rutkowski (10/21/2013)

---

Nice article. I have done something similiar, however, I use Powershell, and run a SQL job as needed. My table is very similiar to yours. When I add a new instance, I just add the server and instance name to the table, run the Powershell script, and let it update all of the columns in the table. I use the instance table to loop through all my instances to check for failed jobs, missing backups, integrity reporting, etc, scheduled through a central SQL Server that we use for monitoring and testing.

Leonard