Disclaimer: The information in the script(s) provided is known to work successfully; however, they have not been officially tested by Quest Quality Control. If any of these instructions are changed and/or incorrectly used, intentionally or unintentionally, this solution becomes unsupported by Quest Support and Development.
Quest Support and Development recommend always making a backup of the current database prior to execution of any script(s) that may modify it.
For customization of the <insert product name>, please contact our Professional Services Organization.
Run the following SQL query in SQL Management Studio on the SQL server for Archive Manager to display total count of items for each Mailbox
SELECT [MailBox].[Name], [MailboxMessage].[MailboxID], COUNT([MailBoxMessage].[MessageID])
FROM [dbo].[MailBox]
LEFT OUTER JOIN [dbo].[MailBoxMessage] ON
[MailBox].[MailBoxID] = [MailBoxMessage].[MailBoxID]
GROUP BY [MailBox].[Name], [MailboxMessage].[MailboxID]
