PowerShell foreach遍历Exchange邮箱文本后删除已处理行残留问题咨询

出现行没有被正常删除的问题，是三个设计缺陷共同导致的：

• 静态内存列表与文件状态脱节：$mailboxes是循环启动前一次性加载的固定静态数组，PowerShell的foreach循环在启动时就会把整个枚举列表缓存好，循环全程不会根据文件的修改动态更新列表内容，每次执行删除操作时基于的都是启动时刻的全量用户列表，和实际的文件内容完全错位。
• 匹配规则误用：删除行时使用-notmatch做行匹配，这是正则匹配逻辑，一旦用户名包含.、*、+等正则特殊字符，就会出现匹配失效，无法精准定位要删除的行。
• 循环内反复覆盖写文件：每次处理完一行就对同一个目标文件执行全量覆盖写入，很容易因为数组枚举缓存、文件IO时序冲突，出现写入内容和预期不一致的情况，最终留下本该被删除的行。

核心思路是将邮箱处理操作和文件更新动作解耦，不要在循环过程中反复改写原文件，避免时序冲突；同时替换掉容易出错的正则匹配为精确字符串匹配，从根源上消除残留问题。

方案1：批量处理完成后一次性更新文件 #

适合脚本运行环境稳定、很少中途中断的场景，代码逻辑更简单：

1. 先定义文件完整路径，避免反复书写长UNC路径
   $mailboxListPath = "\\SERVER\c$\Scripts\Enable archiving and litigation\new_mailboxes.txt"
2. 加载原始待处理列表，自动过滤空行
   $allMailboxes = Get-Content $mailboxListPath | Where-Object { $_ -ne "" }
3. 初始化空数组，记录所有处理成功的邮箱
   $processedMailboxes = @()
4. 遍历所有邮箱执行配置操作，只有所有Exchange命令执行成功，才将该邮箱加入已处理列表

   foreach ($line in $allMailboxes) {
       # 跳过空白行
       if ([string]::IsNullOrWhiteSpace($line)) { continue }
   
       try {
           Write-host "Enable Archiving for $line"
           Get-Mailbox $line | Enable-Mailbox -archive -ErrorAction Stop
   
           Write-host "Enable Litigation Hold for $line"    
           Get-Mailbox $line | Set-Mailbox -litigationHoldEnabled $true -litigationholdduration 2555 -ErrorAction Stop
   
           Write-host "Set Quota for $line"
           Get-Mailbox $line | Set-Mailbox -prohibitsendquota 4.5GB -prohibitsendreceivequota 5.0GB -issuewarningquota 4GB -ErrorAction Stop
   
           Write-host "Assign Retention Policy for $line"
           Get-Mailbox $line | Set-Mailbox -retentionpolicy "ORG Retention Policy" -ErrorAction Stop
   
           Write-host "Set Deleted Items Retention for $line"
           Get-Mailbox $line | Set-Mailbox -RetainDeletedItemsFor 30.00:00:00 -ErrorAction Stop
   
           # 所有操作执行成功，将当前行加入已处理列表（自动去除行尾多余空白）
           $processedMailboxes += $line.Trim()
           Write-Host "Successfully processed $line"
       }
       catch {
           Write-Warning "Failed to process $line : $_"
       }
   }
   

5. 全量循环结束后，一次性剔除已处理的行，将剩余内容写回原文件

   $remainingMailboxes = $allMailboxes | Where-Object {
       $currentTrimmedLine = $_.Trim()
       # 使用精确相等判断，避免正则匹配的特殊字符问题
       $processedMailboxes -notcontains $currentTrimmedLine
   }
   $remainingMailboxes | Set-Content $mailboxListPath
   

方案2：动态逐行处理、即时更新文件 #

适合Exchange连接不稳定、可能中途断开的场景，就算脚本中断重启，也只会重复处理未完成的邮箱，不会重复给已完成的邮箱打配置：

$mailboxListPath = "\\SERVER\c$\Scripts\Enable archiving and litigation\new_mailboxes.txt"

while ($true) {
    # 每次循环都动态读取文件，不做静态缓存
    $currentLine = Get-Content $mailboxListPath | Select-Object -First 1
    # 文件为空、没有待处理行时退出循环
    if ([string]::IsNullOrWhiteSpace($currentLine)) { break }

    try {
        Write-host "Enable Archiving for $currentLine"
        Get-Mailbox $currentLine | Enable-Mailbox -archive -ErrorAction Stop

        Write-host "Enable Litigation Hold for $currentLine"    
        Get-Mailbox $currentLine | Set-Mailbox -litigationHoldEnabled $true -litigationholdduration 2555 -ErrorAction Stop

        Write-host "Set Quota for $currentLine"
        Get-Mailbox $currentLine | Set-Mailbox -prohibitsendquota 4.5GB -prohibitsendreceivequota 5.0GB -issuewarningquota 4GB -ErrorAction Stop

        Write-host "Assign Retention Policy for $currentLine"
        Get-Mailbox $currentLine | Set-Mailbox -retentionpolicy "ORG Retention Policy" -ErrorAction Stop

        Write-host "Set Deleted Items Retention for $currentLine"
        Get-Mailbox $currentLine | Set-Mailbox -RetainDeletedItemsFor 30.00:00:00 -ErrorAction Stop

        # 处理成功后，即时将当前行从文件中移除
        $remainingContent = Get-Content $mailboxListPath | Select-Object -Skip 1
        $remainingContent | Set-Content $mailboxListPath
        Write-Host "Successfully removed $currentLine from list"
    }
    catch {
        Write-Warning "Failed to process $currentLine, moving to end of list : $_"
        # 处理失败时，将当前行移到文件末尾，避免脚本卡在这一行
        $allLines = Get-Content $mailboxListPath
        $allLines | Select-Object -Skip 1 | Set-Content $mailboxListPath
        Add-Content -Path $mailboxListPath -Value $currentLine
    }
}

原脚本中存在日志提示错配的问题：连续两行Write-host "Enable Quota for $line"中，第二行实际是配置保留策略的操作，容易导致排查日志时混淆操作类型，上面的修改代码已经对日志提示做了对应修正。

内容的提问来源于stack exchange，提问作者axite