Scanning to find sql instances/servers

• mtz676

  SSCrazy Eights

  Points: 9212

  More actions

  November 4, 2020 at 6:15 pm

  #3804326

  We use MAPS tool to scan through our domain and then list out our sql servers/instances.

  How can this be achieved using powershell ?

  Thanks

• Michael L John

  One Orange Chip

  Points: 27054

  More actions

  November 4, 2020 at 6:33 pm

  #3804337

  I googled this: "Powershell determine if SQL is installed"

  This looked like a good result

  https://mikerodionov.com/2019/04/powershell-script-detect-installed-sql-server-version-and-switch-to-appropriate-setup-directory/

  As well as this:

  https://docs.microsoft.com/en-us/powershell/module/sqlserver/get-sqlinstance?view=sqlserver-ps

  Michael L John
  If you assassinate a DBA, would you pull a trigger?
  To properly post on a forum:
  http://www.sqlservercentral.com/articles/61537/