How to Audit Mailbox Delegation in Archive Manager
Need to know who has access to which mailbox.
The information in the script(s) provided is known to work successfully; however, they have not been officially tested by our Quality Control. If any of these instructions are changed and/or incorrectly used, intentionally or unintentionally, this solution becomes unsupported by our Support and Development. Support and Development recommend always making a backup of the current database prior to execution of any script(s) that may modify it.
Running the following query against the Archive Manager Database.
This query will list all the relations between mailboxes. The first column is the mailbox, and the second column shows all delegates/virtual mailboxes.
QUERY:
SELECT l.EmailAddress, m.Name
FROM [ArchiveManager].[dbo].[LoginMailBox] lm
JOIN [ArchiveManager].[dbo].[MailBox] m ON lm.MailBoxID = m.MailBoxID
JOIN [ArchiveManager].[dbo].Login l ON lm.LoginID = l.LoginID
EXAMPLE:
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center