Question: Do you have any powershell code listing the sql server instances running on a server host. The aim is to report on the service status. The script should cover multiple instances on a server.

Answer: This powershell script can execute on a server, returning all SQL Server instances . The script utilises the Get-Service cmdlet. Customise the script to various search parameters. In the example below, I'm using MSSQL$ , MSSQLSERVER and SQL Server.

You'll be thinking about whether you'd prefer to run the script directly on the server or execute remotely. Powershel Get-Service can access remote servers - Powershell script - Get the SQL Server Instance status with Get-Service . So with a few minor tweaks to the script about it is possible to run this script from a local script repository and call remote servers.

You could even go one step further and iterate through a whole list of servers.