PowerShell: 1-Liner to Discover SQL Servers on the Network

Run this command on server with SQL CLI installed (this will only detect SQL servers that has the SQL Service Discovery enabled)

PS C:\Windows\system32> [System.Data.Sql.SqlDataSourceEnumerator]::Instance.GetDataSources()

ServerName InstanceName IsClustered Version
---------- ------------ ----------- -------
TESTSQL01 SQLEXPRESS No 14.0.1000.169
TESTSQL02 SQLEXPRESS No 12.0.2000.8
TESTSQL02 SQLEXPRESS01 No 14.0.1000.169
TESTSQL02 SWPDM No 12.0.4100.1

Leave a Reply

Your email address will not be published. Required fields are marked *