Evan Dodds - Microsoft Exchange Server Blog

Exchange, Exchange administration stuff, and other assorted ramblings

Filterable Properties in Exchange 2007 RTM

Filterable Properties in Exchange 2007 RTM

  • Comments 7
  • Likes

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:

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:

*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:

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

mail

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

mail

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

mail

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

mail

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

mail

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

mail

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

mail

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

mail

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

mail

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
  • This is awesome.

  • Evan Dodds posted a very good reference kind of post on his blog - talking about what the filterable...

  • Wow! You are my "Exchange 2007 SysMgmt"-Hero!

    Cheers

    Christian Schindler

  • Microsoft Exchange PHP WebDAV Examples How to analyze Exchange Server SMTP log files in Microsoft Excel

  • 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

  • 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).

    Evan

  • In the Do I Really Need to Upgrade my Filters blog post, Several folks posted a question/comment asking

Your comment has been posted.   Close
Thank you, your comment requires moderation so it may take a while to appear.   Close
Leave a Comment