Need Powershell Script to Validate Server access RRS feed

  • Question

  • I am an experienced SQL Server developer. I have recently transitioned to a SS DBA role. I've inherited an inventory of over 200 servers. The information I have is not 100% correct. Some servers no longer exist, some have typos in their name, etc. I may or may not have permissions to access the servers.

    I would like to create a Power Shell script that could walk through all the servers in my inventory and do the following:

    Validate my access to the server by connecting with my AD credentials

    If validate, attempt to determine role of server: Is SQL up and running

    If SS running, which databases are present

    Do this for each server in my inventory and create a log or report showing the results.

    Does such a script already exist?

    Much thanks

    Tuesday, April 16, 2019 9:17 AM

All replies