Automated Cleanup of Old Processed Folders Using PowerShell

# Define the root folders and the age threshold

$rootFolders = @("\\localhost\Hotfolders\NDPP2\Processed", "C:\wfd\Data\FileStorage")

$nDaysAgo = 30



# Determine the script path and create the log file path

$scriptPath = Split-Path -Parent $MyInvocation.MyCommand.Definition

$logFile = Join-Path $scriptPath "Log.txt"



foreach ($rootFolder in $rootFolders) {

    # Calculate the cutoff date for folder deletion

    $cutOffDate = (Get-Date).AddDays(-$nDaysAgo)



    # Identify subfolders older than the cutoff date

    $subFoldersToDelete = Get-ChildItem $rootFolder -Directory | Where-Object { $_.CreationTime -lt $cutOffDate }

    

    $foldersDeleted = 0

    $filesDeleted = 0

    $errors = @()



    # Process each subfolder for deletion

    foreach ($subFolder in $subFoldersToDelete) {

        try {

            $filesDeletedBefore = (Get-ChildItem $subFolder.FullName -File -Recurse).Count

            Remove-Item $subFolder.FullName -Recurse -Force

            $foldersDeleted++

            $filesDeleted += $filesDeletedBefore

        } catch {

            $errors += $_.Exception.Message

        }

    }



    # Log the deletion activity

    $logEntry = "$(Get-Date) - $foldersDeleted folders older than $nDaysAgo days deleted from $rootFolder. Files deleted: $filesDeleted."

    if ($errors.Count -gt 0) {

        $logEntry += " Errors: $($errors -join ';')"

    }

    Add-Content -Path $logFile -Value $logEntry

    Write-Host $logEntry

}