Forum Discussion

sandrine_goetha's avatar
sandrine_goetha
Level 6
2 years ago

Archive not linked to any mailbox

Good morning,

I just discovered something strange while trying to consolidate my environment.

EV 14.1 for exchange

Exchange 2016

I discovered that some archives are not "linked" to any exchange Mailbox and would like to delete them when they are empty as they are not really necessary.

My question is the following, is there a was to find out from powershell or SQL which archives are not " linked" to a mailbox ?

My problem being that they are not present in the exchangeMailboxentry table but they are in the archivepoint table. Could any of you give me a hint how to identify all those archives .

Thank you for your help Sandrine

  • Prone2Typos's avatar
    Prone2Typos
    Moderator
    2 years ago

    In my opinion, the easiest thing to do is to use the usage report. If you are setting the "bill usage to" value to the primary user, people who no longer have Active Directory accounts show as a SID and not a user. 

    You could validate a few of them as there are some settings that may result in duplicate archives being created and leaving behind an orphaned one. 

    When you export this report, it should help a lot without needing to traverse SQL for the data. 

     

    I hope this helps. 

     

    • GertjanA's avatar
      GertjanA
      Moderator
      2 years ago

      Hello Sandrine,

      Usage report is a good one. That will show number of items. There are some queries available also, see THIS KB

       

  • CConsult's avatar
    CConsult
    Moderator
    2 years ago

    you should also check, if you really want to delete those archives, especially if you have no journal archive.

    You might lose important information depending on your settings.