We use cookies on our website to ensure we provide you with the best experience on our website. By using our website, you agree to the use of cookies for analytics and personalized content.This website uses cookies. More Information
It seems like your browser didn't download the required fonts. Please revise your security settings and try again.

Attention

Starting May 1st, 2018, we will no longer offer the ArchiveOne family of products. This includes all editions of ArchiveOne, ArchiveOne for Files, Max Compression, and Access Security Manager. If you currently hold a maintenance and support contract, you will continue to receive our award-winning support until your contract expires, or until May 1st, 2019, whichever occurs first. The license for ArchiveOne is perpetual; therefore the software may continue to be used independently without any updates or support indefinitely.

How to Determine Total Size of User Archived Messages

  • Last updated on

Use the steps in this article to determine the total size of a single user's archived messages using Microsoft Excel.

The steps in this article assume the user has less than 500,000 items, which is the Search results window display limit.

  1. Open the ArchiveOne Admin console.
  2. Right-click Archive Searches, and click New.
  3. In Search name field, type a name to represent the search.
  4. Click Source criteria, click Selected mailboxes or dlists, and then click Browse.
  5. In the Choose mailboxes dialog, select the user, click Add, and then click OK to close the dialog box.
  6. Click OK to save your source criteria, and then click Done to save your search criteria.
  7. Right-click the newly created search name, and click Run. When the Search Results window displays, click View summary.
  8. When the matching results displays, on the View menu, click Add/Remove Columns.
  9. In the Displayed columns lists, remove all columns except Status, Store, and Size. Click OK.
  10. Click Export, or on the Action menu, click Export List, and save the file as a .csv file.
  11. Open the saved .csv file in Excel.
  12. Select the entire Size column, right-click the column, and click Format Cells.
  13. On the Number tab, click Number in the Category section:
    archive_size01.png 
  14. Click OK. With the Size column selected, in the Excel toolbar, click Find & Select, and click Replace.
  15. In the Replace tab, in the Find what field, press the spacebar once and type KB (<space>KB). Leave the Replace with field blank.
  16. Click Replace All to remove KB from the Size column.
  17. With the Size column selected, in the Excel toolbar, click Find & Select, and click Replace.
  18. In the Replace tab, in the Find what field, press the spacebar once and type MB (<space>MB).
  19. In the Replace with field, type 000.
  20. Click Replace All to convert every instance of MB to KB in the Size column.
  21. Create a formula to SUM the entire Size column and the result is the size of the user's archived items in KB.

 

Last updated on