How to create Dynamic Exchange 2007 Distribution List Based on Exchange 2007 Database

Exchnage 2007 EMC doesn't offer GUI based wizard to create Exchange 2007 Dynamic Distribution Group by all mailboxes within a Exchange Database. However, it's a usually tool for Exchange admin if you need to notify your users when you are planning a database maintenance at scheduled time. Lukily, you can use EMS to create Exchange 2007 Dynamic Distribution Group by all mailboxes within a Exchange Database. Here's a quick recipe to create a Dynamic Distribution Group to include all mailboxes on a database.

$DB = (Get-MailboxDatabase "SERVER\Storage Group\Mailbox Database").distinguishedName

New-DynamicDistributionGroup MyGroup -RecipientFilter {Database -eq $DB} -RecipientContainer "DC=MySubDomain,DC=MyRootDomain,DC=com" -OrganizationalUnit "OU=MySubOU,OU=Distribution Groups,DC=MySubDomain,DC=MyDomain,DC=com"

Once you have created the Dynamic DL, you can fine tune the DL by using EMC GUI interface to modify it, say, add permission to send, size restriction, enable discover report, etc.

Note:

1. SubDomain and SubOU are optional, depending on your Domain and OU structure.
2. The first step gets the distinguishedName of the mailbox database in a variable called $DB.Parameters:- OrganizationalUnit: Specifies the container/OU where the group will be created- RecipientContainer: Specifies container to pick up recipients from.