Find all stopped SQL Server services for all instances

$ErrorActionPreference = "Stop" #stop when an error is encountered
# Declare variables
$server = "."
$database = "Inventory"
$query = @"
SELECT DISTINCT [Environment], [ServerName]
  FROM [Inventory]
WHERE [Cluster] = 0
"@
$query2 = @"
SELECT DISTINCT [Environment], [ClusterName]
  FROM [Inventory]
WHERE [Cluster] = 1
"@
$SleepTimer = 1000 #after X milliseconds, check if the jobs have finished. 1000 is every second.
$MaxResultTime = 300 #after X seconds, all jobs are killed. 300 is 5 minutes.
$Maxthreads = 20 #number of parallel jobs
# import modules
Import-Module SqlPs -DisableNameChecking
Import-Module FailoverClusters
$error.clear() #clear error generated by last command
# get list of instances
$objects = @(Invoke-Sqlcmd -ServerInstance $server -Database $database -Query $query)
$clusters = @(Invoke-Sqlcmd -ServerInstance $server -Database $database -Query $query2)
# get node(s) for the clusters and add to the list of servers
foreach ($cluster in $clusters) {
   $services = Get-ClusterGroup -Cluster $cluster.ClusterName
   foreach ($service in $services) {
      if (!($service.Name -eq "Cluster Group") -And !($service.Name -eq "Available Storage")) {
         $found = 0
         for ($i = 0; $i -lt $objects.length; $i++) {
            if ($objects[$i].ServerName.StartsWith($cluster.ClusterName)) {
               $found = 1
               if (!$objects[$i].ServerName.contains($service.OwnerNode.Name)) {
                  $objects[$i].ServerName = $objects[$i].ServerName + " " + $service.OwnerNode.Name
               }
               break
            }
         }
         if ($found -eq 0) {
            $obj = New-Object -TypeName PSObject
            $obj | Add-Member -MemberType NoteProperty -Name Environment -Value $cluster.Environment
            $obj | Add-Member -MemberType NoteProperty -Name ServerName -Value "$($cluster.ClusterName) $($service.OwnerNode.Name)"
            $objects += $obj
         }
      }
   }
}
# environment setup
$output = @()
$errors = ""
$Jobs = @()
$ISS = [system.management.automation.runspaces.initialsessionstate]::CreateDefault()
$RunspacePool = [runspacefactory]::CreateRunspacePool(1, $MaxThreads, $ISS, $Host)
$RunspacePool.Open()
$script = {
   Param ([string]$environment, [string]$serverName)
   $ErrorActionPreference = "Stop"
   try {
      $firstSet = @()
      $final = @()
      if (!$serverName.contains(" ")) { # one server
         $firstSet = Get-Service -computername $serverName | where {$_.DisplayName -like "*SQL*" -and $_.Status -eq "Stopped"} | select @{Name="Environment";Expression={$environment}}, @{Name="ServerName";Expression={$serverName}}, @{Name="Service";Expression={$_.DisplayName}}, Status
      }
      else {
         $parts = $serverName.split(" ")
         if ($parts.count -eq 2) { # one active node in the cluster
            $firstSet = Get-Service -computername $parts[1] | where {$_.DisplayName -like "*SQL*" -and $_.Status -eq "Stopped"} | select @{Name="Environment";Expression={$environment}}, @{Name="ServerName";Expression={$parts[1]}}, @{Name="Service";Expression={$_.DisplayName}}, Status
         }
         else { # more than one active node in the cluster
            for ($i = 1; $i -lt $parts.count; $i++) {
               $secondSet += Get-Service -computername $parts[$i] | where {$_.DisplayName -like "*SQL*"} | select @{Name="Environment";Expression={$environment}}, @{Name="ServerName";Expression={$parts[$i]}}, @{Name="Service";Expression={$_.DisplayName}}, Status
            }
            $thirdSet = $secondSet | where {$_.Status -ne "Running"}
            for ($i = 0; $i -lt $thirdSet.count; $i++) {
               $running = $secondSet | where {$_.Service -eq $thirdSet[$i].Service -and $_.Status -eq "Running"} | measure
               if ($running.count -eq 0) {
                  $firstSet += $thirdSet[$i];
               }
            }
         }
      }
      $m = $firstSet | measure
      if ($m.count -gt 0) {
         foreach ($row in $firstSet) {
            $props = Get-WmiObject win32_service -computer $row.ServerName -filter "Name='$($row.Service)'"
            if (!$props -or ($props.StartMode -ne "Disabled")) {
               $final += $row | select Environment, ServerName, Service, Status, @{Name="StartMode";Expression={$props.StartMode}}
            }
         }
      }
      "" #indicate there was no error
      $final #return results
   }
   catch {
      return $environment + " " + $serverName + ": " + $LastExitCode + " " + $_ | foreach { $_.ToString() } | Out-String #Get-WmiObject error, maybe permissions
   }
}
function CreateThread() {
   param ([string]$environment, [string]$serverName, [ref]$Jobs)
   $PowershellThread = [powershell]::Create().AddScript($script) #scriptToRun
   $PowershellThread.AddArgument($environment) | out-null
   $PowershellThread.AddArgument($serverName) | out-null
   $PowershellThread.RunspacePool = $RunspacePool
   $Handle = $PowershellThread.BeginInvoke()
   $Job = "" | select Handle, Thread, object
   $Job.Handle = $Handle; $Job.Thread = $PowershellThread
   $Jobs.value += $Job
}
$ResultTimer = Get-Date #start time
#start processing first task for each instance
for ($i=0; $i -lt $objects.length; $i++) {
   CreateThread $objects[$i].Environment $objects[$i].ServerName ([ref]$Jobs)
}
while (@($Jobs | where {$_.Handle -ne $Null}).count -gt 0) {
   #update completed jobs, get errors and result, and dispose them
   foreach ($Job in @($Jobs | where {$_.Handle -ne $Null -and $_.Handle.IsCompleted -eq $True})) {
      $results = $Job.Thread.EndInvoke($Job.Handle)
      if ($results[0] -and $results[0] -ne "") {
         $errors += $results[0]
      }
      for ($i = 1; $i -lt $results.count; $i++) {
         $output += $results[$i]
      }
      #end thread
      $Job.Thread.Dispose()
      $Job.Thread = $Null
      $Job.Handle = $Null
   }
   #show progress
   $inProgress = @($Jobs | where {$_.Handle.IsCompleted -eq $False}).count
   Write-Progress `
      -Activity "Gathering data" `
      -PercentComplete (($objects.length - $inProgress) * 100 / $objects.length) `
      -Status "$inProgress pending"
   #exit on timeout
   $currentTime = Get-Date
   if (($currentTime - $ResultTimer).totalseconds -gt $MaxResultTime) {
      Write-Error "Child script appears to be frozen, try increasing MaxResultTime"
      break
   }
   #sleep
   Start-Sleep -Milliseconds $SleepTimer
}
#dispose thread pools
$RunspacePool.Close() | Out-Null
$RunspacePool.Dispose() | Out-Null
$errors #return errors
$output | Format-Table -Auto #return results