Get-Service is a command in PowerShell that returns a list of Services on a Computer.

This post is a quick guide on running this command in a PowerShell terminal, using a wildcard ( * ) to show me my services with “SQL” in the service name.

Get-Service *sql*

We can also amend the above to only show Services that are in a “Stopped” state.

Get-Service *sql* | Where-Object {$_.status -eq "Stopped"}