With this simple script, you will be able to get the server names on which the MS SQL Server service is installed.
First, an array is built with the computer names and the following properties :
The cmdlet Get-service is used to query all the servers
Find more powershell scripts here
Powered by IDERA