Filterable Properties in Exchange 2007 RTM
Since I've posted a number of times about OPATH filters for Exchange 2007 and RecipientFilter parameter for EAP/AL/GAL/DDG objects, it's only fair that I get a lot of email asking me questions about how to use it, how to convert old-style LDAP filters to OPATH, and what are the filterable properties that can be used.
Quick recap on what we've talked about so far:
- OPATH Recipient Filtering with Exchange 2007
- Address List and Email Address Policy Filter Upgrades with Exchange 2007
- Do I Really Need to Upgrade My Filters?
- Email Address Policy and OPATH filters
Ok, so now you're up to date. What else is there? Ah, yes... what properties can I use in the filter.
OPATH filtering syntax used in Exchange 2007 provides a slightly different experience vs the previous LDAP mechanism. It's a little bit more verbose to look at and create, but it's also quite a bit easier to figure out for a newbie. As I've mentioned in the previous blog posts about "upgrading" filters, in many cases you'll want to convert existing LDAP filters to their OPATH equivalent. In order to do this, you'll need to know the equivalence of OPATH properties and LDAP properties, as well as which of the properties are "filterable".
The most common email I've received relates to the "-RecipientFilter" parameter of EmailAddressPolicy, AddressList, GlobalAddressList, and DynamicDistributionGroup objects. This is the parameter people most associate with having to "update" filters, and it has a special set of Filterable properties shared among all 4 object types. This parameter is used to define which recipient objects match a filter stored on one of these 4 object types, used to control the behavior of the object (ie - stamp email address on recipients who match the filter, deliver email to the recipients who match the filter, etc)
The other filtering I'll lay out below is related to the "-Filter" parameter of many "Get" tasks. This is a bit simpler -- it's basically a filter of which properties we should use from the objects we're "Getting" to filter the result set (ie - Get-Mailbox but only include objects that match some mailbox criteria). "-Filter" is the high-performance, server-side version of a "where-object clause".
The key difference: -RecipientFilter specifies recipient properties used to control application behavior of some 2nd object (EAP/AL/GAL/DDG). -Filter specifies object properties used to control which objects are returned to the pipeline from a "Get" task.
The rest of this blog post will be long. And boring. I apologize in advance. Rather than eagerly reading through the rest of the post, please just consider it a reference for all of the filterable properties in Exchange 2007 RTM so that you can search and find them when you actually need it. The online documentation has also now been updated with these details, so I'll link that here:
- -RecipientFilter filterable properties: https://technet.microsoft.com/en-us/library/bb430771.aspx
- -Filter filterable properties: https://technet.microsoft.com/en-us/library/bb430744.aspx
*NOTE* This is only for Exchange 2007 RTM filterable properties. Later versions of Exchange might add or remove properties from this "filterable" list.
Shortcut links to specific reference tables:
- RecipientFilter
- Get-CASMailbox
- Get-Contact
- Get-DistributionGroup
- Get-DynamicDistributionGroup
- Get-Mailbox
- Get-MailContact
- Get-MailPublicFolder
- Get-MailUser
- Get-Message
- Get-Queue
- Get-Recipient
- Get-UMMailbox
- Get-User
- Get-Group
How to interpret these tables:
- OPATH Name column lists the OPATH value you would use to create the Exchange 2007 filter
- LdapDisplayName lists the LDAP equivalent value for values stored in the AD
- Where LdapDisplayName is empty, it means there's no direct equivalent in LDAP (calculated value, not stored in AD, etc)
RecipientFilter "Filterable Properties" reference table:
OPATH Name |
LdapDisplayName |
DeliverToMailboxAndForward |
deliverAndRedirect |
Company |
company |
Co |
co |
C |
c |
CountryCode |
CountryCode |
Department |
department |
DirectReports |
directReports |
Fax |
facsimileTelephoneNumber |
FirstName |
givenName |
HomePhone |
homePhone |
Initials |
initials |
LanguagesRaw |
msExchUserCulture |
LastName |
sn |
City |
l |
Manager |
manager |
MobilePhone |
mobile |
Office |
physicalDeliveryOfficeName |
OtherFax |
otherFacsimileTelephoneNumber |
OtherHomePhone |
otherHomePhone |
OtherTelephone |
otherTelephone |
Pager |
pager |
Phone |
telephoneNumber |
PostalCode |
postalCode |
PostOfficeBox |
postOfficeBox |
StateOrProvince |
st |
StreetAddress |
streetAddress |
TelephoneAssistant |
telephoneAssistant |
Title |
title |
ViewDepth |
|
DisplayName |
displayName |
AcceptMessagesOnlyFrom |
authOrig |
AcceptMessagesOnlyFromDLMembers |
dLMemSubmitPerms |
AddressListMembership |
showInAddressBook |
Alias |
mailNickname |
AssistantName |
msExchAssistantName |
Certificate |
userCertificate |
Notes |
info |
CommonName |
cn |
CustomAttribute1 |
extensionAttribute1 |
CustomAttribute10 |
extensionAttribute10 |
CustomAttribute11 |
extensionAttribute11 |
CustomAttribute12 |
extensionAttribute12 |
CustomAttribute13 |
extensionAttribute13 |
CustomAttribute14 |
extensionAttribute14 |
CustomAttribute15 |
extensionAttribute15 |
CustomAttribute2 |
extensionAttribute2 |
CustomAttribute3 |
extensionAttribute3 |
CustomAttribute4 |
extensionAttribute4 |
CustomAttribute5 |
extensionAttribute5 |
CustomAttribute6 |
extensionAttribute6 |
CustomAttribute7 |
extensionAttribute7 |
CustomAttribute8 |
extensionAttribute8 |
CustomAttribute9 |
extensionAttribute9 |
EmailAddresses |
proxyAddresses |
RawExternalEmailAddress |
targetAddress |
ExternalEmailAddress |
targetAddress |
ForwardingAddress |
altRecipient |
GrantSendOnBehalfTo |
publicDelegates |
HiddenFromAddressListsEnabled |
msExchHideFromAddressLists |
InternetEncoding |
internetEncoding |
LegacyExchangeDN |
legacyExchangeDN |
MemberOfGroup |
memberOf |
MessageHygieneFlags |
msExchMessageHygieneFlags |
PhoneticCompany |
msDS-PhoneticCompanyName |
PhoneticDepartment |
msDS-PhoneticDepartment |
PhoneticDisplayName |
msDS-PhoneticDisplayName |
PhoneticFirstName |
msDS-PhoneticFirstName |
PhoneticLastName |
msDS-PhoneticLastName |
PoliciesIncluded |
msExchPoliciesIncluded |
PoliciesExcluded |
msExchPoliciesExcluded |
ProtocolSettings |
protocolSettings |
RecipientLimits |
msExchRecipLimit |
HomeMTA |
homeMTA |
RejectMessagesFrom |
unauthOrig |
RejectMessagesFromDLMembers |
dLMemRejectPerms |
RequireAllSendersAreAuthenticated |
msExchRequireAuthToSendTo |
SCLDeleteThresholdInt |
msExchMessageHygieneSCLDeleteThreshold |
SCLRejectThresholdInt |
msExchMessageHygieneSCLRejectThreshold |
SCLQuarantineThresholdInt |
msExchMessageHygieneSCLQuarantineThreshold |
SCLJunkThresholdInt |
msExchMessageHygieneSCLJunkThreshold |
SimpleDisplayName |
displayNamePrintable |
SMimeCertificate |
userSMIMECertificate |
TextEncodedORAddress |
textEncodedORAddress |
UMDtmfMap |
msExchUMDtmfMap |
AllowUMCallsFromNonUsers |
msExchUMListInDirectorySearch |
UMRecipientDialPlanId |
msExchUMRecipientDialPlanLink |
UMSpokenName |
msExchUMSpokenName |
MapiRecipient |
mAPIRecipient |
WebPage |
wWWHomePage |
WindowsEmailAddress |
|
SafeSendersHash |
msExchSafeSendersHash |
SafeRecipientsHash |
msExchSafeRecipientsHash |
PrimarySmtpAddress |
|
RecipientDisplayType |
msExchRecipientDisplayType |
RecipientType |
|
RecipientTypeDetailsValue |
msExchRecipientTypeDetails |
RecipientTypeDetails |
|
MaxSendSize |
submissionContLength |
MaxReceiveSize |
delivContLength |
MasterAccountSid |
msExchMasterAccountSid |
LinkedMasterAccount |
|
ResourceCapacity |
msExchResourceCapacity |
ResourceMetaData |
msExchResourceMetaData |
ResourceSearchProperties |
msExchResourceSearchProperties |
ResourcePropertiesDisplay |
msExchResourceDisplay |
ResourceCustom |
|
ResourceType |
|
IsLinked |
|
IsShared |
|
IsResource |
|
EmailAddressPolicyEnabled |
|
Id |
distinguishedName |
ExchangeVersion |
msExchVersion |
RawName |
name |
OriginalId |
|
ObjectCategory |
objectCategory |
ObjectClass |
objectClass |
ObjectState |
|
RawCanonicalName |
canonicalName |
WhenChanged |
WhenChanged |
WhenCreated |
whenCreated |
DistinguishedName |
distinguishedName |
Guid |
objectGuid |
NTSecurityDescriptor |
ntSecurityDescriptor |
Name |
name |
OriginalPrimarySmtpAddress |
|
OriginalWindowsEmailAddress |
|
ExpansionServer |
msExchExpansionServerName |
PurportedSearchUI |
msExchPurportedSearchUI |
RecipientFilterMetadata |
msExchQueryFilterMetadata |
RecipientContainer |
msExchDynamicDLBaseDN |
LdapRecipientFilter |
msExchDynamicDLFilter |
RecipientFilter |
msExchQueryFilter |
ManagedBy |
managedBy |
Members |
member |
ReportToManagerEnabled |
reportToOwner |
ReportToOriginatorEnabled |
reportToOriginator |
SendDeliveryReportsTo |
|
SendOofMessageToOriginatorEnabled |
oOFReplyToOriginator |
IncludedRecipients |
|
GroupType |
groupType |
Description |
description |
HiddenGroupMembershipEnabled |
hideDLMembership |
IsSecurityPrincipal |
|
SamAccountName |
SamAccountName |
Sid |
objectSid |
SidHistory |
sIDHistory |
PublicFolderContacts |
pFContacts |
PublicFolderType |
msExchPFTreeType |
PublicFolderRootUrl |
msExchPfRootUrl |
Database |
homeMDB |
DeletedItemFlags |
deletedItemFlags |
ElcExpirationSuspensionEndDate |
msExchELCExpirySuspensionEnd |
ElcExpirationSuspensionStartDate |
msExchELCExpirySuspensionStart |
ElcMailboxFlags |
msExchELCMailboxFlags |
ManagedFolderMailboxPolicy |
msExchMailboxTemplateLink |
ExchangeGuid |
msExchMailboxGuid |
ExchangeSecurityDescriptor |
msExchMailboxSecurityDescriptor |
ExternalOofOptions |
msExchExternalOOFOptions |
RetainDeletedItemsFor |
garbageCollPeriod |
IsMailboxEnabled |
|
OfflineAddressBook |
msExchUseOAB |
ProhibitSendQuota |
mDBOverQuotaLimit |
ServerLegacyDN |
msExchHomeServerName |
ServerName |
|
UseDatabaseQuotaDefaults |
mDBUseDefaults |
IssueWarningQuota |
mDBStorageQuota |
RulesQuota |
msExchMDBRulesQuota |
ProhibitSendReceiveQuota |
mDBOverHardQuotaLimit |
ExchangeUserAccountControl |
msExchUserAccountControl |
LocaleID |
localeID |
MobileFeaturesEnabled |
msExchOmaAdminWirelessEnable |
MobileMailboxFlags |
msExchMobileMailboxFlags |
MobileAdminExtendedSettings |
msExchOmaAdminExtendedSettings |
ActiveSyncAllowedDeviceIDs |
msExchMobileAllowedDeviceIds |
ActiveSyncMailboxPolicy |
msExchMobileMailboxPolicyLink |
ActiveSyncDebugLogging |
msExchMobileDebugLogging |
PasswordLastSetRaw |
pwdLastSet |
PrimaryGroupId |
primaryGroupId |
UnicodePassword |
unicodePwd |
QueryBaseDN |
msExchQueryBaseDN |
UMEnabledFlags |
msExchUMEnabledFlags |
UMMailboxPolicy |
msExchUMTemplateLink |
OperatorNumber |
msExchUMOperatorNumber |
UMPinChecksum |
msExchUMPinChecksum |
UMServerWritableFlags |
msExchUMServerWritableFlags |
CallAnsweringAudioCodec |
msExchUMAudioCodec |
UserAccountControl |
userAccountControl |
UserPrincipalName |
userPrincipalName |
UMEnabled |
|
MailboxFolderSet |
msExchMailboxFolderSet |
MaxSafeSenders |
msExchMaxSafeSenders |
MaxBlockedSenders |
msExchMaxBlockedSenders |
"Get-CASMailbox -Filter" reference table:
OPATH Name |
LdapDisplayName |
EmailAddresses |
proxyAddresses |
LegacyExchangeDN |
legacyExchangeDN |
LinkedMasterAccount |
|
PrimarySmtpAddress |
|
ProtocolSettings |
protocolSettings |
SamAccountName |
SamAccountName |
ServerLegacyDN |
msExchHomeServerName |
ServerName |
|
ActiveSyncAllowedDeviceIDs |
msExchMobileAllowedDeviceIds |
ActiveSyncMailboxPolicy |
msExchMobileMailboxPolicyLink |
ActiveSyncDebugLogging |
msExchMobileDebugLogging |
DisplayName |
displayName |
Id |
distinguishedName |
ExchangeVersion |
msExchVersion |
RawName |
name |
OriginalId |
|
ObjectCategory |
objectCategory |
ObjectClass |
objectClass |
ObjectState |
|
RawCanonicalName |
canonicalName |
WhenChanged |
WhenChanged |
WhenCreated |
whenCreated |
DistinguishedName |
distinguishedName |
Guid |
objectGuid |
NTSecurityDescriptor |
ntSecurityDescriptor |
Name |
name |
OriginalPrimarySmtpAddress |
|
OriginalWindowsEmailAddress |
|
"Get-Contact -Filter" reference table:
OPATH Name |
LdapDisplayName |
TelephoneAssistant |
telephoneAssistant |
AssistantName |
msExchAssistantName |
City |
l |
Company |
company |
Department |
department |
DirectReports |
directReports |
DisplayName |
displayName |
Fax |
facsimileTelephoneNumber |
FirstName |
givenName |
HomePhone |
homePhone |
Initials |
initials |
LastName |
sn |
Manager |
manager |
MobilePhone |
mobile |
Notes |
info |
Office |
physicalDeliveryOfficeName |
OtherFax |
otherFacsimileTelephoneNumber |
OtherHomePhone |
otherHomePhone |
OtherTelephone |
otherTelephone |
Pager |
pager |
Phone |
telephoneNumber |
PhoneticDisplayName |
msDS-PhoneticDisplayName |
PostalCode |
postalCode |
PostOfficeBox |
postOfficeBox |
RecipientType |
|
RecipientTypeDetails |
|
SimpleDisplayName |
displayNamePrintable |
StateOrProvince |
st |
StreetAddress |
streetAddress |
Title |
title |
UMRecipientDialPlanId |
msExchUMRecipientDialPlanLink |
UMDtmfMap |
msExchUMDtmfMap |
WebPage |
wWWHomePage |
Id |
distinguishedName |
ExchangeVersion |
msExchVersion |
RawName |
name |
OriginalId |
|
ObjectCategory |
objectCategory |
ObjectClass |
objectClass |
ObjectState |
|
RawCanonicalName |
canonicalName |
WhenChanged |
WhenChanged |
WhenCreated |
whenCreated |
DistinguishedName |
distinguishedName |
Guid |
objectGuid |
NTSecurityDescriptor |
ntSecurityDescriptor |
Name |
name |
OriginalPrimarySmtpAddress |
|
OriginalWindowsEmailAddress |
|
"Get-DistributionGroup -Filter" reference table:
OPATH Name |
LdapDisplayName |
GroupType |
groupType |
SamAccountName |
SamAccountName |
ExpansionServer |
msExchExpansionServerName |
ReportToManagerEnabled |
reportToOwner |
ReportToOriginatorEnabled |
reportToOriginator |
SendOofMessageToOriginatorEnabled |
oOFReplyToOriginator |
AcceptMessagesOnlyFrom |
authOrig |
AcceptMessagesOnlyFromDLMembers |
dLMemSubmitPerms |
Alias |
mailNickname |
CustomAttribute1 |
extensionAttribute1 |
CustomAttribute10 |
extensionAttribute10 |
CustomAttribute11 |
extensionAttribute11 |
CustomAttribute12 |
extensionAttribute12 |
CustomAttribute13 |
extensionAttribute13 |
CustomAttribute14 |
extensionAttribute14 |
CustomAttribute15 |
extensionAttribute15 |
CustomAttribute2 |
extensionAttribute2 |
CustomAttribute3 |
extensionAttribute3 |
CustomAttribute4 |
extensionAttribute4 |
CustomAttribute5 |
extensionAttribute5 |
CustomAttribute6 |
extensionAttribute6 |
CustomAttribute7 |
extensionAttribute7 |
CustomAttribute8 |
extensionAttribute8 |
CustomAttribute9 |
extensionAttribute9 |
EmailAddresses |
proxyAddresses |
GrantSendOnBehalfTo |
publicDelegates |
HiddenFromAddressListsEnabled |
msExchHideFromAddressLists |
LegacyExchangeDN |
legacyExchangeDN |
MaxSendSize |
submissionContLength |
MaxReceiveSize |
delivContLength |
EmailAddressPolicyEnabled |
|
PrimarySmtpAddress |
|
RecipientType |
|
RecipientTypeDetails |
|
RejectMessagesFrom |
unauthOrig |
RejectMessagesFromDLMembers |
dLMemRejectPerms |
RequireAllSendersAreAuthenticated |
msExchRequireAuthToSendTo |
SimpleDisplayName |
displayNamePrintable |
UMDtmfMap |
msExchUMDtmfMap |
WindowsEmailAddress |
|
DisplayName |
displayName |
Id |
distinguishedName |
ExchangeVersion |
msExchVersion |
RawName |
name |
OriginalId |
|
ObjectCategory |
objectCategory |
ObjectClass |
objectClass |
ObjectState |
|
RawCanonicalName |
canonicalName |
WhenChanged |
WhenChanged |
WhenCreated |
whenCreated |
DistinguishedName |
distinguishedName |
Guid |
objectGuid |
NTSecurityDescriptor |
ntSecurityDescriptor |
Name |
name |
OriginalPrimarySmtpAddress |
|
OriginalWindowsEmailAddress |
|
"Get-DynamicDistributionGroup -Filter" reference table:
OPATH Name |
LdapDisplayName |
RecipientFilter |
msExchQueryFilter |
LdapRecipientFilter |
msExchDynamicDLFilter |
RecipientContainer |
msExchDynamicDLBaseDN |
IncludedRecipients |
|
ManagedBy |
managedBy |
Notes |
info |
PhoneticDisplayName |
msDS-PhoneticDisplayName |
ExpansionServer |
msExchExpansionServerName |
ReportToManagerEnabled |
reportToOwner |
ReportToOriginatorEnabled |
reportToOriginator |
SendOofMessageToOriginatorEnabled |
oOFReplyToOriginator |
AcceptMessagesOnlyFrom |
authOrig |
AcceptMessagesOnlyFromDLMembers |
dLMemSubmitPerms |
Alias |
mailNickname |
CustomAttribute1 |
extensionAttribute1 |
CustomAttribute10 |
extensionAttribute10 |
CustomAttribute11 |
extensionAttribute11 |
CustomAttribute12 |
extensionAttribute12 |
CustomAttribute13 |
extensionAttribute13 |
CustomAttribute14 |
extensionAttribute14 |
CustomAttribute15 |
extensionAttribute15 |
CustomAttribute2 |
extensionAttribute2 |
CustomAttribute3 |
extensionAttribute3 |
CustomAttribute4 |
extensionAttribute4 |
CustomAttribute5 |
extensionAttribute5 |
CustomAttribute6 |
extensionAttribute6 |
CustomAttribute7 |
extensionAttribute7 |
CustomAttribute8 |
extensionAttribute8 |
CustomAttribute9 |
extensionAttribute9 |
EmailAddresses |
proxyAddresses |
GrantSendOnBehalfTo |
publicDelegates |
HiddenFromAddressListsEnabled |
msExchHideFromAddressLists |
LegacyExchangeDN |
legacyExchangeDN |
MaxSendSize |
submissionContLength |
MaxReceiveSize |
delivContLength |
EmailAddressPolicyEnabled |
|
PrimarySmtpAddress |
|
RecipientType |
|
RecipientTypeDetails |
|
RejectMessagesFrom |
unauthOrig |
RejectMessagesFromDLMembers |
dLMemRejectPerms |
RequireAllSendersAreAuthenticated |
msExchRequireAuthToSendTo |
SimpleDisplayName |
displayNamePrintable |
UMDtmfMap |
msExchUMDtmfMap |
WindowsEmailAddress |
|
DisplayName |
displayName |
Id |
distinguishedName |
ExchangeVersion |
msExchVersion |
RawName |
name |
OriginalId |
|
ObjectCategory |
objectCategory |
ObjectClass |
objectClass |
ObjectState |
|
RawCanonicalName |
canonicalName |
WhenChanged |
WhenChanged |
WhenCreated |
whenCreated |
DistinguishedName |
distinguishedName |
Guid |
objectGuid |
NTSecurityDescriptor |
ntSecurityDescriptor |
Name |
name |
OriginalPrimarySmtpAddress |
|
OriginalWindowsEmailAddress |
|
"Get-Mailbox -Filter" reference table:
OPATH Name |
LdapDisplayName |
Database |
homeMDB |
DeletedItemFlags |
deletedItemFlags |
DeliverToMailboxAndForward |
deliverAndRedirect |
ElcExpirationSuspensionEndDate |
msExchELCExpirySuspensionEnd |
ElcExpirationSuspensionStartDate |
msExchELCExpirySuspensionStart |
ManagedFolderMailboxPolicy |
msExchMailboxTemplateLink |
ExchangeGuid |
msExchMailboxGuid |
ExchangeSecurityDescriptor |
msExchMailboxSecurityDescriptor |
ExchangeUserAccountControl |
msExchUserAccountControl |
ExternalOofOptions |
msExchExternalOOFOptions |
ForwardingAddress |
altRecipient |
RetainDeletedItemsFor |
garbageCollPeriod |
IsMailboxEnabled |
|
LanguagesRaw |
msExchUserCulture |
OfflineAddressBook |
msExchUseOAB |
ProhibitSendQuota |
mDBOverQuotaLimit |
ProhibitSendReceiveQuota |
mDBOverHardQuotaLimit |
RecipientLimits |
msExchRecipLimit |
UserAccountControl |
userAccountControl |
IsLinked |
|
IsShared |
|
IsResource |
|
MasterAccountSid |
msExchMasterAccountSid |
LinkedMasterAccount |
|
ResourceCapacity |
msExchResourceCapacity |
ResourceCustom |
|
ResourceType |
|
SamAccountName |
SamAccountName |
ServerLegacyDN |
msExchHomeServerName |
ServerName |
|
UseDatabaseQuotaDefaults |
mDBUseDefaults |
IssueWarningQuota |
mDBStorageQuota |
RulesQuota |
msExchMDBRulesQuota |
Office |
physicalDeliveryOfficeName |
UserPrincipalName |
userPrincipalName |
UMEnabled |
|
MaxSafeSenders |
msExchMaxSafeSenders |
MaxBlockedSenders |
msExchMaxBlockedSenders |
AcceptMessagesOnlyFrom |
authOrig |
AcceptMessagesOnlyFromDLMembers |
dLMemSubmitPerms |
Alias |
mailNickname |
CustomAttribute1 |
extensionAttribute1 |
CustomAttribute10 |
extensionAttribute10 |
CustomAttribute11 |
extensionAttribute11 |
CustomAttribute12 |
extensionAttribute12 |
CustomAttribute13 |
extensionAttribute13 |
CustomAttribute14 |
extensionAttribute14 |
CustomAttribute15 |
extensionAttribute15 |
CustomAttribute2 |
extensionAttribute2 |
CustomAttribute3 |
extensionAttribute3 |
CustomAttribute4 |
extensionAttribute4 |
CustomAttribute5 |
extensionAttribute5 |
CustomAttribute6 |
extensionAttribute6 |
CustomAttribute7 |
extensionAttribute7 |
CustomAttribute8 |
extensionAttribute8 |
CustomAttribute9 |
extensionAttribute9 |
EmailAddresses |
proxyAddresses |
GrantSendOnBehalfTo |
publicDelegates |
HiddenFromAddressListsEnabled |
msExchHideFromAddressLists |
LegacyExchangeDN |
legacyExchangeDN |
MaxSendSize |
submissionContLength |
MaxReceiveSize |
delivContLength |
EmailAddressPolicyEnabled |
|
PrimarySmtpAddress |
|
RecipientType |
|
RecipientTypeDetails |
|
RejectMessagesFrom |
unauthOrig |
RejectMessagesFromDLMembers |
dLMemRejectPerms |
RequireAllSendersAreAuthenticated |
msExchRequireAuthToSendTo |
SimpleDisplayName |
displayNamePrintable |
UMDtmfMap |
msExchUMDtmfMap |
WindowsEmailAddress |
|
DisplayName |
displayName |
Id |
distinguishedName |
ExchangeVersion |
msExchVersion |
RawName |
name |
OriginalId |
|
ObjectCategory |
objectCategory |
ObjectClass |
objectClass |
ObjectState |
|
RawCanonicalName |
canonicalName |
WhenChanged |
WhenChanged |
WhenCreated |
whenCreated |
DistinguishedName |
distinguishedName |
Guid |
objectGuid |
NTSecurityDescriptor |
ntSecurityDescriptor |
Name |
name |
OriginalPrimarySmtpAddress |
|
OriginalWindowsEmailAddress |
|
"Get-MailContact -Filter" reference table:
OPATH Name |
LdapDisplayName |
ExternalEmailAddress |
targetAddress |
RecipientLimits |
msExchRecipLimit |
AcceptMessagesOnlyFrom |
authOrig |
AcceptMessagesOnlyFromDLMembers |
dLMemSubmitPerms |
Alias |
mailNickname |
CustomAttribute1 |
extensionAttribute1 |
CustomAttribute10 |
extensionAttribute10 |
CustomAttribute11 |
extensionAttribute11 |
CustomAttribute12 |
extensionAttribute12 |
CustomAttribute13 |
extensionAttribute13 |
CustomAttribute14 |
extensionAttribute14 |
CustomAttribute15 |
extensionAttribute15 |
CustomAttribute2 |
extensionAttribute2 |
CustomAttribute3 |
extensionAttribute3 |
CustomAttribute4 |
extensionAttribute4 |
CustomAttribute5 |
extensionAttribute5 |
CustomAttribute6 |
extensionAttribute6 |
CustomAttribute7 |
extensionAttribute7 |
CustomAttribute8 |
extensionAttribute8 |
CustomAttribute9 |
extensionAttribute9 |
EmailAddresses |
proxyAddresses |
GrantSendOnBehalfTo |
publicDelegates |
HiddenFromAddressListsEnabled |
msExchHideFromAddressLists |
LegacyExchangeDN |
legacyExchangeDN |
MaxSendSize |
submissionContLength |
MaxReceiveSize |
delivContLength |
EmailAddressPolicyEnabled |
|
PrimarySmtpAddress |
|
RecipientType |
|
RecipientTypeDetails |
|
RejectMessagesFrom |
unauthOrig |
RejectMessagesFromDLMembers |
dLMemRejectPerms |
RequireAllSendersAreAuthenticated |
msExchRequireAuthToSendTo |
SimpleDisplayName |
displayNamePrintable |
UMDtmfMap |
msExchUMDtmfMap |
WindowsEmailAddress |
|
DisplayName |
displayName |
Id |
distinguishedName |
ExchangeVersion |
msExchVersion |
RawName |
name |
OriginalId |
|
ObjectCategory |
objectCategory |
ObjectClass |
objectClass |
ObjectState |
|
RawCanonicalName |
canonicalName |
WhenChanged |
WhenChanged |
WhenCreated |
whenCreated |
DistinguishedName |
distinguishedName |
Guid |
objectGuid |
NTSecurityDescriptor |
ntSecurityDescriptor |
Name |
name |
OriginalPrimarySmtpAddress |
|
OriginalWindowsEmailAddress |
|
"Get-MailPublicFolder -Filter" reference table:
OPATH Name |
LdapDisplayName |
PublicFolderContacts |
pFContacts |
DeliverToMailboxAndForward |
deliverAndRedirect |
ExternalEmailAddress |
targetAddress |
ForwardingAddress |
altRecipient |
MemberOfGroup |
memberOf |
PublicFolderType |
msExchPFTreeType |
PublicFolderRootUrl |
msExchPfRootUrl |
PhoneticDisplayName |
msDS-PhoneticDisplayName |
AcceptMessagesOnlyFrom |
authOrig |
AcceptMessagesOnlyFromDLMembers |
dLMemSubmitPerms |
Alias |
mailNickname |
CustomAttribute1 |
extensionAttribute1 |
CustomAttribute10 |
extensionAttribute10 |
CustomAttribute11 |
extensionAttribute11 |
CustomAttribute12 |
extensionAttribute12 |
CustomAttribute13 |
extensionAttribute13 |
CustomAttribute14 |
extensionAttribute14 |
CustomAttribute15 |
extensionAttribute15 |
CustomAttribute2 |
extensionAttribute2 |
CustomAttribute3 |
extensionAttribute3 |
CustomAttribute4 |
extensionAttribute4 |
CustomAttribute5 |
extensionAttribute5 |
CustomAttribute6 |
extensionAttribute6 |
CustomAttribute7 |
extensionAttribute7 |
CustomAttribute8 |
extensionAttribute8 |
CustomAttribute9 |
extensionAttribute9 |
EmailAddresses |
proxyAddresses |
GrantSendOnBehalfTo |
publicDelegates |
HiddenFromAddressListsEnabled |
msExchHideFromAddressLists |
LegacyExchangeDN |
legacyExchangeDN |
MaxSendSize |
submissionContLength |
MaxReceiveSize |
delivContLength |
EmailAddressPolicyEnabled |
|
PrimarySmtpAddress |
|
RecipientType |
|
RecipientTypeDetails |
|
RejectMessagesFrom |
unauthOrig |
RejectMessagesFromDLMembers |
dLMemRejectPerms |
RequireAllSendersAreAuthenticated |
msExchRequireAuthToSendTo |
SimpleDisplayName |
displayNamePrintable |
UMDtmfMap |
msExchUMDtmfMap |
WindowsEmailAddress |
|
DisplayName |
displayName |
Id |
distinguishedName |
ExchangeVersion |
msExchVersion |
RawName |
name |
OriginalId |
|
ObjectCategory |
objectCategory |
ObjectClass |
objectClass |
ObjectState |
|
RawCanonicalName |
canonicalName |
WhenChanged |
WhenChanged |
WhenCreated |
whenCreated |
DistinguishedName |
distinguishedName |
Guid |
objectGuid |
NTSecurityDescriptor |
ntSecurityDescriptor |
Name |
name |
OriginalPrimarySmtpAddress |
|
OriginalWindowsEmailAddress |
|
"Get-MailUser -Filter" reference table:
Name |
LdapDisplayName |
ExchangeUserAccountControl |
msExchUserAccountControl |
ExternalEmailAddress |
targetAddress |
RecipientLimits |
msExchRecipLimit |
SamAccountName |
SamAccountName |
UserPrincipalName |
userPrincipalName |
AcceptMessagesOnlyFrom |
authOrig |
AcceptMessagesOnlyFromDLMembers |
dLMemSubmitPerms |
Alias |
mailNickname |
CustomAttribute1 |
extensionAttribute1 |
CustomAttribute10 |
extensionAttribute10 |
CustomAttribute11 |
extensionAttribute11 |
CustomAttribute12 |
extensionAttribute12 |
CustomAttribute13 |
extensionAttribute13 |
CustomAttribute14 |
extensionAttribute14 |
CustomAttribute15 |
extensionAttribute15 |
CustomAttribute2 |
extensionAttribute2 |
CustomAttribute3 |
extensionAttribute3 |
CustomAttribute4 |
extensionAttribute4 |
CustomAttribute5 |
extensionAttribute5 |
CustomAttribute6 |
extensionAttribute6 |
CustomAttribute7 |
extensionAttribute7 |
CustomAttribute8 |
extensionAttribute8 |
CustomAttribute9 |
extensionAttribute9 |
EmailAddresses |
proxyAddresses |
GrantSendOnBehalfTo |
publicDelegates |
HiddenFromAddressListsEnabled |
msExchHideFromAddressLists |
LegacyExchangeDN |
legacyExchangeDN |
MaxSendSize |
submissionContLength |
MaxReceiveSize |
delivContLength |
EmailAddressPolicyEnabled |
|
PrimarySmtpAddress |
|
RecipientType |
|
RecipientTypeDetails |
|
RejectMessagesFrom |
unauthOrig |
RejectMessagesFromDLMembers |
dLMemRejectPerms |
RequireAllSendersAreAuthenticated |
msExchRequireAuthToSendTo |
SimpleDisplayName |
displayNamePrintable |
UMDtmfMap |
msExchUMDtmfMap |
WindowsEmailAddress |
|
DisplayName |
displayName |
Id |
distinguishedName |
ExchangeVersion |
msExchVersion |
RawName |
name |
OriginalId |
|
ObjectCategory |
objectCategory |
ObjectClass |
objectClass |
ObjectState |
|
RawCanonicalName |
canonicalName |
WhenChanged |
WhenChanged |
WhenCreated |
whenCreated |
DistinguishedName |
distinguishedName |
Guid |
objectGuid |
NTSecurityDescriptor |
ntSecurityDescriptor |
Name |
name |
OriginalPrimarySmtpAddress |
|
OriginalWindowsEmailAddress |
|
"Get-Message -Filter" reference table:
OPATH Name |
ldapdisplayname |
Identity |
|
Subject |
|
InternetMessageId |
|
FromAddress |
|
Status |
|
Size |
|
MessageSourceName |
|
SourceIP |
|
SCL |
|
DateReceived |
|
ExpirationTime |
|
LastError |
|
RetryCount |
|
Queue |
|
Recipients |
|
"Get-Queue -Filter" reference table:
OPATH Name |
ldapdisplayname |
Identity |
|
DeliveryType |
|
NextHopDomain |
|
NextHopConnector |
|
Status |
|
MessageCount |
|
LastError |
|
LastRetryTime |
|
NextRetryTime |
|
"Get-Recipient -Filter" reference table:
OPATH Name |
LdapDisplayName |
Alias |
mailNickname |
City |
l |
Notes |
info |
Company |
company |
CustomAttribute1 |
extensionAttribute1 |
CustomAttribute2 |
extensionAttribute2 |
CustomAttribute3 |
extensionAttribute3 |
CustomAttribute4 |
extensionAttribute4 |
CustomAttribute5 |
extensionAttribute5 |
CustomAttribute6 |
extensionAttribute6 |
CustomAttribute7 |
extensionAttribute7 |
CustomAttribute8 |
extensionAttribute8 |
CustomAttribute9 |
extensionAttribute9 |
CustomAttribute10 |
extensionAttribute10 |
CustomAttribute11 |
extensionAttribute11 |
CustomAttribute12 |
extensionAttribute12 |
CustomAttribute13 |
extensionAttribute13 |
CustomAttribute14 |
extensionAttribute14 |
CustomAttribute15 |
extensionAttribute15 |
Database |
homeMDB |
Department |
department |
DisplayName |
displayName |
ManagedFolderMailboxPolicy |
msExchMailboxTemplateLink |
AddressListMembership |
showInAddressBook |
EmailAddresses |
proxyAddresses |
ExpansionServer |
msExchExpansionServerName |
ExternalEmailAddress |
targetAddress |
FirstName |
givenName |
HiddenFromAddressListsEnabled |
msExchHideFromAddressLists |
LastName |
sn |
ResourceType |
|
ManagedBy |
managedBy |
Manager |
manager |
ActiveSyncMailboxPolicy |
msExchMobileMailboxPolicyLink |
Office |
physicalDeliveryOfficeName |
Phone |
telephoneNumber |
PoliciesIncluded |
msExchPoliciesIncluded |
PoliciesExcluded |
msExchPoliciesExcluded |
UserPrincipalName |
userPrincipalName |
SamAccountName |
SamAccountName |
ServerLegacyDN |
msExchHomeServerName |
StateOrProvince |
st |
Title |
title |
UMMailboxPolicy |
msExchUMTemplateLink |
EmailAddressPolicyEnabled |
|
PrimarySmtpAddress |
|
RecipientType |
|
RecipientTypeDetails |
|
ServerName |
|
UMEnabled |
|
Id |
distinguishedName |
ExchangeVersion |
msExchVersion |
RawName |
name |
OriginalId |
|
ObjectCategory |
objectCategory |
ObjectClass |
objectClass |
ObjectState |
|
RawCanonicalName |
canonicalName |
WhenChanged |
WhenChanged |
WhenCreated |
whenCreated |
DistinguishedName |
distinguishedName |
Guid |
objectGuid |
NTSecurityDescriptor |
ntSecurityDescriptor |
Name |
name |
OriginalPrimarySmtpAddress |
|
OriginalWindowsEmailAddress |
|
"Get-UMMailbox -Filter" reference table:
OPATH Name |
LdapDisplayName |
AllowUMCallsFromNonUsers |
msExchUMListInDirectorySearch |
CallAnsweringAudioCodec |
msExchUMAudioCodec |
DisplayName |
displayName |
EmailAddresses |
proxyAddresses |
LegacyExchangeDN |
legacyExchangeDN |
LinkedMasterAccount |
|
OperatorNumber |
msExchUMOperatorNumber |
PrimarySmtpAddress |
|
SamAccountName |
SamAccountName |
ServerLegacyDN |
msExchHomeServerName |
ServerName |
|
UMDtmfMap |
msExchUMDtmfMap |
UMMailboxPolicy |
msExchUMTemplateLink |
UMRecipientDialPlanId |
msExchUMRecipientDialPlanLink |
SIPResourceIdentifier |
|
UMEnabled |
|
Id |
distinguishedName |
ExchangeVersion |
msExchVersion |
RawName |
name |
OriginalId |
|
ObjectCategory |
objectCategory |
ObjectClass |
objectClass |
ObjectState |
|
RawCanonicalName |
canonicalName |
WhenChanged |
WhenChanged |
WhenCreated |
whenCreated |
DistinguishedName |
distinguishedName |
Guid |
objectGuid |
NTSecurityDescriptor |
ntSecurityDescriptor |
Name |
name |
OriginalPrimarySmtpAddress |
|
OriginalWindowsEmailAddress |
|
"Get-User -Filter" reference table:
OPATH Name |
LdapDisplayName |
IsSecurityPrincipal |
|
SamAccountName |
SamAccountName |
Sid |
objectSid |
SidHistory |
sIDHistory |
UserPrincipalName |
userPrincipalName |
WindowsEmailAddress |
|
AssistantName |
msExchAssistantName |
City |
l |
Company |
company |
Department |
department |
DirectReports |
directReports |
DisplayName |
displayName |
Fax |
facsimileTelephoneNumber |
FirstName |
givenName |
HomePhone |
homePhone |
Initials |
initials |
LastName |
sn |
Manager |
manager |
MobilePhone |
mobile |
Notes |
info |
Office |
physicalDeliveryOfficeName |
OtherFax |
otherFacsimileTelephoneNumber |
OtherHomePhone |
otherHomePhone |
OtherTelephone |
otherTelephone |
Pager |
pager |
Phone |
telephoneNumber |
PhoneticDisplayName |
msDS-PhoneticDisplayName |
PostalCode |
postalCode |
PostOfficeBox |
postOfficeBox |
RecipientType |
|
RecipientTypeDetails |
|
SimpleDisplayName |
displayNamePrintable |
StateOrProvince |
st |
StreetAddress |
streetAddress |
Title |
title |
UMRecipientDialPlanId |
msExchUMRecipientDialPlanLink |
UMDtmfMap |
msExchUMDtmfMap |
WebPage |
wWWHomePage |
Id |
distinguishedName |
ExchangeVersion |
msExchVersion |
RawName |
name |
OriginalId |
|
ObjectCategory |
objectCategory |
ObjectClass |
objectClass |
ObjectState |
|
RawCanonicalName |
canonicalName |
WhenChanged |
WhenChanged |
WhenCreated |
whenCreated |
DistinguishedName |
distinguishedName |
Guid |
objectGuid |
NTSecurityDescriptor |
ntSecurityDescriptor |
Name |
name |
OriginalPrimarySmtpAddress |
|
OriginalWindowsEmailAddress |
|
"Get-Group -Filter" reference table:
OPATH Name |
LdapDisplayName |
GroupType |
groupType |
ManagedBy |
managedBy |
RecipientType |
|
RecipientTypeDetails |
|
SamAccountName |
SamAccountName |
Sid |
objectSid |
SidHistory |
sIDHistory |
SimpleDisplayName |
displayNamePrintable |
WindowsEmailAddress |
|
DisplayName |
displayName |
Notes |
info |
Members |
member |
PhoneticDisplayName |
msDS-PhoneticDisplayName |
Id |
distinguishedName |
ExchangeVersion |
msExchVersion |
RawName |
name |
OriginalId |
|
ObjectCategory |
objectCategory |
ObjectClass |
objectClass |
ObjectState |
|
RawCanonicalName |
canonicalName |
WhenChanged |
WhenChanged |
WhenCreated |
whenCreated |
DistinguishedName |
distinguishedName |
Guid |
objectGuid |
NTSecurityDescriptor |
ntSecurityDescriptor |
Name |
name |
OriginalPrimarySmtpAddress |
|
OriginalWindowsEmailAddress |
|
Comments
Anonymous
January 01, 2003
In the Do I Really Need to Upgrade my Filters blog post, Several folks posted a question/comment askingAnonymous
January 01, 2003
Microsoft Exchange PHP WebDAV Examples How to analyze Exchange Server SMTP log files in Microsoft ExcelAnonymous
January 01, 2003
Manjit - I don't understand your question. You can manage any GAL objects through PowerShell in Exchange 2007, but you can't do much with the filter for the Default GAL (it has, effectively, a hardcoded filter). EvanAnonymous
January 01, 2003
Evan Dodds posted a very good reference kind of post on his blog - talking about what the filterable...Anonymous
January 01, 2003
Wow! You are my "Exchange 2007 SysMgmt"-Hero! Cheers Christian SchindlerAnonymous
February 20, 2007
This is awesome.Anonymous
March 03, 2007
Its really helpful and handy Scripts Dictionery. Thanks for consolidating all these .I have a Quesry as I am not Good and even Close to Scripting.The Issue I am facing is that . We are migrating from 2003 to 2007 Forest to forest , We have setup IIFP for GAL synch.GAL got Synch in both the DCs But In outlook on 2k7 side we are still not able to resolve those contacts they r there is AD but not showing in GAL. I have checked even in default Global address list they are not appeariung there too. Please Suggest if there any way to check on which Filter or Cretirea this Global Address list is Building in the Exch -2007 . or is there any way to Modify the same through Shell as MS says this is only way to control the default Global Address List can't do through GUI. Regards Manjit