Issue
When ingesting data into a target Exchange or Office 365 archive mailbox quotas may stop the ingest of items. This article describes how to find very large archives in the EmailXtender environment
Solution
The following SQL query can be used to identify them:

SELECT EmailAddress.EmailAddress AS Name, COUNT_BIG(Message.MD5HashKey) AS [Item Count], ROUND(SUM(CAST(Message.MsgSize as real))/1024/1024,2) AS [Item Size MB]
FROM EmailAddress
INNER JOIN Route ON EmailAddress.EmailId = Route.EmailId
INNER JOIN Message ON Route.MD5HashKey = Message.MD5HashKey
AND Route.TimeStamp = Message.TimeStamp
GROUP BY EmailAddress.EmailAddress
Print Friendly, PDF & Email