Created
May 13, 2020 16:37
-
-
Save azure365pro/62e73f2090d03f9a6ee4987d9fda8c04 to your computer and use it in GitHub Desktop.
Export all the Mailbox Size with Item Count,Database,Server Details
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <# | |
| .Requires -version 2 - Runs in Exchange Management Shell or Open Powershell and Connect to Office365 | |
| .SYNOPSIS | |
| .\MailboxSizeReport.ps1 - It Can Display all the Mailbox Size with Item Count,Database,Server Details | |
| Or It can Export to a CSV file | |
| Or You can Enter WildCard to Display or Export | |
| Example 1 | |
| [PS] C:\>.\MailboxSizeReport.ps1 | |
| Mailbox Size Report | |
| ---------------------------- | |
| 1.Display in Exchange Management Shell | |
| 2.Export to CSV File | |
| 3.Enter the Mailbox Name with Wild Card (Export) | |
| 4.Enter the Mailbox Name with Wild Card (Display) | |
| 5.Export to CSV File (OFFICE 365) | |
| 6.Enter the Mailbox Name with Wild Card (Export) (OFFICE 365) | |
| Choose The Task: 1 | |
| Display Name Primary SMTP address TotalItemSize ItemCount | |
| ------------ -------------------- ------------- --------- | |
| Tes433 Tes433@azure365pro.com | |
| Test Test@azure365pro.com 335.9 KB (343,933 bytes) 40 | |
| Test X500 TestX500@azure365pro.com 6.544 KB (6,701 bytes) 3 | |
| Test100 test100@azure365pro.com 40.74 KB (41,719 bytes) 7 | |
| Test22 Test22@azure365pro.com 60.04 KB (61,483 bytes) 7 | |
| Test3 Test3@azure365pro.com 364.7 KB (373,503 bytes) 31 | |
| Test33 Test332@azure365pro.com 93.34 KB (95,585 bytes) 6 | |
| Test33 Test33@FSD.com 5.335 KB (5,463 bytes) 3 | |
| Test3331 Test3331@azure365pro.com 24.14 KB (24,720 bytes) 2 | |
| Test46 Test46@azure365pro.com 254 KB (260,071 bytes) 21 | |
| Example 2 | |
| [PS] C:\>.\MailboxSizeReport.ps1 | |
| Mailbox Size Report | |
| ---------------------------- | |
| 1.Display in Exchange Management Shell | |
| 2.Export to CSV File | |
| 3.Enter the Mailbox Name with Wild Card (Export) | |
| 4.Enter the Mailbox Name with Wild Card (Display) | |
| 5.Export to CSV File (OFFICE 365) | |
| 6.Enter the Mailbox Name with Wild Card (Export) (OFFICE 365) | |
| Choose The Task: 2 | |
| Enter the Path of CSV file (Eg. C:\Report.csv): C:\MailboxReport.csv | |
| .Author | |
| Written By: Satheshwaran Manoharan | |
| Change Log | |
| V1.0, 10/08/2014 - Initial version | |
| Change Log | |
| V1.1, 05/12/2016 - ProgressBar,Seperate Office 365 Options, QuotaLimits,EmailAddresses | |
| Change Log | |
| V1.2, 20/06/2019 - ArchiveName,ArchiveStatus,ArchiveState,ArchiveQuota,-Encoding UTF8,Bugfix -DB Quota,Bug fix Single object listing-DividebyZero | |
| #> | |
| Write-host " | |
| Mailbox Size Report | |
| ---------------------------- | |
| 1.Display in Exchange Management Shell | |
| 2.Export to CSV File | |
| 3.Export to CSV File (Specific to Database) | |
| 4.Enter the Mailbox Name with Wild Card (Export) | |
| 5.Enter the Mailbox Name with Wild Card (Display) | |
| 6.Export to CSV File (OFFICE 365) | |
| 7.Enter the Mailbox Name with Wild Card (Export) (OFFICE 365)"-ForeGround "Cyan" | |
| #---------------- | |
| # Script | |
| #---------------- | |
| Write-Host " " | |
| $number = Read-Host "Choose The Task" | |
| $output = @() | |
| switch ($number) | |
| { | |
| 1 { | |
| $AllMailbox = Get-mailbox -resultsize unlimited | |
| Foreach($Mbx in $AllMailbox) | |
| { | |
| $Stats = Get-mailboxStatistics -Identity $Mbx.distinguishedname -WarningAction SilentlyContinue | |
| $userObj = New-Object PSObject | |
| $userObj | Add-Member NoteProperty -Name "Display Name" -Value $mbx.displayname | |
| $userObj | Add-Member NoteProperty -Name "Primary SMTP address" -Value $mbx.PrimarySmtpAddress | |
| $userObj | Add-Member NoteProperty -Name "TotalItemSize" -Value $Stats.TotalItemSize | |
| $userObj | Add-Member NoteProperty -Name "ItemCount" -Value $Stats.ItemCount | |
| Write-Output $Userobj | |
| } | |
| ;Break} | |
| 2 { | |
| $i = 0 | |
| $CSVfile = Read-Host "Enter the Path of CSV file (Eg. C:\Report.csv)" | |
| $AllMailbox = Get-mailbox -resultsize unlimited | |
| Foreach($Mbx in $AllMailbox) | |
| { | |
| $Stats = Get-mailboxStatistics -Identity $Mbx.distinguishedname -WarningAction SilentlyContinue | |
| if (($Mbx.UseDatabaseQuotaDefaults -eq $true) -and (Get-MailboxDatabase $mbx.Database).ProhibitSendReceiveQuota.value -eq $null) | |
| { | |
| $ProhibitSendReceiveQuota = "Unlimited" | |
| } | |
| if (($Mbx.UseDatabaseQuotaDefaults -eq $true) -and (Get-MailboxDatabase $mbx.Database).ProhibitSendReceiveQuota.value -ne $null) | |
| { | |
| $ProhibitSendReceiveQuota = (Get-MailboxDatabase $mbx.Database).ProhibitSendReceiveQuota.Value.ToMB() | |
| } | |
| if (($Mbx.UseDatabaseQuotaDefaults -eq $false) -and ($mbx.ProhibitSendReceiveQuota.value -eq $null)) | |
| { | |
| $ProhibitSendReceiveQuota = "Unlimited" | |
| } | |
| if (($Mbx.UseDatabaseQuotaDefaults -eq $false) -and ($mbx.ProhibitSendReceiveQuota.value -ne $null)) | |
| { | |
| $ProhibitSendReceiveQuota = $Mbx.ProhibitSendReceiveQuota.Value.ToMB() | |
| } | |
| if ($Mbx.ArchiveName.count -eq "0") | |
| { | |
| $ArchiveTotalItemSize = $null | |
| $ArchiveTotalItemCount = $null | |
| } | |
| if ($Mbx.ArchiveName -ge "1") | |
| { | |
| $MbxArchiveStats = Get-mailboxstatistics $Mbx.distinguishedname -Archive -WarningAction SilentlyContinue | |
| $ArchiveTotalItemSize = $MbxArchiveStats.TotalItemSize | |
| $ArchiveTotalItemCount = $MbxArchiveStats.BigFunnelMessageCount | |
| } | |
| $userObj = New-Object PSObject | |
| $userObj | Add-Member NoteProperty -Name "Display Name" -Value $mbx.displayname | |
| $userObj | Add-Member NoteProperty -Name "Alias" -Value $Mbx.Alias | |
| $userObj | Add-Member NoteProperty -Name "SamAccountName" -Value $Mbx.SamAccountName | |
| $userObj | Add-Member NoteProperty -Name "RecipientType" -Value $Mbx.RecipientTypeDetails | |
| $userObj | Add-Member NoteProperty -Name "Recipient OU" -Value $Mbx.OrganizationalUnit | |
| $userObj | Add-Member NoteProperty -Name "Primary SMTP address" -Value $Mbx.PrimarySmtpAddress | |
| $userObj | Add-Member NoteProperty -Name "Email Addresses" -Value ($Mbx.EmailAddresses.smtpaddress -join ";") | |
| $userObj | Add-Member NoteProperty -Name "Database" -Value $mbx.Database | |
| $userObj | Add-Member NoteProperty -Name "ServerName" -Value $mbx.ServerName | |
| if($Stats) | |
| { | |
| $userObj | Add-Member NoteProperty -Name "TotalItemSize" -Value $Stats.TotalItemSize.Value.ToMB() | |
| $userObj | Add-Member NoteProperty -Name "ItemCount" -Value $Stats.ItemCount | |
| $userObj | Add-Member NoteProperty -Name "DeletedItemCount" -Value $Stats.DeletedItemCount | |
| $userObj | Add-Member NoteProperty -Name "TotalDeletedItemSize" -Value $Stats.TotalDeletedItemSize.Value.ToMB() | |
| } | |
| $userObj | Add-Member NoteProperty -Name "ProhibitSendReceiveQuota-In-MB" -Value $ProhibitSendReceiveQuota | |
| $userObj | Add-Member NoteProperty -Name "UseDatabaseQuotaDefaults" -Value $Mbx.UseDatabaseQuotaDefaults | |
| $userObj | Add-Member NoteProperty -Name "LastLogonTime" -Value $Stats.LastLogonTime | |
| $userObj | Add-Member NoteProperty -Name "ArchiveName" -Value ($Mbx.ArchiveName -join ";") | |
| $userObj | Add-Member NoteProperty -Name "ArchiveStatus" -Value $Mbx.ArchiveStatus | |
| $userObj | Add-Member NoteProperty -Name "ArchiveState" -Value $Mbx.ArchiveState | |
| $userObj | Add-Member NoteProperty -Name "ArchiveQuota" -Value $Mbx.ArchiveQuota | |
| $userObj | Add-Member NoteProperty -Name "ArchiveTotalItemSize" -Value $ArchiveTotalItemSize | |
| $userObj | Add-Member NoteProperty -Name "ArchiveTotalItemCount" -Value $ArchiveTotalItemCount | |
| $output += $UserObj | |
| # Update Counters and Write Progress | |
| $i++ | |
| if ($AllMailbox.Count -ge 1) | |
| { | |
| Write-Progress -Activity "Scanning Mailboxes . . ." -Status "Scanned: $i of $($AllMailbox.Count)" -PercentComplete ($i/$AllMailbox.Count*100) | |
| } | |
| } | |
| $output | Export-csv -Path $CSVfile -NoTypeInformation -Encoding UTF8 | |
| ;Break} | |
| 3 { | |
| $i = 0 | |
| $CSVfile = Read-Host "Enter the Path of CSV file (Eg. C:\Report.csv)" | |
| $Database = Read-Host "Enter the DatabaseName (Eg. Database 01)" | |
| $AllMailbox = Get-mailbox -resultsize unlimited -Database "$Database" | |
| Foreach($Mbx in $AllMailbox) | |
| { | |
| $Stats = Get-mailboxStatistics -Identity $Mbx.distinguishedname -WarningAction SilentlyContinue | |
| if (($Mbx.UseDatabaseQuotaDefaults -eq $true) -and (Get-MailboxDatabase $mbx.Database).ProhibitSendReceiveQuota.value -eq $null) | |
| { | |
| $ProhibitSendReceiveQuota = "Unlimited" | |
| } | |
| if (($Mbx.UseDatabaseQuotaDefaults -eq $true) -and (Get-MailboxDatabase $mbx.Database).ProhibitSendReceiveQuota.value -ne $null) | |
| { | |
| $ProhibitSendReceiveQuota = (Get-MailboxDatabase $mbx.Database).ProhibitSendReceiveQuota.Value.ToMB() | |
| } | |
| if (($Mbx.UseDatabaseQuotaDefaults -eq $false) -and ($mbx.ProhibitSendReceiveQuota.value -eq $null)) | |
| { | |
| $ProhibitSendReceiveQuota = "Unlimited" | |
| } | |
| if (($Mbx.UseDatabaseQuotaDefaults -eq $false) -and ($mbx.ProhibitSendReceiveQuota.value -ne $null)) | |
| { | |
| $ProhibitSendReceiveQuota = $Mbx.ProhibitSendReceiveQuota.Value.ToMB() | |
| } | |
| if ($Mbx.ArchiveName.count -eq "0") | |
| { | |
| $ArchiveTotalItemSize = $null | |
| $ArchiveTotalItemCount = $null | |
| } | |
| if ($Mbx.ArchiveName -ge "1") | |
| { | |
| $MbxArchiveStats = Get-mailboxstatistics $Mbx.distinguishedname -Archive -WarningAction SilentlyContinue | |
| $ArchiveTotalItemSize = $MbxArchiveStats.TotalItemSize | |
| $ArchiveTotalItemCount = $MbxArchiveStats.BigFunnelMessageCount | |
| } | |
| $userObj = New-Object PSObject | |
| $userObj | Add-Member NoteProperty -Name "Display Name" -Value $mbx.displayname | |
| $userObj | Add-Member NoteProperty -Name "Alias" -Value $Mbx.Alias | |
| $userObj | Add-Member NoteProperty -Name "SamAccountName" -Value $Mbx.SamAccountName | |
| $userObj | Add-Member NoteProperty -Name "RecipientType" -Value $Mbx.RecipientTypeDetails | |
| $userObj | Add-Member NoteProperty -Name "Recipient OU" -Value $Mbx.OrganizationalUnit | |
| $userObj | Add-Member NoteProperty -Name "Primary SMTP address" -Value $Mbx.PrimarySmtpAddress | |
| $userObj | Add-Member NoteProperty -Name "Email Addresses" -Value ($Mbx.EmailAddresses.smtpaddress -join ";") | |
| $userObj | Add-Member NoteProperty -Name "Database" -Value $mbx.Database | |
| $userObj | Add-Member NoteProperty -Name "ServerName" -Value $mbx.ServerName | |
| if($Stats) | |
| { | |
| $userObj | Add-Member NoteProperty -Name "TotalItemSize" -Value $Stats.TotalItemSize.Value.ToMB() | |
| $userObj | Add-Member NoteProperty -Name "ItemCount" -Value $Stats.ItemCount | |
| $userObj | Add-Member NoteProperty -Name "DeletedItemCount" -Value $Stats.DeletedItemCount | |
| $userObj | Add-Member NoteProperty -Name "TotalDeletedItemSize" -Value $Stats.TotalDeletedItemSize.Value.ToMB() | |
| } | |
| $userObj | Add-Member NoteProperty -Name "ProhibitSendReceiveQuota-In-MB" -Value $ProhibitSendReceiveQuota | |
| $userObj | Add-Member NoteProperty -Name "UseDatabaseQuotaDefaults" -Value $Mbx.UseDatabaseQuotaDefaults | |
| $userObj | Add-Member NoteProperty -Name "LastLogonTime" -Value $Stats.LastLogonTime | |
| $userObj | Add-Member NoteProperty -Name "ArchiveName" -Value ($Mbx.ArchiveName -join ";") | |
| $userObj | Add-Member NoteProperty -Name "ArchiveStatus" -Value $Mbx.ArchiveStatus | |
| $userObj | Add-Member NoteProperty -Name "ArchiveState" -Value $Mbx.ArchiveState | |
| $userObj | Add-Member NoteProperty -Name "ArchiveQuota" -Value $Mbx.ArchiveQuota | |
| $userObj | Add-Member NoteProperty -Name "ArchiveTotalItemSize" -Value $ArchiveTotalItemSize | |
| $userObj | Add-Member NoteProperty -Name "ArchiveTotalItemCount" -Value $ArchiveTotalItemCount | |
| $output += $UserObj | |
| # Update Counters and Write Progress | |
| $i++ | |
| if ($AllMailbox.Count -ge 1) | |
| { | |
| Write-Progress -Activity "Scanning Mailboxes . . ." -Status "Scanned: $i of $($AllMailbox.Count)" -PercentComplete ($i/$AllMailbox.Count*100) | |
| } | |
| } | |
| $output | Export-csv -Path $CSVfile -NoTypeInformation -Encoding UTF8 | |
| ;Break} | |
| 4 { | |
| $i = 0 | |
| $CSVfile = Read-Host "Enter the Path of CSV file (Eg. C:\DG.csv)" | |
| $MailboxName = Read-Host "Enter the Mailbox name or Range (Eg. Mailboxname , Mi*,*Mik)" | |
| $AllMailbox = Get-mailbox $MailboxName -resultsize unlimited | |
| Foreach($Mbx in $AllMailbox) | |
| { | |
| $Stats = Get-mailboxStatistics -Identity $Mbx.distinguishedname -WarningAction SilentlyContinue | |
| if (($Mbx.UseDatabaseQuotaDefaults -eq $true) -and (Get-MailboxDatabase $mbx.Database).ProhibitSendReceiveQuota.value -eq $null) | |
| { | |
| $ProhibitSendReceiveQuota = "Unlimited" | |
| } | |
| if (($Mbx.UseDatabaseQuotaDefaults -eq $true) -and (Get-MailboxDatabase $mbx.Database).ProhibitSendReceiveQuota.value -ne $null) | |
| { | |
| $ProhibitSendReceiveQuota = (Get-MailboxDatabase $mbx.Database).ProhibitSendReceiveQuota.Value.ToMB() | |
| } | |
| if (($Mbx.UseDatabaseQuotaDefaults -eq $false) -and ($mbx.ProhibitSendReceiveQuota.value -eq $null)) | |
| { | |
| $ProhibitSendReceiveQuota = "Unlimited" | |
| } | |
| if (($Mbx.UseDatabaseQuotaDefaults -eq $false) -and ($mbx.ProhibitSendReceiveQuota.value -ne $null)) | |
| { | |
| $ProhibitSendReceiveQuota = $Mbx.ProhibitSendReceiveQuota.Value.ToMB() | |
| } | |
| if ($Mbx.ArchiveName.count -eq "0") | |
| { | |
| $ArchiveTotalItemSize = $null | |
| $ArchiveTotalItemCount = $null | |
| } | |
| if ($Mbx.ArchiveName -ge "1") | |
| { | |
| $MbxArchiveStats = Get-mailboxstatistics $Mbx.distinguishedname -Archive -WarningAction SilentlyContinue | |
| $ArchiveTotalItemSize = $MbxArchiveStats.TotalItemSize | |
| $ArchiveTotalItemCount = $MbxArchiveStats.BigFunnelMessageCount | |
| } | |
| $userObj = New-Object PSObject | |
| $userObj | Add-Member NoteProperty -Name "Display Name" -Value $mbx.displayname | |
| $userObj | Add-Member NoteProperty -Name "Alias" -Value $Mbx.Alias | |
| $userObj | Add-Member NoteProperty -Name "SamAccountName" -Value $Mbx.SamAccountName | |
| $userObj | Add-Member NoteProperty -Name "RecipientType" -Value $Mbx.RecipientTypeDetails | |
| $userObj | Add-Member NoteProperty -Name "Recipient OU" -Value $Mbx.OrganizationalUnit | |
| $userObj | Add-Member NoteProperty -Name "Primary SMTP address" -Value $Mbx.PrimarySmtpAddress | |
| $userObj | Add-Member NoteProperty -Name "Email Addresses" -Value ($Mbx.EmailAddresses.smtpaddress -join ";") | |
| $userObj | Add-Member NoteProperty -Name "Database" -Value $mbx.Database | |
| $userObj | Add-Member NoteProperty -Name "ServerName" -Value $mbx.ServerName | |
| if($Stats) | |
| { | |
| $userObj | Add-Member NoteProperty -Name "TotalItemSize" -Value $Stats.TotalItemSize.Value.ToMB() | |
| $userObj | Add-Member NoteProperty -Name "ItemCount" -Value $Stats.ItemCount | |
| $userObj | Add-Member NoteProperty -Name "DeletedItemCount" -Value $Stats.DeletedItemCount | |
| $userObj | Add-Member NoteProperty -Name "TotalDeletedItemSize" -Value $Stats.TotalDeletedItemSize.Value.ToMB() | |
| } | |
| $userObj | Add-Member NoteProperty -Name "ProhibitSendReceiveQuota-In-MB" -Value $ProhibitSendReceiveQuota | |
| $userObj | Add-Member NoteProperty -Name "UseDatabaseQuotaDefaults" -Value $Mbx.UseDatabaseQuotaDefaults | |
| $userObj | Add-Member NoteProperty -Name "LastLogonTime" -Value $Stats.LastLogonTime | |
| $userObj | Add-Member NoteProperty -Name "ArchiveName" -Value ($Mbx.ArchiveName -join ";") | |
| $userObj | Add-Member NoteProperty -Name "ArchiveStatus" -Value $Mbx.ArchiveStatus | |
| $userObj | Add-Member NoteProperty -Name "ArchiveState" -Value $Mbx.ArchiveState | |
| $userObj | Add-Member NoteProperty -Name "ArchiveQuota" -Value $Mbx.ArchiveQuota | |
| $userObj | Add-Member NoteProperty -Name "ArchiveTotalItemSize" -Value $ArchiveTotalItemSize | |
| $userObj | Add-Member NoteProperty -Name "ArchiveTotalItemCount" -Value $ArchiveTotalItemCount | |
| $output += $UserObj | |
| # Update Counters and Write Progress | |
| $i++ | |
| if ($AllMailbox.Count -ge 1) | |
| { | |
| Write-Progress -Activity "Scanning Mailboxes . . ." -Status "Scanned: $i of $($AllMailbox.Count)" -PercentComplete ($i/$AllMailbox.Count*100) | |
| } | |
| } | |
| $output | Export-csv -Path $CSVfile -NoTypeInformation -Encoding UTF8 | |
| ;Break} | |
| 5 { | |
| $MailboxName = Read-Host "Enter the Mailbox name or Range (Eg. Mailboxname , Mi*,*Mik)" | |
| $AllMailbox = Get-mailbox $MailboxName -resultsize unlimited | |
| Foreach($Mbx in $AllMailbox) | |
| { | |
| $Stats = Get-mailboxStatistics -Identity $Mbx.distinguishedname -WarningAction SilentlyContinue | |
| $userObj = New-Object PSObject | |
| $userObj | Add-Member NoteProperty -Name "Display Name" -Value $mbx.displayname | |
| $userObj | Add-Member NoteProperty -Name "Primary SMTP address" -Value $mbx.PrimarySmtpAddress | |
| $userObj | Add-Member NoteProperty -Name "TotalItemSize" -Value $Stats.TotalItemSize | |
| $userObj | Add-Member NoteProperty -Name "ItemCount" -Value $Stats.ItemCount | |
| Write-Output $Userobj | |
| } | |
| ;Break} | |
| 6 { | |
| $i = 0 | |
| $CSVfile = Read-Host "Enter the Path of CSV file (Eg. C:\Report.csv)" | |
| $AllMailbox = Get-mailbox -resultsize unlimited | |
| Foreach($Mbx in $AllMailbox) | |
| { | |
| $Stats = Get-mailboxStatistics -Identity $Mbx.distinguishedname -WarningAction SilentlyContinue | |
| if ($Mbx.ArchiveName.count -eq "0") | |
| { | |
| $ArchiveTotalItemSize = $null | |
| $ArchiveTotalItemCount = $null | |
| } | |
| if ($Mbx.ArchiveName -ge "1") | |
| { | |
| $MbxArchiveStats = Get-mailboxstatistics $Mbx.distinguishedname -Archive -WarningAction SilentlyContinue | |
| $ArchiveTotalItemSize = $MbxArchiveStats.TotalItemSize | |
| $ArchiveTotalItemCount = $MbxArchiveStats.BigFunnelMessageCount | |
| } | |
| $userObj = New-Object PSObject | |
| $userObj | Add-Member NoteProperty -Name "Display Name" -Value $mbx.displayname | |
| $userObj | Add-Member NoteProperty -Name "Alias" -Value $Mbx.Alias | |
| $userObj | Add-Member NoteProperty -Name "SamAccountName" -Value $Mbx.SamAccountName | |
| $userObj | Add-Member NoteProperty -Name "RecipientType" -Value $Mbx.RecipientTypeDetails | |
| $userObj | Add-Member NoteProperty -Name "Recipient OU" -Value $Mbx.OrganizationalUnit | |
| $userObj | Add-Member NoteProperty -Name "Primary SMTP address" -Value $Mbx.PrimarySmtpAddress | |
| $userObj | Add-Member NoteProperty -Name "Email Addresses" -Value ($Mbx.EmailAddresses -join ";") | |
| $userObj | Add-Member NoteProperty -Name "Database" -Value $Stats.Database | |
| $userObj | Add-Member NoteProperty -Name "ServerName" -Value $Stats.ServerName | |
| $userObj | Add-Member NoteProperty -Name "TotalItemSize" -Value $Stats.TotalItemSize | |
| $userObj | Add-Member NoteProperty -Name "ItemCount" -Value $Stats.ItemCount | |
| $userObj | Add-Member NoteProperty -Name "DeletedItemCount" -Value $Stats.DeletedItemCount | |
| $userObj | Add-Member NoteProperty -Name "TotalDeletedItemSize" -Value $Stats.TotalDeletedItemSize | |
| $userObj | Add-Member NoteProperty -Name "ProhibitSendReceiveQuota-In-MB" -Value $Mbx.ProhibitSendReceiveQuota | |
| $userObj | Add-Member NoteProperty -Name "UseDatabaseQuotaDefaults" -Value $Mbx.UseDatabaseQuotaDefaults | |
| $userObj | Add-Member NoteProperty -Name "LastLogonTime" -Value $Stats.LastLogonTime | |
| $userObj | Add-Member NoteProperty -Name "ArchiveName" -Value ($Mbx.ArchiveName -join ";") | |
| $userObj | Add-Member NoteProperty -Name "ArchiveStatus" -Value $Mbx.ArchiveStatus | |
| $userObj | Add-Member NoteProperty -Name "ArchiveState" -Value $Mbx.ArchiveState | |
| $userObj | Add-Member NoteProperty -Name "ArchiveQuota" -Value $Mbx.ArchiveQuota | |
| $userObj | Add-Member NoteProperty -Name "ArchiveTotalItemSize" -Value $ArchiveTotalItemSize | |
| $userObj | Add-Member NoteProperty -Name "ArchiveTotalItemCount" -Value $ArchiveTotalItemCount | |
| $output += $UserObj | |
| # Update Counters and Write Progress | |
| $i++ | |
| if ($AllMailbox.Count -ge 1) | |
| { | |
| Write-Progress -Activity "Scanning Mailboxes . . ." -Status "Scanned: $i of $($AllMailbox.Count)" -PercentComplete ($i/$AllMailbox.Count*100) | |
| } | |
| } | |
| $output | Export-csv -Path $CSVfile -NoTypeInformation -Encoding UTF8 | |
| ;Break} | |
| 7 { | |
| $i = 0 | |
| $CSVfile = Read-Host "Enter the Path of CSV file (Eg. C:\DG.csv)" | |
| $MailboxName = Read-Host "Enter the Mailbox name or Range (Eg. Mailboxname , Mi*,*Mik)" | |
| $AllMailbox = Get-mailbox $MailboxName -resultsize unlimited | |
| Foreach($Mbx in $AllMailbox) | |
| { | |
| $Stats = Get-mailboxStatistics -Identity $Mbx.distinguishedname -WarningAction SilentlyContinue | |
| if ($Mbx.ArchiveName.count -eq "0") | |
| { | |
| $ArchiveTotalItemSize = $null | |
| $ArchiveTotalItemCount = $null | |
| } | |
| if ($Mbx.ArchiveName -ge "1") | |
| { | |
| $MbxArchiveStats = Get-mailboxstatistics $Mbx.distinguishedname -Archive -WarningAction SilentlyContinue | |
| $ArchiveTotalItemSize = $MbxArchiveStats.TotalItemSize | |
| $ArchiveTotalItemCount = $MbxArchiveStats.BigFunnelMessageCount | |
| } | |
| $userObj = New-Object PSObject | |
| $userObj | Add-Member NoteProperty -Name "Display Name" -Value $mbx.displayname | |
| $userObj | Add-Member NoteProperty -Name "Alias" -Value $Mbx.Alias | |
| $userObj | Add-Member NoteProperty -Name "SamAccountName" -Value $Mbx.SamAccountName | |
| $userObj | Add-Member NoteProperty -Name "RecipientType" -Value $Mbx.RecipientTypeDetails | |
| $userObj | Add-Member NoteProperty -Name "Recipient OU" -Value $Mbx.OrganizationalUnit | |
| $userObj | Add-Member NoteProperty -Name "Primary SMTP address" -Value $Mbx.PrimarySmtpAddress | |
| $userObj | Add-Member NoteProperty -Name "Email Addresses" -Value ($Mbx.EmailAddresses -join ";") | |
| $userObj | Add-Member NoteProperty -Name "Database" -Value $Stats.Database | |
| $userObj | Add-Member NoteProperty -Name "ServerName" -Value $Stats.ServerName | |
| $userObj | Add-Member NoteProperty -Name "TotalItemSize" -Value $Stats.TotalItemSize | |
| $userObj | Add-Member NoteProperty -Name "ItemCount" -Value $Stats.ItemCount | |
| $userObj | Add-Member NoteProperty -Name "DeletedItemCount" -Value $Stats.DeletedItemCount | |
| $userObj | Add-Member NoteProperty -Name "TotalDeletedItemSize" -Value $Stats.TotalDeletedItemSize | |
| $userObj | Add-Member NoteProperty -Name "ProhibitSendReceiveQuota-In-MB" -Value $Mbx.ProhibitSendReceiveQuota | |
| $userObj | Add-Member NoteProperty -Name "UseDatabaseQuotaDefaults" -Value $Mbx.UseDatabaseQuotaDefaults | |
| $userObj | Add-Member NoteProperty -Name "LastLogonTime" -Value $Stats.LastLogonTime | |
| $userObj | Add-Member NoteProperty -Name "ArchiveName" -Value ($Mbx.ArchiveName -join ";") | |
| $userObj | Add-Member NoteProperty -Name "ArchiveStatus" -Value $Mbx.ArchiveStatus | |
| $userObj | Add-Member NoteProperty -Name "ArchiveState" -Value $Mbx.ArchiveState | |
| $userObj | Add-Member NoteProperty -Name "ArchiveQuota" -Value $Mbx.ArchiveQuota | |
| $userObj | Add-Member NoteProperty -Name "ArchiveTotalItemSize" -Value $ArchiveTotalItemSize | |
| $userObj | Add-Member NoteProperty -Name "ArchiveTotalItemCount" -Value $ArchiveTotalItemCount | |
| $output += $UserObj | |
| # Update Counters and Write Progress | |
| $i++ | |
| if ($AllMailbox.Count -ge 1) | |
| { | |
| Write-Progress -Activity "Scanning Mailboxes . . ." -Status "Scanned: $i of $($AllMailbox.Count)" -PercentComplete ($i/$AllMailbox.Count*100) -ErrorAction SilentlyContinue | |
| } | |
| } | |
| $output | Export-csv -Path $CSVfile -NoTypeInformation -Encoding UTF8 | |
| ;Break} | |
| Default {Write-Host "No matches found , Enter Options 1 or 2" -ForeGround "red"} | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment