Get database statuses with powershell

01_Vault_101_Citizenship_Award

Pipboy level utility!

So I’m learning Power-Shell in the hopes of automating daily DBA tasks across 10 physical servers.  Found this script while surfing the web and edited it with some changes that made my life easier.  It’s not pretty, but nicer to look at than console.

The script needs a txt file with a list of servers, the output is appended to an html file and then invoked.  Green means good, red means bad.

To do: I’m going to attempt and get it to work with central management server groups, and it would be also nice if in the case you cant connect to the database servers at all, it would error out and return a 🙁

Cheers

DatabaseStatus.ps1

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.