Posh365

0.9.33

Public/Migration/MailboxMove/OnPremises/Get-MailboxMoveOnPremisesMailboxReport.ps1

                                Function Get-MailboxMoveOnPremisesMailboxReport {

    [CmdletBinding()]

    param (

        [Parameter(Mandatory = $true)]

        [string]

        $ReportPath

    )

    end {

        New-Item -ItemType Directory -Path $ReportPath -ErrorAction SilentlyContinue

        $BatchesFile = Join-Path $ReportPath 'Batches.csv'

        $Select = @(

            'BatchName', 'DisplayName', 'OrganizationalUnit', 'IsMigrated', 'CompleteBatchDate'

            'CompleteBatchTimePT', 'MailboxGB', 'ArchiveGB', 'DeletedGB', 'TotalGB'

            'LastLogonTime', 'ItemCount', 'UserPrincipalName', 'PrimarySmtpAddress'

            'AddressBookPolicy', 'RetentionPolicy', 'AccountDisabled', 'Alias'

            'Database', 'OU', 'Office', 'RecipientTypeDetails', 'UMEnabled'

            'ForwardingAddress', 'ForwardingRecipientType', 'ForwardingSmtpAddress'

            'DeliverToMailboxAndForward'

        )

        Get-MailboxMoveOnPremisesReportHelper | Select-Object $Select | Export-Csv $BatchesFile -NoTypeInformation -Encoding UTF8

        $ExcelSplat = @{

            Path                    = (Join-Path $ReportPath 'Batches.xlsx')

            TableStyle              = 'Medium2'

            FreezeTopRowFirstColumn = $true

            AutoSize                = $true

            BoldTopRow              = $true

            ClearSheet              = $true

            WorksheetName           = 'Batches'

            ErrorAction             = 'SilentlyContinue'

        }

        $BatchesFile | Where-Object { $_ } | ForEach-Object { Import-Csv $_ | Export-Excel @ExcelSplat }

    }

}