Public/PublicFolder/Get-InvalidPublicFolderCharacterReport.ps1
|
function Get-InvalidPublicFolderCharacterReport { <# .SYNOPSIS Export Report of Public Folders with Invalid Characters .DESCRIPTION Export Report of Public Folders with Invalid Characters .EXAMPLE Get-InvalidPublicFolderCharacterReport | Export-Csv .\PFcharReport.csv -notypeinformation -Encoding UTF8 .NOTES General notes #> [CmdletBinding()] param ( ) $PFDBList = Get-PublicFolderDatabase $BadNamePFList = New-Object System.Collections.Generic.List[PSObject] ForEach ($PFDB in $PFDBList) { Write-Host "INFO: Checking against... $($PFDB.Server)" $FolderList = Get-PublicFolderStatistics -ResultSize Unlimited -Server $PFDB.Server foreach ($Folder in $FolderList) { if ($Folder.Name -like '*\*' -or $Folder.Name -like "*/*" -or $Folder.Name -like '*<*' -or $Folder.Name -like '*>*' -or $Folder.Name.ToString() -match '\u2013' -or $Folder.Name -like '*_-*' -or $Folder.Name -like ' *' -or $Folder.Name -like '* ') { Write-Host "FOUND... $($Folder.Name)" $BadNamePFList.Add($Folder) } } } Write-Host "Number of PFs with Offending Characters: $($BadNamePFList.count)" foreach ($BadNamePF in $BadNamePFList) { $OffendingChar = New-Object System.Collections.Generic.List[string] if ($BadNamePF.Name -like "*\*") { $OffendingChar.Add('\') } if ($BadNamePF.Name -like "*/*") { $OffendingChar.Add('/') } if ($BadNamePF.Name -like "*<*") { $OffendingChar.Add('<') } if ($BadNamePF.Name -like "*>*") { $OffendingChar.Add('>') } if ($BadNamePF.Name -like "*_-*") { $OffendingChar.Add('_-') } if ($BadNamePF.Name -match '\u2013') { $OffendingChar.Add('EnDash') } if ($BadNamePF.Name -like " *") { $OffendingChar.Add('Lead-Whitespace') } if ($BadNamePF.Name -like "* ") { $OffendingChar.Add('Trail-Whitespace') } $NewFolder = $BadNamePF.Name.Replace('\', '-') $NewFolder = $NewFolder.Replace('/', '-') $NewFolder = $NewFolder.Replace('<', '') $NewFolder = $NewFolder.Replace('>', '') $NewFolder = $NewFolder.Replace('_-', '-') $NewFolder = $NewFolder -replace '\u2013|\u2014', '-' Write-Host "Old Folder Name:`t$($BadNamePF.Name)" -ForegroundColor "Cyan" Write-Host "New Folder Name:`t$NewFolder" -ForegroundColor "Green" Write-Host "" Write-Host "" $CorrectedPF = New-Object -TypeName PSObject -Property @{ FolderPath = $BadNamePF.FolderPath OldFolder = $BadNamePF.Name NewFolder = $NewFolder OffendingChar = $OffendingChar Database = $BadNamePF.DatabaseName Identity = $BadNamePF.Identity CreationTime = $BadNamePF.CreationTime } $CorrectedPF | Select-Object FolderPath, OldFolder, NewFolder, OffendingChar, Database, Identity, CreationTime } } |