1. Open SQL Server Management Studio
2. Connect to the SQL Instance used for Archive Manager
3. Click New Query
4. Copy and paste the below SQL query and Click Execute
Use ArchiveManager
Select Mailbox.mailboxID, Mailbox.Name, SUM(Cast(Message.Size as BIGINT)) as MailboxSize
From MailBox, Message, MailboxMessage
Where Mailbox.MailboxID = MailboxMessage.MailboxID
AND Message.MessageID = MailboxMessage.MessageID
GROUP BY Mailbox.MailBoxID, Mailbox.Name
Order by MailboxSize desc
