none
Is there a Powershell Script that one can run on ones network to find all the SQL Server databases and the Instances that they are on? RRS feed

  • General discussion

  • Is there a Powershell Script that one can run on ones network to find all the SQL Server databases and the Instances that they are on?

    lcerni

    • Changed type Bill_Stewart Friday, January 26, 2018 3:15 PM
    • Moved by Bill_Stewart Friday, January 26, 2018 3:15 PM This is not "research solutions for me" forum
    Wednesday, December 6, 2017 5:51 PM

All replies

  • Please read this first:

    This forum is for scripting questions rather than script requests


    -- Bill Stewart [Bill_Stewart]

    Wednesday, December 6, 2017 6:03 PM
  • Sorry. I was rushing when I wrote the question. Trying to do to many things at the same time. I don't want someone to do it for me. I would like if someone could point me to a web page to read if there is one out there. I have been trying to search the web and all I am finding is how to get the server instances on the network. I am more interested in finding the databases within the instance on the network.

    lcerni

    Wednesday, December 6, 2017 6:30 PM
  • Your question is a very complicated issue.  THis can be done if your network is designed to allow it.  This requires the SQLBrowser service to be running and the use of SMO to query the network.

    Post in SQLServer developers forum to learn how to do this.

    You can also install DBATools for SMO specific CmdLets.

    find-module dbatools


    \_(ツ)_/

    Wednesday, December 6, 2017 7:28 PM