組合兩個不同的陣列時如何添加if陳述句

今天我問 結合兩個不同大小和不同屬性的陣列

這是答案

$GroupMembersCount = $null
$GroupMembersCount = gam print groups domain <domain.com> members managers owners countsonly | ConvertFrom-Csv

$GroupSettings = $null
$GroupSettings = gam print groups settings | ConvertFrom-Csv

$GroupMemberCountByEmail = @{}
$GroupMembersCount | ForEach-Object {
    $GroupMemberCountByEmail[$_.email] = $_
}

$GroupSettings | Select-Object *,
    @{
        Name = 'MembersCount'
        Expression = { [int]$GroupMemberCountByEmail[$_.email].MembersCount }
    },@{
        Name = 'ManagersCount'
        Expression = { [int]$GroupMemberCountByEmail[$_.email].ManagersCount }
    },@{
        Name = 'OwnersCount'
        Expression = { [int]$GroupMemberCountByEmail[$_.email].OwnersCount }
    } |
    Export-Csv 'c:\temp\groups.csv' -NoTypeInformation -Encoding UTF8

如果所有計數都為零，我如何在上面的答案中添加一列，這會給我一個 True 或 false ？

我想我需要if在上面的匯出之前，但我不知道如何在If (X -eq 0 -and Y -eq 0) { Do stuff }這里，因為我不知道如何在匯出之前解決 X。

| Export-Csv 'c:\temp\groups.csv' -NoTypeInformation -Encoding UTF8

uj5u.com熱心網友回復：

我只是通過管道傳遞給另一個Select-Object以保持您的代碼更清潔。如果您想在另一個計算屬性中重用您的哈希表查找，則不需要它。

$GroupSettings | Select-Object *,
    @{
        Name = 'MembersCount'
        Expression = { [int]$GroupMemberCountByEmail[$_.email].MembersCount }
    },@{
        Name = 'ManagersCount'
        Expression = { [int]$GroupMemberCountByEmail[$_.email].ManagersCount }
    },@{
        Name = 'OwnersCount'
        Expression = { [int]$GroupMemberCountByEmail[$_.email].OwnersCount }
    } |
        Select-Object *,
            @{
                Name='AllZeroes'
                Expression={-not ($_.MembersCount -or $_.ManagersCount -or $_.OwnersCount) }
            } | 
                Export-Csv 'c:\temp\groups.csv' -NoTypeInformation -Encoding UTF8

AllZeroes$true如果所有計數均為 ，則屬性將回傳0。

uj5u.com熱心網友回復：

我想再次添加我所做的。請任何讀者注意，我的一些答案是不同的，因為我使用一個名為 GAM 的工具來幫助我管理 Google。GAM 迫使我從上面接受的內容轉向。

PS：我發現這里的大多數答案都需要調整。您的里程可能會有所不同，因此請謹慎行事。

<#
https://stackoverflow.com/questions/70613438/how-could-i-add-an-if-statement-when-combining-two-different-arrays/70614250#70614250

https://stackoverflow.com/questions/70609905/combined-two-arrays-of-different-size-with-different-properties/70610915?noredirect=1#comment124824384_70610915
#>

$GroupMembersCount = $null
$GroupMembersCount = gam print groups domain <Domain.com> members managers owners countsonly | ConvertFrom-Csv

$GroupSettings = $null
$GroupSettings = gam print groups settings | ConvertFrom-Csv

$GroupsEmpty = $null
$GroupsEmpty = gam config csv_output_row_filter "directMembersCount:count=0" print groups directmemberscount | ConvertFrom-csv

$GroupMemberCountByEmail = @{}
$GroupMembersCount | ForEach-Object {
    $GroupMemberCountByEmail[$_.email] = $_
}

$Result = $null
$Result = $GroupSettings | Select-Object *,
@{
    Name       = 'MembersCount'
    Expression = { [int]$GroupMemberCountByEmail[$_.email].MembersCount }
}, @{
    Name       = 'ManagersCount'
    Expression = { [int]$GroupMemberCountByEmail[$_.email].ManagersCount }
}, @{
    Name       = 'OwnersCount'
    Expression = { [int]$GroupMemberCountByEmail[$_.email].OwnersCount }
}

If ($GroupsEmpty) {
    $Result | Add-Member -NotePropertyName EmptyGroup -NotePropertyValue $false
    
    function Get-ArrayRowIndex {
        param(
            [parameter(mandatory = $true)][array]$Property,
            [parameter(mandatory = $true)][string]$Value
        )

        [int]$index = 0
        while ($index -lt ($Property.count)) {
            if ($Property[$index] -eq $Value) {
                return [int]$index
            }
            $index  
        }
        return $null
    }

    $Result | ForEach-Object {
        If ($GroupsEmpty.email -contains $_.Email) {
            $UpdateRowIndex = $null
            #Get-ArrayRowIndex tries to find the item to update in the Result array. $UpdateRowIndex can't be [int]
            $UpdateRowIndex = Get-ArrayRowIndex -Property $($Result.email) -Value $_.Email
            #update the correct item in the array,changing flag made above.
            If ($null -ne $UpdateRowIndex) {
                $Result[$UpdateRowIndex].EmptyGroup = $true
            }
            Else {
                #If location in array was not found function Get-ArrayRowIndex.
                Write-Error "Problem with final report. Index location in the result array was not found using Get-ArrayRowIndex."
                Start-Sleep -Seconds 3
                break script
            }
        }
    } 
}

$result | Export-Csv 'c:\temp\groups.csv' -NoTypeInformation -Encoding UTF8

Try {
    Invoke-Item -Path 'c:\temp\groups.csv'
}
Catch {
    write-error "Final report not found at c:\temp\groups.csv"
}

有更好的方法來做我上面所做的，但這適合我現在。

標籤：

上一篇：Clojure已安裝，但clj失敗

下一篇：我創建了一個自定義powershell.psm1模塊，但在編輯后它不會更新