How to Find all Exchange Server 2010 Mailboxes with Archive Enabled

In an Exchange Server 2010 environment it may be necessary to identify which mailbox users have the personal archive enabled.

This can be found easily in the Exchange Management Shell with this command.

[PS] C:\>Get-Mailbox | where {$_.ArchiveDatabase -ne $null}

Name                      Alias                ServerName       ProhibitSendQuota
----                      -----                ----------       -----------------
Paul Cunningham           Paul.Cunningham      ex2              unlimited
Alan.Reid                 Alan.Reid            ex2              unlimited
Alannah.Shaw              Alannah.Shaw         ex2              unlimited
Bozena.Kirton             Bozena.Kirton        ex2              unlimited
Diane.Jones               Diane.Jones          ex2              unlimited
Helen.Cail                Helen.Cail           ex2              4.688 GB (5,033,164,800 bytes)
Julian.Morozgalska        Julian.Morozgalska   ex2              unlimited
Maggie.Hengist            Maggie.Hengist       ex2              unlimited
Nicola.Clare              Nicola.Clare         ex2              unlimited
Sabi.Smith                Sabi.Smith           ex2              unlimited
Trevor.Reece              Trevor.Reece         ex2              unlimited

If you prefer the Exchange Management Console you can use a filter to display all of the archive enabled mailbox users.

Exchange Server 2010 filtered view for archive enabled mailbox users
Exchange Server 2010 filtered view for archive enabled mailbox users

You can also list all archive enabled users along with their archive mailbox settings.

[PS] C:\>Get-Mailbox | where {$_.ArchiveDatabase -ne $null} | ft name, archivedatabase, archivename, archivequota, archivewarningquota -AutoSize

Name               ArchiveDatabase     ArchiveName                           ArchiveQuota                 ArchiveWarnin
----               ---------------     -----------                           ------------                 -------------
Paul Cunningham    Mailbox Database 01 {Online Archive - Paul Cunningham}    50 GB (53,687,091,200 bytes) 45 GB (48,...
Alan.Reid          Mailbox Database 02 {Online Archive - Alan Reid}          50 GB (53,687,091,200 bytes) 45 GB (48,...
Alannah.Shaw       Mailbox Database 02 {Online Archive - Alannah Shaw}       50 GB (53,687,091,200 bytes) 45 GB (48,...
Bozena.Kirton      Mailbox Database 02 {Online Archive - Bozena Kirton}      50 GB (53,687,091,200 bytes) 45 GB (48,...
Diane.Jones        Mailbox Database 02 {Online Archive - Diane Jones}        50 GB (53,687,091,200 bytes) 45 GB (48,...
Helen.Cail         Mailbox Database 02 {Online Archive - Helen Cail}         50 GB (53,687,091,200 bytes) 45 GB (48,...
Julian.Morozgalska Mailbox Database 01 {Online Archive - Julian Morozgalska} 50 GB (53,687,091,200 bytes) 45 GB (48,...
Maggie.Hengist     Mailbox Database 01 {Online Archive - Maggie Hengist}     50 GB (53,687,091,200 bytes) 45 GB (48,...
Nicola.Clare       Mailbox Database 01 {Online Archive - Nicola Clare}       50 GB (53,687,091,200 bytes) 45 GB (48,...
Sabi.Smith         Mailbox Database 01 {Online Archive - Sabi Smith}         50 GB (53,687,091,200 bytes) 45 GB (48,...
Trevor.Reece       Mailbox Database 01 {Online Archive - Trevor Reece}       50 GB (53,687,091,200 bytes) 45 GB (48,...


  1. jm says


    Thanks interesting. You might want to add the command elsewhere than just in a screenshot.
    I mean, it would be useful to be able to copy it right? :)

  2. Wes says


    Those are active text boxes, so you can copy the commands.
    From first box copied just now:
    Get-Mailbox | where {$_.ArchiveDatabase -ne $null}


  3. Paul says

    What would be the command to export the archive mail from the archive mailbox back into the users active mailbox or how would you do this manually?

  4. Dirk Haex says

    you could start a mailboxexport request for the mailbox.
    Then you could do another mailbox export request for the archive to be written into the PST of the mailbox.
    After all this you could turn around to process with a mailbox import request of the PST (merged mailbox & archive)

  5. Jolivette says

    Great writeup but I’m having an issue exporting to csv?
    Get-Mailbox -ResultSize unlimited | where {$_.ArchiveDatabase -ne $null} |ft name,archivedatabase | Export-Csv C:\Temp\ArchiveExport.csv -NoTypeInformation

Leave a Reply

Your email address will not be published. Required fields are marked *