PowerShell Anzeige von WSUS-Updates nach Gruppen mit IDs

[reflection.assembly]::LoadWithPartialName("Microsoft.UpdateServices.Administration") | Out-Null  
#$updatescope.ApprovedStates = [Microsoft.UpdateServices.Administration.ApprovedStates]::NotApproved
#$updatescope.IncludedInstallationStates = [Microsoft.UpdateServices.Administration.UpdateInstallationStates]::NotInstalled
#$updatescope.FromArrivalDate = [datetime]"12/13/2017"  

$WSUSSERVER="SERVER1234"  
$wsus = [Microsoft.UpdateServices.Administration.AdminProxy]::getUpdateServer("$WSUSSERVER",$false,8530)  

# ApprovedUpdatestoXML
# \Update Services 3.0 API Samples and Tools\ApprovedUpdatesToXML
 
$updateScope = New-Object Microsoft.UpdateServices.Administration.UpdateScope
$updateScope.ApprovedStates = (
([Microsoft.UpdateServices.Administration.ApprovedStates]::HasStaleUpdateApprovals.value__+
[Microsoft.UpdateServices.Administration.ApprovedStates]::LatestRevisionApproved.value__)
)
 
# get the list of updates that are approved, or have an older revision that is approved
$Updates = (Get-WsusServer).GetUpdates($updateScope) 
# calling IUpdate.GetUpdateApprovals once for each update can be expensive, so instead
# we use call IUpdateServer.GetUpdateApprovals() to get all approvals for all updates at once
$allUpdateApprovals = (Get-WsusServer).GetUpdateApprovals($updateScope)
# similarly, construct a table of target group
$allTargetGroups = (Get-WsusServer).GetComputerTargetGroups()
$Updates | ForEach-Object {
    $update = $_
    [PSCustomObject]@{
        Id = $update.Id.UpdateId.ToString() ;
        Title = $update.Title ;
        Classification = $update.UpdateClassificationTitle ;
        Approvals = $( 
        if ($update.IsApproved) {
            # This revision (the latest revision) is approved; get the approvals and write them
            $allUpdateApprovals | Where { 
                $_.UpdateID.UpdateID -eq $update.Id.UpdateId
            } | 
            ForEach-Object {
                $approval = $_
                [PSCustomObject]@{
                    RevisionNumber = $update.Id.RevisionNumber ;
                    TargetGroup = ($allTargetGroups | Where { $_.ID -eq $approval.ComputerTargetGroupId }).Name ;
                    Approval = $approval.Action ;
                    Deadline = $( 
                        if ($_.Deadline -lt ([datetime]::maxvalue)) {
                            $_.Deadline    
                        } else {
                            "None"  
                        }
                    ) ;
                    ApprovalDate = $approval.CreationDate ;
                }
            }
        } elseif ($update.HasStaleUpdateApprovals) {
            # This revision has older revisions that are approved; get their approvals and write them
            $update.GetRelatedUpdates(
                [Microsoft.UpdateServices.Administration.UpdateRelationship]::AllRevisionsOfThisUpdate
                ) | Where isApproved | 
                ForEach-Object {
                $revision = $_
                $revision.GetUpdateApprovals() |
                ForEach-Object {
                    $approval = $_
                    [PSCustomObject]@{
                        RevisionNumber = $update.Id.RevisionNumber ;
                        TargetGroup = ($allTargetGroups | Where { $_.ID -eq $approval.ComputerTargetGroupId }).Name ;
                        Approval = $approval.Action ;
                        Deadline = $( 
                            if ($_.Deadline -lt ([datetime]::maxvalue)) {
                                $_.Deadline    
                            } else {
                                "None"  
                            }
                        ) ;
                        ApprovalDate = $approval.CreationDate ;
                    }
                }
                }
        } else {
        }
    ) ;
    }
}  | Out-GridView