In Exchange 2003, we are using Active Directory Users & Computers to find some of the exceptional users/mailboxes up to certain level (may be with custom LDAP query) in the environment but in Exchange 2007 Management Console we have certain limitations to find it but there PowerShell helps you.
In Exchange 2007 Management Console we can filter recipients for below attributes and values are matching, available or unavailable.
|
ActiveSynch Mailbox Policy
Alias
City
Company
Country/Region
Custom Attribute 1-15
Database
Department
Display Name
E-Mail Addresses
First Name
Last Name
|
Managed Folder Mailbox Policy
Name
Office
Postal Code
Recipient Type Details
Server
State Or Province
UM Enabled
Unified Messaging Mailbox Policy
User logon name (pre-Windows 2000)
User logon name (User Principal Name)
|
But how do we find find below exceptional users/mailboxes in Exchange environment?
- All users with Forwarding Address is set.
- All mailboxes with quota limit is NOT set to default.
- All users set as hidden in GAL.
- All users whose mail item retention period is NOT default.
- All users who has some “Send on Behalf Of” set.
- All mailboxes with antispam bypass is set.
- All mailboxes with rules quota increased.
Let’s discuss one by one in detail for Exchange 2007 as well as in Exchange 2003 with an example.
1. Find all users with Forwarding Address is set.
Please refer my previous post FAQ: Find all users with Forwarding Address is set
2. Find all mailboxes with quota limit is NOT set to default.
Exchange 2003:
Custom LDAP Search: (mailNickname=*)(mDBUseDefaults=FALSE)
Example: I have set mailbox quota limit of User 32 manually.
Now find it with Custom LDAP Search.
Active Directory Users & Computers -> Find -> Select Custom Search -> Enter (mailNickname=*)(mDBUseDefaults=FALSE) in LDAP Query Text Box -> Click Find Now.
Exchange 2007:
PowerShell Command: Get-Mailbox | Where {$_.UseDatabaseQuotaDefaults -eq $false} | Select Name, IssueWarningQuota, ProhibitSendQuota, ProhibitSendReceiveQuota
Example: I have set mailbox quota of User 22 manually.
Now find it with PowerShell.
3. Find all users set as hidden in GAL.
Exchange 2003:
Custom LDAP Search: (objectClass=*)(msExchHideFromAddressLists=*)
Example: I mark hide User 32 from Exchange Address Lists.
Now find it with Custom Search.
Active Directory Users & Computers -> Find -> Select Custom Search -> Enter (objectClass=*)(msExchHideFromAddressLists=*) in LDAP Query Text Box -> Click Find Now.
Note: Here in LDAP query is set to objectClass=* so it gives all hidden object, if you select objectClass=user then it gives only users.
Exchange 2007:
PowerShell Command: Get-Mailbox | Where {$_.HiddenFromAddressListsEnabled -eq $True} | Select Name, HiddenFromAddressListsEnabled
Example: I mark hide User 22 from Exchange Address Lists.
Now find it with PowerShell.
4. Find all users whose mail item retention period is NOT default.
Exchange 2003:
Custom LDAP Search : (objectClass=*)(deletedItemFlags=*)
Example : I set custom retention period for mail items on User 32.
Now find it with Custom Search.
Active Directory Users & Computers -> Find -> Select Custom Search -> Enter (objectClass=*)(deletedItemFlags=*) in LDAP Query Text Box -> Click Find Now.
Exchange 2007:
PowerShell : Get-Mailbox | Where {$_.UseDatabaseRetentionDefaults -eq $False} | Select Name, UseDatabaseRetentionDefaults
Example: I set custom retention period for mail items on User 22.
Now find it with PowerShell.
5. Find all users who has some “Send on Behalf Of” set.
Exchange 2003:
Custom LDAP Search: (objectClass=*)(publicDelegates=*)
Example: I grant Send On Behalf Of for User 32.
Now find it with Custom Search.
Active Directory Users & Computers -> Find -> Select Custom Search -> Enter (objectClass=*)(publicDelegates=*) in LDAP Query Text Box -> Click Find Now.
Exchange 2007:
PowerShell : Get-Mailbox | Where {$_.GrantSendOnBehalfTo -ne $null} | Select Name, GrantSendOnBehalfTo
Example: I grant Send On Behalf Of for User 22.
Now find it with PowerShell.
6. Find all mailboxes with antispam bypass is set.
This is new feature of Exchange 2007.
Exchange 2007:
PowerShell: Get-Mailbox | Where {$_.AntispamBypassEnabled -eq $True} | Select Name, AntispamBypassEnabled
Example: I have set to bypass the antispam for User 22.
Now find it with PowerShell.
7. All mailboxes with rules quota increased.
This is new feature of Exchange 2007.
Exchange 2007:
PowerShell: Get-Mailbox | Where {$_.RulesQuota -ne "64KB"} | Select Name, RulesQuota
Example: I increased Rule Quota for User 22.
Now find it with PowerShell.
Note: You would have seen that Powershell command can handle Exchange 2003 queries also so in co-existing environment it is very easy with PowerShell cmdlets and scripts to generate this kind of reports.
==========================================================
Amit Tank
