Microsoft Exchange Server Powershell Cookbook (Update)

There are a number of EMS cmdlets that provide a -Filter parameter that can be used to narrow searches based on the value of an OPath property. These properties can also map to a particular LDAP attribute.

The following table lists some of the commonly used properties and the cmdlets that can be used to query their values using the -Filter parameter:

Property Name	Attribute	Cmdlets Supported	Input Value
`Alias`	`mailNickname`	`Get-DistributionGroup` `Get-DynamicDistributionGroup` `Get-Mailbox` `Get-MailContact` `Get-MailPublicFolder` `Get-MailUser` `Get-Recipient` `Get-RemoteMailbox`	String/Wildcard
`City`	`L`	`Get-Contact` `Get-Recipient` `Get-User`	String/Wildcard
`Company`	`Company`	`Get-Contact` `Get-Recipient` `Get-User`	String/Wildcard
`Database`	`homeMDB`	`Get-Mailbox` `Get-Recipient`	DN
`Department`	`department`	`Get-Contact` `Get-Recipient` `Get-User`	String/Wildcard
`DisplayName`	`displayName`	`Get-CASMailbox` `Get-Contact` `Get-DistributionGroup` `Get-DynamicDistributionGroup` `Get-Group` `Get-Mailbox` `Get-MailboxStatistics` `Get-MailContact` `Get-MailPublicFolder` `Get-MailUser` `Get-Recipient` `Get-RemoteMailbox` `Get-UMMailbox` `Get-User`	String/Wildcard
`DistinguishedName`	`distinguishedName`	`Get-CASMailbox` `Get-Contact` `Get-DistributionGroup` `Get-DynamicDistributionGroup` `Get-Group` `Get-Mailbox` `Get-MailContact` `Get-MailPublicFolder` `Get-MailUser` `Get-Recipient` `Get-RemoteMailbox` `Get-UMMailbox` `Get-User`	DN
`EmailAddresses`	`proxyAddresses`	`Get-CASMailbox` `Get-DistributionGroup` `Get-DynamicDistributionGroup` `Get-Mailbox` `Get-MailContact` `Get-MailPublicFolder` `Get-MailUser` `Get-Recipient` `Get-RemoteMailbox` `Get-UMMailbox`	E-mail Address (wildcard)
`FirstName`	`givenName`	`Get-Contact` `Get-Recipient` `Get-User`	String/Wildcard
`HiddenFromAddressListsEnabled`	`msExchHideFromAddressLists`	`Get-DistributionGroup` `Get-DynamicDistributionGroup` `Get-Mailbox` `Get-MailContact` `Get-MailPublicFolder` `Get-MailUser` `Get-Recipient` `Get-RemoteMailbox`	$true $false
`HomePhone`	`homePhone`	`Get-Contact` `Get-User`	String/Wildcard
`LastName`	`sn`	`Get-Contact` `Get-Recipient` `Get-User`	String/Wildcard
`Manager`	`manager`	`Get-Contact` `Get-Recipient` `Get-User`	String/Wildcard
`Name`	`name`	`Get-CASMailbox` `Get-Contact` `Get-DistributionGroup` `Get-DynamicDistributionGroup` `Get-Group` `Get-Mailbox` `Get-MailContact` `Get-MailPublicFolder` `Get-MailUser` `Get-Recipient` `Get-RemoteMailbox` `Get-UMMailbox` `Get-User`	String
`Phone`	`telephoneNumber`	`Get-Contact` `Get-Recipient` `Get-User`	String/Wildcard
`PrimarySmtpAddress`	N/A	`Get-CASMailbox` `Get-DistributionGroup` `Get-DynamicDistributionGroup` `Get-Mailbox` `Get-MailContact` `Get-MailPublicFolder` `Get-MailUser` `Get-Recipient` `Get-RemoteMailbox` `Get-UMMailbox`	SMTP Address
`SamAccountName`	`SamAccountName`	`Get-CASMailbox` `Get-DistributionGroup` `Get-Group` `Get-Mailbox` `Get-MailUser` `Get-Recipient` `Get-RemoteMailbox` `Get-UMMailbox` `Get-User`	String
`StateOrProvince`	`st`	`Get-Contact` `Get-Recipient` `Get-User`	String/Wildcard
`StreetAddress`	`streetAddress`	`Get-Contact` `Get-User`	String
`Title`	`title`	`Get-Contact` `Get-Recipient` `Get-User`	String
`UserPrincipalName`	`userPrincipalName`	`Get-Mailbox` `Get-MailUser` `Get-Recipient` `Get-RemoteMailbox` `Get-User`	User logon name User principal name/Wildcard

The preceding table only includes a list of commonly used filterable properties that can be used with the –Filter parameter. In addition to this list, there are several other properties that can be filtered. Refer to the article in the TechNet documentation for a complete list at http://technet.microsoft.com/en-us/library/bb738155(v=exchg.150).aspx.

Microsoft Exchange Server Powershell Cookbook (Update)

Microsoft Exchange Server Powershell Cookbook (Update)

Overview of this book

Related Content you might be interested in

Current Title:

Microsoft Exchange Server Powershell Cookbook (Update)

Properties that can be used with the -Filter parameter