我正在尝试从数千个订阅收集Azure SQL Server/Database（PaaS）信息。以下是我的脚本。

$SQLserver = [System.Collections.Concurrent.ConcurrentBag[psobject]]::new()
$subscriptions | Where-Object {$_.state -ne "Disabled" -and $_.State -ne "Warned"} | Foreach-Object -Parallel {
    $sub = $_
    $localSqlserver = $using:SQLserver
    $localSqlserver.Add($(
        Get-AzSqlServer -DefaultProfile (Set-AzContext -SubscriptionId $PSItem) | ForEach-Object -process {
        $sqlServerObj = $_
        $sqlServerObj | ForEach-Object -process {
            Get-AzSqlDatabase -ResourceGroupName $sqlServerObj.ResourceGroupName -ServerName $sqlServerObj.ServerName | ForEach-Object -process {
            $DBObj = $_
            $DBObj | Select-Object @{N='SubscriptionName'; E = {$sub.Name}},
            @{N='ResourceGroupName';E={$sqlServerObj.ResourceGroupName}},
            @{N='SQLServerName';E={$sqlServerObj.ServerName}},
            @{N='FQDN';E={$sqlServerObj.FullyQualifiedDomainName}},
            @{N='sqlServerResourceId'; E = {$sqlServerObj.ResourceId}},
            @{N='Location';E={$sqlServerObj.Location}},
            @{N='SqlAdministratorLogin';E={$sqlServerObj.SqlAdministratorLogin}},
            @{N='ServerVersion';E={$sqlServerObj.ServerVersion}},
            @{N='Identity';E={$sqlServerObj.Identity}},
            @{N='MinimalTlsVersion';E={$sqlServerObj.MinimalTlsVersion}},
            @{N='PublicNetworkAccess';E={$sqlServerObj.PublicNetworkAccess}},
            @{N='RestrictOutboundNetworkAccess';E={$sqlServerObj.RestrictOutboundNetworkAccess}},
            @{N='KeyId';E={$sqlServerObj.KeyId}},
            @{N='DBName';E={$DBObj.DatabaseName}},
            @{N='DBId';E={$DBObj.DatabaseId}},
            @{N='Edition';E={$DBObj.Edition}},
            @{N='CollationName';E={$DBObj.CollationName}},
            @{N='MaxSizeBytes';E={$DBObj.MaxSizeBytes}},
            @{N='Status';E={$DBObj.Status}},
            @{N='CurrentSize';E={$DBObj.CurrentServiceObjectiveName}},
            @{N='ElasticPoolName';E={$DBObj.ElasticPoolName}},
            @{N='ReadScale';E={$DBObj.ReadScale}},
            @{N='ZoneRedundant';E={$DBObj.ZoneRedundant}},
            @{N='Capacity';E={$DBObj.Capacity}},
            @{N='Family';E={$DBObj.Family}},
            @{N='SkuName';E={$DBObj.SkuName}},
            @{N='LicenseType';E={$DBObj.LicenseType}},
            @{N='CurrentBackupStorageRedundancy';E={$DBObj.CurrentBackupStorageRedundancy}},
            @{N='MaintenanceConfigurationId';E={$DBObj.MaintenanceConfigurationId}},
            @{N='EnableLedger';E={$DBObj.EnableLedger}}
            }}
        }
    ))
} -UseNewRunspace

虽然$SQLserver有对象集合，我仍然收到下面的错误消息，但我真的不明白真正的问题是什么，由于这个错误，它仍然不包含所有的信息。但对单个订阅运行脚本（从第6行开始）确实有效。
x一个一个一个一个x一个一个二个x
有人觉得剧本的逻辑有什么问题吗？