{"id":385,"date":"2022-08-23T12:19:05","date_gmt":"2022-08-23T11:19:05","guid":{"rendered":"https:\/\/www.davidirwin.co.uk\/?p=385"},"modified":"2022-08-23T12:19:47","modified_gmt":"2022-08-23T11:19:47","slug":"check-size-and-status-of-archive-mailbox-using-powershell","status":"publish","type":"post","link":"https:\/\/www.davidirwin.co.uk\/index.php\/2022\/08\/23\/check-size-and-status-of-archive-mailbox-using-powershell\/","title":{"rendered":"Check Size and Status of Archive Mailbox using PowerShell"},"content":{"rendered":"
\n

Check Size and Status of Archive Mailbox using PowerShell<\/h1>\n<\/header>\n
\n

Archive mailbox (Online or In-Place Archive<\/strong>) in Office 365 provides users with additional mailbox storage space. Once the archive feature is enabled for a mailbox, the mailbox user can easily copy or move the required messages to the\u00a0Online Archive<\/strong>\u00a0folder group in Outlook Desktop and\u00a0In-Place Archive<\/strong>\u00a0in Outlook Online.<\/p>\n

In this post, I am going to share a PowerShell script to get the size and status of Exchange Online Archive mailboxes. If you looking to find users\u2019 primary mailbox storage size, refer to this post:\u00a0Mailbox size report<\/a>.<\/p>\n

We can use the\u00a0Get-Mailbox<\/strong>\u00a0cmdlet to check the archive feature is enabled or not in a mailbox. Once we confirmed the archive status enabled, we can use\u00a0Get-MailboxStatistics<\/strong>\u00a0to get the archive mailbox size, and other mailbox related statistics data. Before proceeding,\u00a0install the Exchange Online PowerShell V2<\/a><\/strong>\u00a0module and run the below command to connect Exchange Online Powershell.<\/p>\n

\n
\n
\n\n\n\n
\n
1<\/div>\n<\/td>\n
\n
\n
\n
Connect-ExchangeOnline<\/div><\/div>\n<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n

Run the following command to check the archive status for a mailbox. The property\u00a0ArchiveStatus<\/strong>\u00a0indicates the status of the archive mailbox, the value \u201cActive<\/strong>\u201d means the mailbox has an active archive mailbox.<\/p>\n

\n
\n
\n\n\n\n
\n
1<\/div>\n<\/td>\n
\n
\n
\n
Get-Mailbox<\/div><\/div>\n
-Identity<\/div><\/div>\n
AlexW\u00a0 | Select ArchiveStatus, ArchiveDatabase<\/div><\/div>\n<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n

As per\u00a0this post<\/a><\/strong>, there may be a chance ArchiveStatus is set to \u201cNone<\/strong>\u201d for an active archive mailbox in Office 365, so we can also check the property is\u00a0ArchiveDatabase<\/strong>, if this property has any value then the mailbox has an active archive mailbox.<\/p>\n

Once you confirmed the archive status for the mailbox, run the following command to get the size and archived items count.<\/p>\n

\n
\n
\n\n\n\n
\n
1<\/div>\n<\/td>\n
\n
\n
\n
Get-MailboxStatistics<\/div><\/div>\n
-Identity<\/div><\/div>\n
AlexW<\/div><\/div>\n
-Archive<\/div><\/div>\n
| Select DisplayName, TotalItemSize, ItemCount<\/div><\/div>\n<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n

The parameter\u00a0-Archive<\/strong>\u00a0is the key input to get the archive mailbox. If you have not provided this property, the command simply returns the user\u2019s primary mailbox statistics.<\/p>\n

Find all Office 365 users with Active Archive Mailbox<\/h2>\n

Run the below command to list all the Office 365 users with archive mailbox.<\/p>\n

\n
\n
\n\n\n\n
\n
1<\/div>\n<\/td>\n
\n
\n
\n
Get-Mailbox<\/div><\/div>\n
-Archive<\/div><\/div>\n
-ResultSize<\/div><\/div>\n
Unlimited | Select DisplayName, ArchiveStatus<\/div><\/div>\n<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n

Instead of listing only archive mailboxes, if you want to get all mailboxes with their archive mailbox status, you can run the below command.<\/p>\n

\n
\n
\n\n\n\n
\n
1<\/div>\n<\/td>\n
\n
\n
\n
Get-Mailbox<\/div><\/div>\n
-ResultSize<\/div><\/div>\n
Unlimited\u00a0 | Select DisplayName, @{Label=<\/div><\/div>\n
"ArchiveStatus"<\/div><\/div>\n
;Expression={<\/div><\/div>\n
if<\/div><\/div>\n
(<\/div><\/div>\n
$_<\/div><\/div>\n
.ArchiveStatus<\/div><\/div>\n
-eq<\/div><\/div>\n
"Active"<\/div><\/div>\n
-OR<\/div><\/div>\n
$_<\/div><\/div>\n
.ArchiveDatabase<\/div><\/div>\n
-ne<\/div><\/div>\n
$null<\/div><\/div>\n
) {<\/div><\/div>\n
"Enabled"<\/div><\/div>\n
}<\/div><\/div>\n
else<\/div><\/div>\n
{\u00a0<\/div><\/div>\n
"Disabled"<\/div><\/div>\n
}}}<\/div><\/div>\n<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n

Export Size and Status of Archive Mailbox for all Microsoft 365 users<\/strong><\/h2>\n

Run the below Powershell script to get the archive status of all user mailboxes and export archive mailbox details such as archive status, archive state, mailbox size, and more.<\/p>\n

\n
\n
\n\n\n\n
\n
1<\/div>\n
2<\/div>\n
3<\/div>\n
4<\/div>\n
5<\/div>\n
6<\/div>\n
7<\/div>\n
8<\/div>\n
9<\/div>\n
10<\/div>\n
11<\/div>\n
12<\/div>\n
13<\/div>\n
14<\/div>\n
15<\/div>\n
16<\/div>\n
17<\/div>\n
18<\/div>\n
19<\/div>\n
20<\/div>\n
21<\/div>\n
22<\/div>\n
23<\/div>\n
24<\/div>\n
25<\/div>\n
26<\/div>\n
27<\/div>\n
28<\/div>\n
29<\/div>\n
30<\/div>\n
31<\/div>\n
32<\/div>\n
33<\/div>\n<\/td>\n
\n
\n
\n
$Result<\/div><\/div>\n
=@()<\/div><\/div>\n<\/div>\n
\n
$mailboxes<\/div><\/div>\n
=<\/div><\/div>\n
Get-Mailbox<\/div><\/div>\n
-ResultSize<\/div><\/div>\n
Unlimited<\/div><\/div>\n<\/div>\n
\n
$totalmbx<\/div><\/div>\n
=<\/div><\/div>\n
$mailboxes<\/div><\/div>\n
.Count<\/div><\/div>\n<\/div>\n
\n
$i<\/div><\/div>\n
= 1<\/div><\/div>\n<\/div>\n
\n
$mailboxes<\/div><\/div>\n
|<\/div><\/div>\n
ForEach-Object<\/div><\/div>\n
{<\/div><\/div>\n<\/div>\n
\n
$i<\/div><\/div>\n
++<\/div><\/div>\n<\/div>\n
\n
$mbx<\/div><\/div>\n
=<\/div><\/div>\n
$_<\/div><\/div>\n<\/div>\n
\n
$size<\/div><\/div>\n
=<\/div><\/div>\n
$null<\/div><\/div>\n<\/div>\n
<\/div>\n
\n
Write-Progress<\/div><\/div>\n
-activity<\/div><\/div>\n
"Processing $mbx"<\/div><\/div>\n
-status<\/div><\/div>\n
"$i out of $totalmbx completed"<\/div><\/div>\n<\/div>\n
<\/div>\n
\n
if<\/div><\/div>\n
(<\/div><\/div>\n
$mbx<\/div><\/div>\n
.ArchiveStatus<\/div><\/div>\n
-eq<\/div><\/div>\n
"Active"<\/div><\/div>\n
){<\/div><\/div>\n<\/div>\n
\n
$mbs<\/div><\/div>\n
=<\/div><\/div>\n
Get-MailboxStatistics<\/div><\/div>\n
$mbx<\/div><\/div>\n
.UserPrincipalName<\/div><\/div>\n<\/div>\n
<\/div>\n
\n
if<\/div><\/div>\n
(<\/div><\/div>\n
$mbs<\/div><\/div>\n
.TotalItemSize<\/div><\/div>\n
-ne<\/div><\/div>\n
$null<\/div><\/div>\n
){<\/div><\/div>\n<\/div>\n
\n
$size<\/div><\/div>\n
=<\/div><\/div>\n
[math]<\/div><\/div>\n
::Round((<\/div><\/div>\n
$mbs<\/div><\/div>\n
.TotalItemSize.ToString().Split(<\/div><\/div>\n
'('<\/div><\/div>\n
)[1].Split(<\/div><\/div>\n
' '<\/div><\/div>\n
)[0].Replace(<\/div><\/div>\n
','<\/div><\/div>\n
,<\/div><\/div>\n
''<\/div><\/div>\n
)\/1MB),2)<\/div><\/div>\n<\/div>\n
\n
}<\/div><\/div>\n
else<\/div><\/div>\n
{<\/div><\/div>\n<\/div>\n
\n
$size<\/div><\/div>\n
= 0 }<\/div><\/div>\n<\/div>\n
\n
}<\/div><\/div>\n<\/div>\n
<\/div>\n
\n
$Result<\/div><\/div>\n
+=<\/div><\/div>\n
New-Object<\/div><\/div>\n
-TypeName<\/div><\/div>\n
PSObject<\/div><\/div>\n
-Property<\/div><\/div>\n
$(<\/div><\/div>\n
[ordered]<\/div><\/div>\n
@{<\/div><\/div>\n<\/div>\n
\n
UserName =<\/div><\/div>\n
$mbx<\/div><\/div>\n
.DisplayName<\/div><\/div>\n<\/div>\n
\n
UserPrincipalName =<\/div><\/div>\n
$mbx<\/div><\/div>\n
.UserPrincipalName<\/div><\/div>\n<\/div>\n
\n
ArchiveStatus =<\/div><\/div>\n
$mbx<\/div><\/div>\n
.ArchiveStatus<\/div><\/div>\n<\/div>\n
\n
ArchiveName =<\/div><\/div>\n
$mbx<\/div><\/div>\n
.ArchiveName<\/div><\/div>\n<\/div>\n
\n
ArchiveState =<\/div><\/div>\n
$mbx<\/div><\/div>\n
.ArchiveState<\/div><\/div>\n<\/div>\n
\n
ArchiveMailboxSizeInMB =<\/div><\/div>\n
$size<\/div><\/div>\n<\/div>\n
\n
ArchiveWarningQuota=<\/div><\/div>\n
if<\/div><\/div>\n
(<\/div><\/div>\n
$mbx<\/div><\/div>\n
.ArchiveStatus<\/div><\/div>\n
-eq<\/div><\/div>\n
"Active"<\/div><\/div>\n
) {<\/div><\/div>\n
$mbx<\/div><\/div>\n
.ArchiveWarningQuota}<\/div><\/div>\n
Else<\/div><\/div>\n
{<\/div><\/div>\n
$null<\/div><\/div>\n
}<\/div><\/div>\n<\/div>\n
\n
ArchiveQuota =<\/div><\/div>\n
if<\/div><\/div>\n
(<\/div><\/div>\n
$mbx<\/div><\/div>\n
.ArchiveStatus<\/div><\/div>\n
-eq<\/div><\/div>\n
"Active"<\/div><\/div>\n
) {<\/div><\/div>\n
$mbx<\/div><\/div>\n
.ArchiveQuota}<\/div><\/div>\n
Else<\/div><\/div>\n
{<\/div><\/div>\n
$null<\/div><\/div>\n
}<\/div><\/div>\n<\/div>\n
\n
AutoExpandingArchiveEnabled=<\/div><\/div>\n
$mbx<\/div><\/div>\n
.AutoExpandingArchiveEnabled<\/div><\/div>\n<\/div>\n
\n
})<\/div><\/div>\n<\/div>\n
\n
}<\/div><\/div>\n<\/div>\n
\n
$Result<\/div><\/div>\n
|<\/div><\/div>\n
Export-CSV<\/div><\/div>\n
"C:\\Archive-Mailbox-Report.csv"<\/div><\/div>\n
-NoTypeInformation<\/div><\/div>\n
-Encoding<\/div><\/div>\n
UTF8<\/div><\/div>\n<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n<\/div>\n<\/div>\n

Once you successfully run the above script, the output will be available in the Powershell object\u00a0$Result<\/strong>. You can just filter the $Result array with\u00a0Where-Object<\/strong>\u00a0to generate further reports from this object. For example, run the below command to get details for the only archive enabled mailboxes.<\/p>\n

\n
\n
\n\n\n\n
\n
1<\/div>\n<\/td>\n
\n
\n
\n
$Result<\/div><\/div>\n
|<\/div><\/div>\n
Where-Object<\/div><\/div>\n
{<\/div><\/div>\n
$_<\/div><\/div>\n
.ArchiveStatus<\/div><\/div>\n
-eq<\/div><\/div>\n
"Active"<\/div><\/div>\n
} | Select UserName, UserPrincipalName, ArchiveMailboxSizeInMB, ArchiveWarningQuota, ArchiveQuota<\/div><\/div>\n<\/div>\n<\/div>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Check Size and Status of Archive Mailbox using PowerShell<\/a><\/p><\/blockquote>\n