如何用PowerShell删除BaseName不在指定用户数组中的文件

Got it, let's get this sorted out—your original script was missing the critical filtering step to target only files whose basenames aren't in your user list, which is why it was deleting everything. Here's the corrected approach, with explanations for each part:

Corrected Script #

# 1. Define your array of valid user basenames (from your database query)
$currentUsers = @("ABB016", "ACQ002", "AGU003", "AHM007")
# 2. Set your target directory path
$DirectoryWithFiles = "C:\Path\To\Your\Files"

# 3. Get all files (skip directories) in the target path (and subfolders)
$allFiles = Get-ChildItem -Path $DirectoryWithFiles -File -Recurse

# 4. Filter to keep only files whose basename is NOT in the valid user list
$filesToDelete = $allFiles | Where-Object { $currentUsers -notcontains $_.BaseName }

# 5. First, verify which files will be deleted (always test this first!)
Write-Host "Files scheduled for deletion:"
$filesToDelete | Select-Object FullName | Format-Table -AutoSize

# 6. Uncomment the line below to perform actual deletion (remove -WhatIf once verified)
# $filesToDelete | Remove-Item -Force -WhatIf

Key Fixes & Explanations #

• -File Parameter: Ensures we only target files, not directories—prevents accidental deletion of folders.
• Proper Filtering: The Where-Object clause uses -notcontains to check if a file's basename is missing from your valid user array. This is the core logic your original script was missing.
• Safety First: The -WhatIf flag in Remove-Item lets you preview deletions without actually deleting anything. Always run this first to confirm you're targeting the right files!
• Case Sensitivity Note: If your filenames might have mixed case (e.g., abb016 instead of ABB016), adjust the filter to normalize case:

  $filesToDelete = $allFiles | Where-Object { $currentUsers -notcontains $_.BaseName.ToUpper() }
  

Important Reminders #

• Double-check your $DirectoryWithFiles path to avoid targeting the wrong folder.
• Ensure your PowerShell session has the necessary permissions to delete files in the target directory.

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