Daily Autocheck for SQL instances

• mtz676

  SSCrazy Eights

  Points: 9217

  More actions

  May 9, 2021 at 7:39 am

  #3881085

  [System.Data.Sql.SqlDataSourceEnumerator]::Instance.GetDataSources() | SELECT ServerName | Format-Table -HideTableHeaders

  The above code is not returning all instances within a domain.

  There is not a lot available here.https://docs.microsoft.com/en-us/dotnet/api/system.data.sql.sqldatasourceenumerator?view=netframework-4.8

  Are there any prerequisites ...to enable/disable (on servers)  for the above code to list all instances within a domain ?

  Thanks

• Site Owners

  SSC Guru

  Points: 80325

  More actions

  May 10, 2021 at 8:10 am

  #3881345

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.