Return
-
Title
How to find what users has access to what Archive mailbox via SQL Script? -
Description
How to find what users has access to what Archive mailbox? -
Resolution
1. Open SQL Management Studio | Database
2. Open Archive Manager
3. Select New Query and paste the below SQL statement
SELECT M.Name AS Mailbox, L.DisplayName AS OwnerOrDelegatedUser FROM LoginMailbox AS LM JOIN Login AS L ON L.LoginID = LM.LoginID JOIN MailBox AS M ON M.MailBoxID = LM.MailBoxID ORDER BY M.Name