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 🙁