ParseAclResult.ps1

# Import the CSV file generated by adaclscan
$scanResults = Import-Csv -Path "C:\Temp\Test_ACL_20231031.csv"

# Filter the results to show only entries with "AccessDenied" in the "Access" column
$accessAllowDelete = $scanResults | Where-Object { ($_.Access -eq "Allow") -and ($_.Permission -like "Delete*") }
$accessAllowWrite = $scanResults | Where-Object { ($_.Access -eq "Allow") -and ($_.Permission -like "Write*") }
$accessAllowValidated = $scanResults | Where-Object { ($_.Access -eq "Allow") -and ($_.Permission -like "*Validated*") }
$accessAllowFullControl = $scanResults | Where-Object { ($_.Access -eq "Allow") -and ($_.Permission -eq "Full Control") }
$accessAllowPassword = $scanResults | Where-Object { ($_.Access -eq "Allow") -and ($_.Permission -like "*Password*") }

# Group the results by the "Path" column and count the number of entries in each group
$groupedResults = $accessDenied | Group-Object -Property Path | Select-Object Name, Count

# Sort the results by the number of entries in each group, in descending order
# $sortedResults = $groupedResults | Sort-Object -Property Count -Descending

# Output the results to the console
$sortedResults | Format-Table -AutoSize