戻る
-
タイトル
How to create a list of all the mailboxes assigned to a retention policy -
説明
If ever in need of producing a list of the mailboxes which are assigned to a Retention Policy, a query can be run on the SQL database via SQL Server Management Studio (SSMS). -
対策
To produce this list, open SSMS and log into the Archive Manager database.
Click on the 'New Query' button, then use this script:
Use ArchiveManager
Select RetentionPolicy2.Name, RetentionPolicyTarget.RetentionPolicyID, Mailbox.Name, Mailbox.MailBoxID, Login.EmailAddress
From RetentionPolicyTarget
Join Mailbox on RetentionPolicyTarget.MailBoxID = Mailbox.MailboxID
Join RetentionPolicy2 on RetentionPolicyTarget.RetentionPolicyID = RetentionPolicy2.RetentionPolicyID
Join Login on Mailbox.UID = Login.UID -
追加情報
If you need to filter the results to a specific retention policy, the results can be filtered by acquiring the RetentionPolicyID from the RetentionPolicy2 table.