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