Good afternoon!! Would anyone have a PS.1 script that would provide a list of all users, their department name, the number of emails in the mailbox, and the size of their mailbox?

This should workhttps://gallery.technet.microsoft.com/office/Generate-Mailbox-Size-and-3f408172Simply running ".\Get-MailboxReport.ps1 -all" should create a csv file in the same directory.

DeepakRandhawa Does this work for office 365/outlook mailboxes?

Name, Department, #of Emails, Mailbox Size

DeepakRandhawa
Iron Contributor
Feb 12, 2020
This should work
https://gallery.technet.microsoft.com/office/Generate-Mailbox-Size-and-3f408172

Simply running ".\Get-MailboxReport.ps1 -all" should create a csv file in the same directory.
- lpmdvip
  Copper Contributor
  Feb 12, 2020
  DeepakRandhawa Does this work for office 365/outlook mailboxes?

Erick A. Moreno R.

Iron Contributor

Feb 12, 2020

lpmdvip I wrote this, I hope it covers your requirements.
Just copy it to ISE Powershell and edit the folder/credentials/working paths and run it, the first time it will prompt you for your O365 creds, it will check the pssession status and open a new one(in case you have many MBXs). Let me know how it goes or if you have any questions.

 <#
.SYNOPSIS
    Get MBXs Stats, User Attribute(s), Folder(s) Counts
.DESCRIPTION
    
.NOTES
    Author:     Erick A. Moreno
    Email:      emoreno@request-script.com
    Date:       12 Jan 2020
    PowerShell: v3
.References
#requested: https://techcommunity.microsoft.com/t5/windows-powershell/name-department-of-emails-mailbox-size/m-p/1167911
#>

$CredentialsFolder = "D:\Credentials\"
$WorkingDir        = "C:\Users\erick\Desktop\LogsFolder"
$ScriptTime        = Get-Date -UFormat "%m%d%Y-%H%M"

#region Functions
Function _Get-Sessions
 {
  Param(
        [Parameter(Mandatory=$true)]$CredentialsFolder,
        [Parameter(Mandatory=$true)]$CredentialsFileName
       )
  
  #region Check for Credentials File
  $TargetCredPath = $CredentialsFolder #Credential XML File Location
  $TargetCredName = $TargetCredPath + $CredentialsFileName
  #Write-Host $TargetCredName
  If(Test-Path $TargetCredName)
   {
    $TargetCred = Import-Clixml $TargetCredName
   }
  Else
   {
    $Cred = Get-Credential 
    $Cred | Export-CliXml -Path $(Join-Path -path $TargetCredPath -ChildPath RemotePS.cred)
    $TargetCred = Import-Clixml $TargetCredName
   }
  #endregion
  #region connections
  $Session  = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://outlook.office365.com/powershell-liveid/ -Credential $TargetCred -Authentication Basic -AllowRedirection 
  $NoOutput = Import-PSSession $Session -AllowClobber -Prefix O365 -CommandName "*Mailbox*","*User*"
  #endregion
  Return  $Session
 }
#endregion
#region Open PS Sessions
$TenantSession = _Get-Sessions -CredentialsFolder $CredentialsFolder -CredentialsFileName RemotePS.cred
#endregion

$MBXs = Get-O365Mailbox -ResultSize Unlimited 

$Counter = $MBXs.count
$Results = @()
$Counter

Foreach($MBX in $MBXs)
 {
  #Start-Sleep -Milliseconds 300
  $PsSessionState = $(Get-PsSession $TenantSession.Id).State  
  If($($Counter/100) -match '^[0-9]+$' -or $PsSessionState -ne "Opened")
   {
    Remove-PSSession $TenantSession.Id -Confirm:$false
    Write-Host "Opening a new Session Each 100 iterations" -ForegroundColor Yellow
    $TenantSession = _Get-Sessions -CredentialsFolder $CredentialsFolder -CredentialsFileName RemotePS.cred
   }

  Write-Host "($Counter) Working On MBX: $($MBX.PrimarySmtpAddress)" -ForegroundColor Cyan
  $Stats       = $null
  $UserData    = $null
  $FolderItems = $null
  $UserData    = Get-O365User $MBX.PrimarySmtpAddress
  $Stats       = Get-O365MailboxStatistics -Identity $MBX.PrimarySmtpAddress
  $FolderItems = Get-O365MailboxFolderStatistics -Identity $MBX.PrimarySmtpAddress | Where {$_.Name -match “Inbox|Sent Items|Deleted Items|Junk E-Mail”} | Select Name,ItemsInFolder #Add Folders as needed
  
  $Properties  = [Ordered]@{
                            DisplayName        = $MBX.DisplayName
                            Department         = $UserData.Department #Add properties as needed
                            UserPrincipalName  = $MBX.UserPrincipalName
                            MailboxSizeMB      = [math]::Round($($Stats.TotalItemSize.Value.ToString().Split("(")[1].Split(" ")[0].Replace(",","")/1MB),4)
                            MailboxSizeGB      = [math]::Round($($Stats.TotalItemSize.Value.ToString().Split("(")[1].Split(" ")[0].Replace(",","")/1GB),4)
                            InboxItems         = $($FolderItems | where{$_.Name -eq "Inbox"}).ItemsInFolder
                            SentItems          = $($FolderItems | where{$_.Name -eq "Sent Items"}).ItemsInFolder
                            DeletedItems       = $($FolderItems | where{$_.Name -eq "Deleted Items"}).ItemsInFolder
                            JunkItems          = $($FolderItems | where{$_.Name -eq "Junk E-Mail"}).ItemsInFolder
                            PrimarySMTPAddress = $MBX.PrimarySmtpAddress
                           }

  $Results += New-Object PSObject -Property $Properties
  
  $Counter--
 }

 $Results | Export-Csv -Path "$WorkingDir\ReportMBXsStats_$ScriptTime.csv" -NoTypeInformation -Encoding UTF8 -Force

 Write-Host "Report Saved To: $WorkingDir\ReportMBXsStats_$ScriptTime.csv" -ForegroundColor Cyan

lpmdvip

Copper Contributor

Feb 12, 2020

Erick A. Moreno R. Thanks Erick! I'm running it now to see what it displays in the CSV.

Would you be able to add a condition where the Department field is not blank?

Erick A. Moreno R.

Iron Contributor

Feb 12, 2020

lpmdvip Sure, here you have.

 <#
.SYNOPSIS
    Get MBXs Stats, User Attribute(s), Folder(s) Counts
.DESCRIPTION
    
.NOTES
    Author:     Erick A. Moreno
    Email:      emoreno@request-script.com
    Date:       12 Jan 2020
    PowerShell: v3
.References
#requested: https://techcommunity.microsoft.com/t5/windows-powershell/name-department-of-emails-mailbox-size/m-p/1167911
#>

$CredentialsFolder = "D:\Credentials\"
$WorkingDir        = "C:\Users\erick\Desktop\LogsFolder"
$ScriptTime        = Get-Date -UFormat "%m%d%Y-%H%M"

#region Functions
Function _Get-Sessions
 {
  Param(
        [Parameter(Mandatory=$true)]$CredentialsFolder,
        [Parameter(Mandatory=$true)]$CredentialsFileName
       )
  
  #region Check for Credentials File
  $TargetCredPath = $CredentialsFolder #Credential XML File Location
  $TargetCredName = $TargetCredPath + $CredentialsFileName
  #Write-Host $TargetCredName
  If(Test-Path $TargetCredName)
   {
    $TargetCred = Import-Clixml $TargetCredName
   }
  Else
   {
    $Cred = Get-Credential 
    $Cred | Export-CliXml -Path $(Join-Path -path $TargetCredPath -ChildPath RemotePS.cred)
    $TargetCred = Import-Clixml $TargetCredName
   }
  #endregion
  #region connections
  $Session  = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://outlook.office365.com/powershell-liveid/ -Credential $TargetCred -Authentication Basic -AllowRedirection 
  $NoOutput = Import-PSSession $Session -AllowClobber -Prefix O365 -CommandName "*Mailbox*","*User*"
  #endregion
  Return  $Session
 }
#endregion
#region Open PS Sessions
$TenantSession = _Get-Sessions -CredentialsFolder $CredentialsFolder -CredentialsFileName RemotePS.cred
#endregion

$MBXs = Get-O365Mailbox -ResultSize Unlimited 

$Counter = $MBXs.count
$Results = @()
$NoDepartment = @()
$Counter

Foreach($MBX in $MBXs)
 {
  #Start-Sleep -Milliseconds 300
  $PsSessionState = $(Get-PsSession $TenantSession.Id).State  
  If($($Counter/100) -match '^[0-9]+$' -or $PsSessionState -ne "Opened")
   {
    Remove-PSSession $TenantSession.Id -Confirm:$false
    Write-Host "Opening a new Session Each 100 iterations" -ForegroundColor Yellow
    $TenantSession = _Get-Sessions -CredentialsFolder $CredentialsFolder -CredentialsFileName RemotePS.cred
   }

  Write-Host "($Counter) Working On MBX: $($MBX.PrimarySmtpAddress)" -ForegroundColor Cyan
  $Stats       = $null
  $UserData    = $null
  $FolderItems = $null
  $UserData    = Get-O365User $MBX.PrimarySmtpAddress

  If(![string]::IsNullOrEmpty($($UserData.Department)))
   {
    $Stats       = Get-O365MailboxStatistics -Identity $MBX.PrimarySmtpAddress
    $FolderItems = Get-O365MailboxFolderStatistics -Identity $MBX.PrimarySmtpAddress | Where {$_.Name -match “Inbox|Sent Items|Deleted Items|Junk E-Mail”} | Select Name,ItemsInFolder #Add Folders as needed
    
    $Properties  = [Ordered]@{
                              DisplayName        = $MBX.DisplayName
                              Department         = $UserData.Department #Add properties as needed
                              UserPrincipalName  = $MBX.UserPrincipalName
                              MailboxSizeMB      = [math]::Round($($Stats.TotalItemSize.Value.ToString().Split("(")[1].Split(" ")[0].Replace(",","")/1MB),4)
                              MailboxSizeGB      = [math]::Round($($Stats.TotalItemSize.Value.ToString().Split("(")[1].Split(" ")[0].Replace(",","")/1GB),4)
                              InboxItems         = $($FolderItems | where{$_.Name -eq "Inbox"}).ItemsInFolder
                              SentItems          = $($FolderItems | where{$_.Name -eq "Sent Items"}).ItemsInFolder
                              DeletedItems       = $($FolderItems | where{$_.Name -eq "Deleted Items"}).ItemsInFolder
                              JunkItems          = $($FolderItems | where{$_.Name -eq "Junk E-Mail"}).ItemsInFolder
                              PrimarySMTPAddress = $MBX.PrimarySmtpAddress
                             }
    
    $Results += New-Object PSObject -Property $Properties
   }
  Else
   {
    Write-Host "Department Field is Empty Skipping MBX: $($MBX.PrimarySmtpAddress)"
    $NoDepartment += $($MBX.PrimarySmtpAddress)
   }
  $Counter--
 }

 $Results | Export-Csv -Path "$WorkingDir\ReportMBXsStats_$ScriptTime.csv" -NoTypeInformation -Encoding UTF8 -Force
 $NoDepartment | Export-Csv -Path "$WorkingDir\NoDepartmentField_$ScriptTime.csv" -NoTypeInformation -Encoding UTF8 -Force
 Write-Host "Report Saved To: $WorkingDir\ReportMBXsStats_$ScriptTime.csv" -ForegroundColor Cyan
 Write-Host "Report Saved To: $WorkingDir\NoDepartmentField_$ScriptTime.csv" -ForegroundColor Cyan

Forum Discussion

Name, Department, #of Emails, Mailbox Size

Share

Resources