Skip to main content Skip to footer

Analyze Old Email Volume Before Migration or Cleanup

Planning an Office 365 migration? Before you begin, you need to understand how much data exists in user mailboxes: specifically, how many old messages are taking up space. Armed with a breakdown of Outlook items by creation date, you can ask users to delete or archive outdated content before the migration.

Traditional Approaches and Their Limitations

Using Outlook

Outlook's built-in tools, i;e. the Mailbox Cleanup tool and Search folders, are completely impractical for this task. These manual options might work for one or two mailboxes, but they don't scale to organizational needs.

Using PowerShell

The Search-Mailbox and New-MailboxSearch cmdlets allow you to search items meeting specific criteria across multiple mailboxes. Office 365's Content Search eDiscovery tool in the compliance center offers more sophisticated capabilities, but requires specific permissions. Either way, you'll need to export results and reprocess the data to create meaningful summaries: this is a time-consuming workflow.

Using a Script

The most sophisticated PowerShell approach involves writing an elaborate script using the Microsoft EWS or Graph APIs. However, you'll need to customize the script for your specific requirements and maintain it as your environment evolves.

Analyze Email Age Distribution with Promodag Reports

Promodag Reports can identify mailboxes containing old Outlook items that users should archive. The Item Breakdown by Age report provides exactly the analysis you need.

Select Your Target Mailboxes

Choose which mailboxes to analyze—whether they're hosted in on-premise Exchange or Office 365. You can select all user mailboxes or filter by attributes. For example, target all users from the Sales Department or from a specific Exchange database. This precision proves valuable when you're migrating specific groups on a defined schedule.

Choose Which Folders to Analyze

Select specific folders or folder sets for analysis. You might focus on the Inbox root, or analyze all default Outlook folders at once with a single selection.

Apply Item Filters

Set sophisticated filters to target specific item types—for example, only unread messages or items with attachments.

Define Your Time Intervals

Configure up to six custom time intervals to categorize email age. This flexibility lets you create the exact breakdown your migration or cleanup project requires.

Generate Your Analysis

The report delivers the overview you need immediately. Group results by display name to see details for each user.

Streamline Your Migration Planning

When you need to measure the volume occupied by old messages across your mailboxes, Promodag Reports provides the most efficient and user-friendly solution. Test this report free for 45 days and explore the full range of capabilities during your evaluation period. Download Promodag Reports and join our community of users.

Have questions or suggestions? Contact our team or submit a support request anytime.

Promodag Reports: Simplifying Exchange data analysis. Get the insights you need without complex scripting.

About the author

Promodag

Promodag has been developing email reporting software for Microsoft Exchange and Office 365 environments since 1994, with our main product Promodag Reports now recognized as a market leader.

Comprehensive Exchange reporting made simple for Office 365, On-Premise, and Hybrid environments

Start your free 45-day trial of Promodag Reports