How can a list of mailboxes and the message policies assigned to them be displayed? (4368499)

Policies can be applied at a server level, mailbox level or folder level.

How can those policies applied at a mailbox level be listed against all mailboxes?

Disclaimer:
The information in the script(s) provided is known to work successfully; however, they have not been officially tested by Quest Software Quality Control.
If any of these instructions are changed and/or incorrectly used, intentionally or unintentionally, this solution becomes unsupported by Quest Software Support and Development.
Quest Software Support and Development recommend to always take backup of the current database prior to execution of any script(s) that may modify it.
For customization of Archive Manager, please contact our Professional Services Organization: http://www.quest.com/professional-services/



Copy and run the SQL script below into SQL query analyser to list all mailboxes and the message policies that are applied to each mailbox.

USE ArchiveManager
CREATE TABLE #tmptab
(
MailboxID [int] ,
MailboxName nvarchar(255),
MailboxType nvarchar (100),
DefaultPolicy nvarchar(255),
Inbox nvarchar(255),
SentItems nvarchar(255),
DeletedItems nvarchar(255)
)
Insert into #tmptab (MailboxID,Mailboxname,MailboxType,DefaultPolicy,Inbox,SentItems,DeletedItems)
select MailboxID,name,MailboxType,defaultmessagepolicyid,inboxmessagepolicyid,sentitemsmessagepolicyid,deleteditemsmessagepolicyid from mailbox

update #tmptab set Defaultpolicy = (select name from messagepolicy where messagepolicy.messagepolicyid = defaultpolicy)
update #tmptab set Inbox = (select name from messagepolicy where messagepolicy.messagepolicyid = Inbox)
update #tmptab set SentItems = (select name from messagepolicy where messagepolicy.messagepolicyid = SentItems)
update #tmptab set DeletedItems = (select name from messagepolicy where messagepolicy.messagepolicyid = DeletedItems)
select * from #tmptab
drop table #tmptab