Create report for mailbox usage space by email domain in Powershell 365 hosted? Tenant has multiple domains

Boe Dillard 666

Hello,

I have a tenant with multiple domains. I have a script to export the list of users and their mailbox size but it mixes all the users and their main domain with users belonging to another company in the same domain. Is it possible to have it sort it by their login name or primary email address so all the users at acme.com show up in one list and all the users in @widgets.com show up in a seperate section or sheet? I'm also fine if there is a way of searching specifically e.g. add a line to the script so it only pulls the info for users @acme.com

Open powershell AS ADMINISTRATOR with 365/azure connect

Set-ExecutionPolicy RemoteSigned

$UserCredential = Get-Credential

$Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://outlook.office365.com/powershell-liveid/ -Credential $UserCredential -Authentication Basic -AllowRedirection
Import-PSSession $Session -DisableNameChecking
Set-ExecutionPolicy RemoteSigned

admin@acme.... (whatever account you use)

Password for account

Write-Host "Gathering Stats, Please Wait.."
$Mailboxes = Get-Mailbox -ResultSize Unlimited | Select UserPrincipalName, identity, ArchiveStatus
$MailboxSizes = @()
foreach ($Mailbox in $Mailboxes) {
$ObjProperties = New-Object PSObject
$MailboxStats = Get-MailboxStatistics $Mailbox.UserPrincipalname | Select DisplayName, LastLogonTime, TotalItemSize, ItemCount
Add-Member -InputObject $ObjProperties -MemberType NoteProperty -Name "Display Name" -Value $MailboxStats.DisplayName
Add-Member -InputObject $ObjProperties -MemberType NoteProperty -Name "UserPrincipalName" -Value $Mailbox.UserPrincipalName
Add-Member -InputObject $ObjProperties -MemberType NoteProperty -Name "Last Logged In" -Value $MailboxStats.LastLogonTime
Add-Member -InputObject $ObjProperties -MemberType NoteProperty -Name "Mailbox Size (GB)" -Value ([math]::Round(($MailboxStats.TotalItemSize.ToString().Split("(")[1].Split(" ")[0].Replace(",","")/1GB),2))

if ($Mailbox.ArchiveStatus -eq "Active") {
$ArchiveStats = Get-MailboxStatistics $Mailbox.UserPrincipalname -Archive | Select TotalItemSize, ItemCount
Add-Member -InputObject $ObjProperties -MemberType NoteProperty -Name "Archive Size (GB)" -Value ([math]::Round(($ArchiveStats.TotalItemSize.ToString().Split("(")[1].Split(" ")[0].Replace(",","")/1GB),2))
}
else {
Add-Member -InputObject $ObjProperties -MemberType NoteProperty -Name "Archive Size (GB)" -Value "0"

}
$MailboxSizes += $ObjProperties
}
$MailboxSizes | Export-csv "C:\inboxsizes.csv" -NoTypeInformation

Get-PSSession | Remove-PSSession

Aholic Liang-MSFT 13,826 Reputation points Microsoft Vendor

2023-03-14T06:47:13.5033333+00:00

Hi @ Boe Dillard ,

Just checking in to see how things are going on with this thread.

If the reply was helpful, you can click the "Accept Answer" button under this post so that other's with similar question can benefit from this thread as well.

If you still have further questions or concerns, feel free to post back.

3 answers

AhmedAli Shaik 80 Reputation points

2023-03-07T16:55:49.0433333+00:00

Please try the below:

Write-Host "Gathering Stats, Please Wait.."

$Mailboxes = Get-Mailbox -ResultSize Unlimited | Select UserPrincipalName, identity, ArchiveStatus

$MailboxSizes = @()

foreach ($Mailbox in $Mailboxes) {

$Domain = $mailbox.PrimarySmtpAddress -split '@'

$ObjProperties = New-Object PSObject

$MailboxStats = Get-MailboxStatistics $Mailbox.UserPrincipalname | Select DisplayName, LastLogonTime, TotalItemSize, ItemCount

Add-Member -InputObject $ObjProperties -MemberType NoteProperty -Name "Display Name" -Value $MailboxStats.DisplayName

Add-Member -InputObject $ObjProperties -MemberType NoteProperty -Name "UserPrincipalName" -Value $Mailbox.UserPrincipalName

Add-Member -InputObject $ObjProperties -MemberType NoteProperty -Name "Last Logged In" -Value $MailboxStats.LastLogonTime

Add-Member -InputObject $ObjProperties -MemberType NoteProperty -Name "Mailbox Size (GB)" -Value ([math]::Round(($MailboxStats.TotalItemSize.ToString().Split("(")[1].Split(" ")[0].Replace(",","")/1GB),2))

Add-Member -InputObject $ObjProperties -MemberType NoteProperty -Name "Email Address" -Value $Mailbox.PrimarySmtpAddress

Add-Member -InputObject $ObjProperties -MemberType NoteProperty -Name "Domain" -Value $Domain[1]

if ($Mailbox.ArchiveStatus -eq "Active") {

$ArchiveStats = Get-MailboxStatistics $Mailbox.UserPrincipalname -Archive | Select TotalItemSize, ItemCount

Add-Member -InputObject $ObjProperties -MemberType NoteProperty -Name "Archive Size (GB)" -Value ([math]::Round(($ArchiveStats.TotalItemSize.ToString().Split("(")[1].Split(" ")[0].Replace(",","")/1GB),2))

}

else {

Add-Member -InputObject $ObjProperties -MemberType NoteProperty -Name "Archive Size (GB)" -Value "0"

}

$MailboxSizes += $ObjProperties

$MailboxReport = $MailboxSizes | sort-Object Domain

}

$MailboxSizes | Export-csv "C:\inboxsizes.csv" -NoTypeInformation

Get-PSSession | Remove-PSSession
Please sign in to rate this answer.
Boe Dillard 666 Reputation points

2023-03-07T17:43:13.11+00:00

Thanks - unfortunately it did not sort them by domain.

Is there a way to restrict it to one domain? Sorting or restricting would be fine.

AhmedAli Shaik 80 Reputation points

2023-03-07T18:06:49.7433333+00:00

Sort:

Please replace the below line

$MailboxSizes | Export-csv "C:\inboxsizes.csv" -NoTypeInformation

with

$MailboxReport | Export-csv "C:\inboxsizes.csv" -NoTypeInformation

To exclude the domain - Please change the domain name in the quotes you want to restrict
$MailboxReport | ? { $_.Domain -notcontains "Domain.com"} | Export-csv "C:\inboxsizes.csv" -NoTypeInformation
Sign in to comment
Boe Dillard 666 Reputation points

2023-03-07T18:12:51.57+00:00

Thanks - I tried this - I only want users with an acme.com domain email but got nothing. There are several domains so instead of saying not onedomain, I thought I'd try to get the only domain I care about.

Connect-ExchangeOnline

Write-Host "Gathering Stats, Please Wait.."

$Mailboxes = Get-Mailbox -ResultSize Unlimited | Select UserPrincipalName, identity, ArchiveStatus

$MailboxSizes = @()

foreach ($Mailbox in $Mailboxes) {

$Domain = $mailbox.PrimarySmtpAddress -split '@'

$ObjProperties = New-Object PSObject

$MailboxStats = Get-MailboxStatistics $Mailbox.UserPrincipalname | Select DisplayName, LastLogonTime, TotalItemSize, ItemCount

Add-Member -InputObject $ObjProperties -MemberType NoteProperty -Name "Display Name" -Value $MailboxStats.DisplayName

Add-Member -InputObject $ObjProperties -MemberType NoteProperty -Name "UserPrincipalName" -Value $Mailbox.UserPrincipalName

Add-Member -InputObject $ObjProperties -MemberType NoteProperty -Name "Last Logged In" -Value $MailboxStats.LastLogonTime

Add-Member -InputObject $ObjProperties -MemberType NoteProperty -Name "Mailbox Size (GB)" -Value ([math]::Round(($MailboxStats.TotalItemSize.ToString().Split("(")[1].Split(" ")[0].Replace(",","")/1GB),2))

Add-Member -InputObject $ObjProperties -MemberType NoteProperty -Name "Email Address" -Value $Mailbox.PrimarySmtpAddress

Add-Member -InputObject $ObjProperties -MemberType NoteProperty -Name "Domain" -Value $Domain[1]

if ($Mailbox.ArchiveStatus -eq "Active") {

$ArchiveStats = Get-MailboxStatistics $Mailbox.UserPrincipalname -Archive | Select TotalItemSize, ItemCount

Add-Member -InputObject $ObjProperties -MemberType NoteProperty -Name "Archive Size (GB)" -Value ([math]::Round(($ArchiveStats.TotalItemSize.ToString().Split("(")[1].Split(" ")[0].Replace(",","")/1GB),2))

}

else {

Add-Member -InputObject $ObjProperties -MemberType NoteProperty -Name "Archive Size (GB)" -Value "0"

}

$MailboxSizes += $ObjProperties

$MailboxReport = $MailboxSizes | sort-Object Domain

}

$MailboxReport | ? { $_.Domain -contains "acme.com"} | Export-csv "C:\temp\inboxsizes.csv" -NoTypeInformation

Get-PSSession | Remove-PSSession
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Rich Matheisen 45,906

I neatened up your code a little bit. I replaced the New-Object and Add-Member cmdlets and used a hash to organize the values. I also replaced the Select-Object after the Get-Mailbox and Get-MailboxStatistics. There's no need to add additional pipelines to create new objects that are ephemeral and hold values already present in another object.

I don't have access to an Exchange O365 environment so the code hasn't been run by me.

EDIT: added "-Properties" to Get-Mailbox. Moved Get-MailboxStatistics immediately below ForEach-Object.

Edit2: PrimaySmtpAddress is not a property of a mailbox. Remove -Properties from Get-Mailbox. Added code to extract the primary smtp address from emailaddresses property.

Edit3: email addresses is an array of strings. Look for uppercase SMTP as indicator of the primary address.

Edit4: Replaced doublequote with colon in 'SMTP"' (should be 'SMTP:')

Connect-ExchangeOnline
Write-Host "Gathering Stats, Please Wait.."
Get-Mailbox -ResultSize Unlimited |
    ForEach-Object{
        $PrimarySMtpAddress = "NoAddress@Local.Domain"      # used as a filler if no primary smtp present
        foreach ( $a in ($_ | Select-Object -ExpandProperty emailAddresses) ){
            if ($a -clike 'SMTP:*'){                     # a case-sensitive comparison to find the primary SMTP address
                $PrimarySmtpAddress = ($a -split ":")[1]
                break
            }
        }
        $MailboxStats = Get-MailboxStatistics $_.UserPrincipalname
        $props = [ordered]@{                
            "Display Name" = $_.DisplayName
            UserPrincipalName = $_.UserPrincipalName
            "Last Logged In" = $MailboxStats.LastLogonTime         # Very likely to be inaccurate
            "Mailbox Size (GB)" = 0
            "Email Address" = $PrimarySmtpAddress
            Domain = ($PrimarySmtpAddress -split '@')[1]
            "Archive Size (GB)" = 0
            "Archive Total Items" = 0
        }
        $props."Mailbox Size (GB)" = ([math]::Round(($MailboxStats.TotalItemSize.ToString().Split("(")[1].Split(" ")[0].Replace(",", "") / 1GB), 2))
        if ($_.ArchiveStatus -eq "Active"){
            $ArchiveStats = Get-MailboxStatistics $_.UserPrincipalname -Archive
            $props."Archive Size (GB)" = ([math]::Round(($ArchiveStats.TotalItemSize.ToString().Split("(")[1].Split(" ")[0].Replace(",", "") / 1GB), 2))
            $props."Total Items" = $ArchiveStats.totalitems
        }
        [PSCustomObject]$props
    } | Where-Object ($_.Domain -eq "Acme.com") | 
            Export-Csv "C:\temp\inboxsizes.csv" -NoTypeInformation
Get-PSSession | Remove-PSSession

Boe Dillard 666 Reputation points

2023-03-07T20:55:43.7+00:00

You are currently using an older version of the Exchange Online PowerShell module which uses RPS.

I went to https://www.powershellgallery.com/packages/ExchangeOnlinemanagement/3.1.0

Install-Module -Name ExchangeOnlineManagement -RequiredVersion 3.1.0

Still comes back with the same issue even after closing and reopening powershell.
Rich Matheisen 45,906 Reputation points

2023-03-07T22:15:56.1066667+00:00

Well, I'm not using anything. I don't have access to an O365 Exchange organization. :-)

Can you explain in more detail what you mean by this: "mixes all the users and their main domain with users belonging to another company in the same domain".

Are you referring to an Active Directory domain, or to a DNS domain?

How are the two groups of users distinguishable from one another? Are the users in different organizational units? Do they have different company names as a property of their AD User objects?
Boe Dillard 666 Reputation points

2023-03-07T23:36:11.2633333+00:00

Thanks, I appreciate the help - I'm way out of my league.

I'd love it sorted by their ad domain or restricated to one AD domain.

Let's say I have one tenant

Your email might be joey@acme.com or mary and widgets.com or chris@anvils.com

Currently when I run the job, I get

Display name - column filled

Userprincipal name - filled with email address

Last logged in - filled with dates

Mailbox size - in GB - so anwhere from .3 to 49.

Email address column is blank

Domain is blank

Archive size - mostly zero but some very large ones as well

It sorts alphabetically by their display name - first column and it doesn't show their ad user domain which is what I need it sorted by most of all.

e.g.

Angel angela@acme.com 10/4/21 .03 space space 0

andrew andrew@widgets.com 1/4/22 20 space space 0

bart bartl@widgets.com 1/28/23/ 40 space space 0

bob bob@acme.com 1/14/23 10 space space 80
Rich Matheisen 45,906 Reputation points

2023-03-08T02:42:17.53+00:00

I modified my earlier answer. Try rerunning it and see if it corrects the problem.

I don't think, based on your description of the empty email address and domain, that the PrimarySmtpAddress i part of the default properties returned by the Get-Mailbox cmdlet.

Boe Dillard 666

Thanks so much for hanging in there

et-Mailbox : A parameter cannot be found that matches parameter name 'Properties'.
At line:1 char:35
+ Get-Mailbox -ResultSize Unlimited -Properties SmtpPrimaryAddress,Last ...
+                                   ~~~~~~~~~~~
    + CategoryInfo          : InvalidArgument: (:) [Get-Mailbox], ParameterBindingException
    + FullyQualifiedErrorId : NamedParameterNotFound,Get-Mailbox

Rich Matheisen 45,906 Reputation points

2023-03-08T19:24:54.3133333+00:00

Looks like "PrimarySmtpAddress" isn't a property. I modified and reposted my previous code to get the primary smtp proxy address from the emailAddresses property.
Boe Dillard 666 Reputation points

2023-03-08T19:42:38.4666667+00:00

I can't thank you enough - I realize this has been a journey for you.
Rich Matheisen 45,906 Reputation points

2023-03-08T22:27:29.6766667+00:00

Go ahead and mark my answer as the answer to your question. It might be useful to someone else. :-)

Journey? Heh, yeah . . . a journey down memory lane! I spent 16 years as an Exchange Server MVP and managed a multi-national companys' Exchange organization and Microsofts' old IM system (the one predating their Skype for Business). Eight years of retirement's caused a bit of brain leakage.
Boe Dillard 666 Reputation points

2023-03-08T22:48:54.8066667+00:00

Sorry - I wish that was it but unfortunately it just comes out with an empty excel file. Is that filter for the domain or the AD unit?
Boe Dillard 666 Reputation points

2023-03-08T23:16:13.8766667+00:00

Unfortunately it returns a blank spreadsheet? Is the acme the email domain or the AD domain?
Rich Matheisen 45,906 Reputation points

2023-03-08T23:51:59.7133333+00:00

The "Where-Object" at the end? It's for the domain part of the mailbox primary smtp proxy address (the stuff to the right of the "@"). If you think that's the problem, remove the Where-Object and see if the result is different.

If you want the AD domain, that can be extracted from the distinguishedName. The "DC=a,DC=b,DC=c" at the end of the DN can be turned into "a.b.c" easily enough.
Boe Dillard 666 Reputation points

2023-03-09T01:11:44.3066667+00:00

Thanks - I'd love a working version for both but I'll keep at it. The original script does return results however it doesn't seperate them.

I'll try it without the entire where object line and see how it goes.
Boe Dillard 666 Reputation points

2023-03-09T01:18:10.4333333+00:00

I tried it without the where object line and it did display all the accounts on the screen but then it came up with this :

Last Logged In : 3/8/2023 2:32:09 PM

Mailbox Size (GB) : 0

Email Address : NoAddress@Local.Domain

Domain : Local.Domain

Archive Size (GB) : 0

Archive Total Items : 0

PS C:\WINDOWS\system32> Export-Csv "C:\temp\inboxsizes.csv" -NoTypeInform

cmdlet Export-Csv at command pipeline position 1

Supply values for the following parameters:

InputObject:
Rich Matheisen 45,906 Reputation points

2023-03-09T02:43:55.6966667+00:00

If you removed the | Where-Object ($_.Domain -eq "Acme.com") | (including both "pipe" symbols) that's why you're prompted for an InputObject. You need to leave one of the "|" symbols in order for the output to be piped into the Export-CSV cmdlet.

Did all of the other mailboxes report a "NoAddress@Local.Domain" as the SMTP address? If so, that implies that the selection of the primary smtp address isn't working. As I have no Exchange server to work with you're going to have to do some investigating.
Boe Dillard 666 Reputation points

2023-03-09T03:17:19.4233333+00:00

Thanks if I remove that script line but leave the pipe it does create a full spreadsheet with mixed domain results sorted by display name. THey did have that noaddress@localdomain.

Boe Dillard 666

I did find this - no idead how to shove it into the script but I'll try.

Get-Recipient -ResultSize unlimited| Where {$_.EmailAddresses -like "*@acme.com"} | FL DisplayName,EmailAddresses

I tried but I get the message

Export-Csv : The process cannot access the file 'C:\temp\inboxsizes.csv' because it is being used by another process

Connect-ExchangeOnline
Write-Host "Gathering Stats, Please Wait.."
Get-Mailbox -ResultSize Unlimited |
    ForEach-Object{
        $PrimarySMtpAddress = "NoAddress@Local.Domain"      # used as a filler if no primary smtp present
        foreach ( $a in ($_ | Select-Object -ExpandProperty emailAddresses) ){
            if ($a.Prefix -eq 'smtp' -and $a.IsPrimaryAddress){
                $PrimarySmtpAddress = $a.SmtpAddress
            }
        }
        $MailboxStats = Get-MailboxStatistics $_.UserPrincipalname
        $props = [ordered]@{                
            "Display Name" = $_.DisplayName
            UserPrincipalName = $_.UserPrincipalName
            "Last Logged In" = $MailboxStats.LastLogonTime         # Very likely to be inaccurate
            "Mailbox Size (GB)" = 0
            "Email Address" = $PrimarySmtpAddress
            Domain = ($PrimarySmtpAddress -split '@')[1]
            "Archive Size (GB)" = 0
            "Archive Total Items" = 0
        }
        $props."Mailbox Size (GB)" = ([math]::Round(($MailboxStats.TotalItemSize.ToString().Split("(")[1].Split(" ")[0].Replace(",", "") / 1GB), 2))
        if ($_.ArchiveStatus -eq "Active"){
            $ArchiveStats = Get-MailboxStatistics $_.UserPrincipalname -Archive
            $props."Archive Size (GB)" = ([math]::Round(($ArchiveStats.TotalItemSize.ToString().Split("(")[1].Split(" ")[0].Replace(",", "") / 1GB), 2))
            $props."Total Items" = $ArchiveStats.totalitems
        }
        [PSCustomObject]$props
    } | Where {$_.EmailAddresses -like "*@acme.com"} | 
            Export-Csv "C:\temp\inboxsizes.csv" -NoTypeInformation
Get-PSSession | Remove-PSSession

Boe Dillard 666

I also tried this and it output nothing

but the single line Get-Recipient -ResultSize unlimited| Where {$_.EmailAddresses -like "*@acme.com"} | FL DisplayName,EmailAddresses - works but I don't get the maibox sizes in gb.

Connect-ExchangeOnline

Write-Host "Gathering Stats, Please Wait.."
Get-Mailbox -ResultSize Unlimited |
    ForEach-Object{
        $PrimarySMtpAddress = "NoAddress@Local.Domain"      # used as a filler if no primary smtp present
        foreach ( $a in ($_ | Select-Object -ExpandProperty emailAddresses) ){
            if ($a.Prefix -eq 'smtp' -and $a.IsPrimaryAddress){
                $PrimarySmtpAddress = $a.SmtpAddress
            }
        }
        $MailboxStats = Get-MailboxStatistics $_.UserPrincipalname
        $props = [ordered]@{                
            "Display Name" = $_.DisplayName
            UserPrincipalName = $_.UserPrincipalName
            "Last Logged In" = $MailboxStats.LastLogonTime         # Very likely to be inaccurate
            "Mailbox Size (GB)" = 0
            "Email Address" = $PrimarySmtpAddress
            Domain = ($PrimarySmtpAddress -split '@')[1]
            "Archive Size (GB)" = 0
            "Archive Total Items" = 0
        }
        $props."Mailbox Size (GB)" = ([math]::Round(($MailboxStats.TotalItemSize.ToString().Split("(")[1].Split(" ")[0].Replace(",", "") / 1GB), 2))
        if ($_.ArchiveStatus -eq "Active"){
            $ArchiveStats = Get-MailboxStatistics $_.UserPrincipalname -Archive
            $props."Archive Size (GB)" = ([math]::Round(($ArchiveStats.TotalItemSize.ToString().Split("(")[1].Split(" ")[0].Replace(",", "") / 1GB), 2))
            $props."Total Items" = $ArchiveStats.totalitems
        }
        [PSCustomObject]$props
    } | Where {$_.EmailAddresses -like "*@acme.com"} | FL
           
Get-PSSession | Remove-PSSession

Rich Matheisen 45,906 Reputation points

2023-03-09T03:42:35.1166667+00:00
Hmmm. I'm thinking that you're getting a deserialized object from the Get-Mailbox instead of an object that contains the real properties. In other words, you're getting text (isn't that the reason you're having to process the mailbox size as if it were text instead of an integer value?).

Try this with just a single mailbox:

$x = Get-Mailbox <mailbox name> $x.emailaddresses.gettype() $y = $x | Select-Object -Expand emailaddresses $y.gettype() $y[0].gettype() $y[0]|gm * $y[0]|fl *
Rich Matheisen 45,906 Reputation points

2023-03-09T03:44:04.0433333+00:00

You probably have the CSV opened in Excel.

Boe Dillard 666

I'll be honest I haven't a clue https://www.youtube.com/watch?v=INmU1uyqbjY

PS C:\WINDOWS\system32> $x.emailaddresses.gettype()

IsPublic IsSerial Name                                     BaseType
-------- -------- ----                                     --------
True     True     ArrayList                                System.Object


PS C:\WINDOWS\system32> $y = $x | Select-Object -Expand emailaddresses
PS C:\WINDOWS\system32> $y.gettype()

IsPublic IsSerial Name                                     BaseType
-------- -------- ----                                     --------
True     True     Object[]                                 System.Array


PS C:\WINDOWS\system32> $y[0].gettype()

IsPublic IsSerial Name                                     BaseType
-------- -------- ----                                     --------
True     True     String                                   System.Object


PS C:\WINDOWS\system32> $y[0]|gm *


   TypeName: System.String

Name             MemberType            Definition
----             ----------            ----------
Clone            Method                System.Object Clone(), System.Object ICloneable.Clone()
CompareTo        Method                int CompareTo(System.Object value), int CompareTo(string strB), int IComparab...
Contains         Method                bool Contains(string value)
CopyTo           Method                void CopyTo(int sourceIndex, char[] destination, int destinationIndex, int co...
EndsWith         Method                bool EndsWith(string value), bool EndsWith(string value, System.StringCompari...
Equals           Method                bool Equals(System.Object obj), bool Equals(string value), bool Equals(string...
GetEnumerator    Method                System.CharEnumerator GetEnumerator(), System.Collections.IEnumerator IEnumer...
GetHashCode      Method                int GetHashCode()
GetType          Method                type GetType()
GetTypeCode      Method                System.TypeCode GetTypeCode(), System.TypeCode IConvertible.GetTypeCode()
IndexOf          Method                int IndexOf(char value), int IndexOf(char value, int startIndex), int IndexOf...
IndexOfAny       Method                int IndexOfAny(char[] anyOf), int IndexOfAny(char[] anyOf, int startIndex), i...
Insert           Method                string Insert(int startIndex, string value)
IsNormalized     Method                bool IsNormalized(), bool IsNormalized(System.Text.NormalizationForm normaliz...
LastIndexOf      Method                int LastIndexOf(char value), int LastIndexOf(char value, int startIndex), int...
LastIndexOfAny   Method                int LastIndexOfAny(char[] anyOf), int LastIndexOfAny(char[] anyOf, int startI...
Normalize        Method                string Normalize(), string Normalize(System.Text.NormalizationForm normalizat...
PadLeft          Method                string PadLeft(int totalWidth), string PadLeft(int totalWidth, char paddingChar)
PadRight         Method                string PadRight(int totalWidth), string PadRight(int totalWidth, char padding...
Remove           Method                string Remove(int startIndex, int count), string Remove(int startIndex)
Replace          Method                string Replace(char oldChar, char newChar), string Replace(string oldValue, s...
Split            Method                string[] Split(Params char[] separator), string[] Split(char[] separator, int...
StartsWith       Method                bool StartsWith(string value), bool StartsWith(string value, System.StringCom...
Substring        Method                string Substring(int startIndex), string Substring(int startIndex, int length)
ToBoolean        Method                bool IConvertible.ToBoolean(System.IFormatProvider provider)
ToByte           Method                byte IConvertible.ToByte(System.IFormatProvider provider)
ToChar           Method                char IConvertible.ToChar(System.IFormatProvider provider)
ToCharArray      Method                char[] ToCharArray(), char[] ToCharArray(int startIndex, int length)
ToDateTime       Method                datetime IConvertible.ToDateTime(System.IFormatProvider provider)
ToDecimal        Method                decimal IConvertible.ToDecimal(System.IFormatProvider provider)
ToDouble         Method                double IConvertible.ToDouble(System.IFormatProvider provider)
ToInt16          Method                int16 IConvertible.ToInt16(System.IFormatProvider provider)
ToInt32          Method                int IConvertible.ToInt32(System.IFormatProvider provider)
ToInt64          Method                long IConvertible.ToInt64(System.IFormatProvider provider)
ToLower          Method                string ToLower(), string ToLower(cultureinfo culture)
ToLowerInvariant Method                string ToLowerInvariant()
ToSByte          Method                sbyte IConvertible.ToSByte(System.IFormatProvider provider)
ToSingle         Method                float IConvertible.ToSingle(System.IFormatProvider provider)
ToString         Method                string ToString(), string ToString(System.IFormatProvider provider), string I...
ToType           Method                System.Object IConvertible.ToType(type conversionType, System.IFormatProvider...
ToUInt16         Method                uint16 IConvertible.ToUInt16(System.IFormatProvider provider)
ToUInt32         Method                uint32 IConvertible.ToUInt32(System.IFormatProvider provider)
ToUInt64         Method                uint64 IConvertible.ToUInt64(System.IFormatProvider provider)
ToUpper          Method                string ToUpper(), string ToUpper(cultureinfo culture)
ToUpperInvariant Method                string ToUpperInvariant()
Trim             Method                string Trim(Params char[] trimChars), string Trim()
TrimEnd          Method                string TrimEnd(Params char[] trimChars)
TrimStart        Method                string TrimStart(Params char[] trimChars)
Chars            ParameterizedProperty char Chars(int index) {get;}
Length           Property              int Length {get;}


PS C:\WINDOWS\system32>

Rich Matheisen 45,906 Reputation points

2023-03-09T16:32:53.3466667+00:00

Thanks. O365 doesn't return an array of emailaddress objects, it returns an array of strings that represent just part of the emailaddress object. In other words, it deserializes the whole mailbox object.

I changed my earlier answer to deal with extracting just the PRIMARY SMTP email address from that array of strings.
Boe Dillard 666 Reputation points

2023-03-09T17:46:36.59+00:00

Thanks - I'm not sure if you updated the code but I reran it and got an empty spreadsheet.
Rich Matheisen 45,906 Reputation points

2023-03-09T19:00:15.52+00:00

I did update the code, but it still contains the Where-Object that only looks for the domain "acme.com".

Is "acme.com" one of your DNS domain names or is it one that you just made up for your question?

"Acme.com" and "Widgets.com" seem kinda phony.
Boe Dillard 666 Reputation points

2023-03-10T01:20:50.0433333+00:00

I didn't post my real domains but I do put them in your code instead of acme.com
Rich Matheisen 45,906 Reputation points

2023-03-10T02:34:19.1533333+00:00

Remove the Where-Object as you did before. Does the data in the CSV look correct? Is there and "Email Address" and "Domain" column? Do they have recognizable data in them?
Boe Dillard 666 Reputation points

2023-03-10T03:06:51.2266667+00:00

Thanks - yes if I remove that item it exports to a csv with a mixture of email domains in their UserPrincipal Name. email address column all noaddress@local.domain and domain column all local.domain (that isn't me hiding info that is what it says)
Rich Matheisen 45,906 Reputation points

2023-03-10T03:30:10.1633333+00:00
Well, crap! There's a typo in this line:

if ($a -clike 'SMTP"*'){

That double-quote after 'SMTP' should be a colon. I'll fix that in the code I posted earlier. You can make the correction yourself to the code you already have without waiting.
Boe Dillard 666 Reputation points

2023-03-10T04:11:44.1266667+00:00

Sorry - blank spreadsheet.

Rich Matheisen 45,906

And what do the results look like if you remove the "Where-Object"?

Also, run this and let's see what this stuff looks like:

Connect-ExchangeOnline
$x = Get-Mailbox <one-mailbox>
$y = $x.emailAddresses
'=== $y (emailaddresses) object type ==='
$y.gettype().Name
'=== Expand emailaddresses into $z ==='
$z = $x | Select-Object -Expand emailaddresses
'=== $z emailaddresses expanded object type ==='
$z.gettype().Name
'=== ForEach-Object $z ==='
$z |
    ForEach-Object{
        $_.gettype().Name
        $_
    }

Boe Dillard 666

Do you want me to change one mailbox to a person's mailbox name?

At line:1 char:18
+ $x = Get-Mailbox <one-mailbox>
+                  ~
The '<' operator is reserved for future use.
    + CategoryInfo          : ParserError: (:) [], ParentContainsErrorRecordException
    + FullyQualifiedErrorId : RedirectionNotSupported

Rich Matheisen 45,906 Reputation points

2023-03-10T19:29:45.8833333+00:00

Yes, I do

Share via

Create report for mailbox usage space by email domain in Powershell 365 hosted? Tenant has multiple domains

3 answers