I am charged with converting our legacy E2003 LDAP filters for our custom address lists to E2007 OPATH format. I must test the new filters first by creating test address lists, converting them, and comparing the resultant lists to the current production lists. The E2007 EMC does not appear to have this functionality built in and I find no "esport-addresslist" cmdlet. I need away to dump the lists' contents to files that I can then run a compare tool against the production lists. John L. McCurdy, EE Messaging Services Administrator - Principal Assistant Building Coordinator 201 Telecom Bldg University of Missouri Columbia, MO 65211 Ph: 573.882.1042 * Fax: 573.884-6000 Email: john@missouri.edu

You could do it like this: Get-AddressList -Identity "All Users" | Select-Object Name, RecipientFilter, LdapRecipientFilter | Export-Csv -Path "C:\temp\all_users.csv" -Encoding Unicode -NoTypeInformation And then import the .CSV file in Excel: Name RecipientFilter LdapRecipientFilter All Users (Alias -ne $null -and ((ObjectCategory -like 'person' -and ObjectClass -eq 'user' -and -not(Database -ne $null) -and -not(ServerLegacyDN -ne $null)) -or (ObjectCategory -like 'person' -and ObjectClass -eq 'user' -and (Database -ne $null -or ServerLegacyDN -ne $null)))) (&(mailNickname=*)(|(&(objectCategory=person) (objectClass=user)(!(homeMDB=*)) (!(msExchHomeServerName=*))) (&(objectCategory=person)(objectClass=user) (|(homeMDB=*)(msExchHomeServerName=*))))) MCTS: Messaging | MCSE: S+M

Thank you for the suggestion. However, when I run that cmdlet, I get: Name,"RecipientFilter","LdapRecipientFilter" and All Users,"","(& (mailnickname=*) (| (&(objectCategory=person)(objectClass=user)(!(homeMDB=*))(!(msExchHomeServerName=*)))(&(objectCategory=person)(objectClass=user)(|(homeMDB=*)(msExchHomeServerName=*))) ))" and that's all. Suggestions appreciated.John L. McCurdy, EE Messaging Services Administrator - Principal Assistant Building Coordinator 201 Telecom Bldg University of Missouri Columbia, MO 65211 Ph: 573.882.1042 * Fax: 573.884-6000 Email: john@missouri.edu

This is Exchange 2010 SP1 RU3. What output do you get if you run this command? [PS] C:\>Get-AddressList -Identity "All Users" | fl RunspaceId : 1d41e9ec-f97f-44fb-b93b-6d47dd9dde19 Container : \ DisplayName : All Users Name : All Users RecipientFilter : (Alias -ne $null -and ((ObjectCategory -like 'person' -and ObjectClass -eq 'user' -and - not(Database -ne $null) -and -not(ServerLegacyDN -ne $null)) -or (ObjectCategory -like ' person' -and ObjectClass -eq 'user' -and (Database -ne $null -or ServerLegacyDN -ne $nul l)))) LdapRecipientFilter : (&(mailNickname=*)(|(&(objectCategory=person)(objectClass=user)(!(homeMDB=*))(!(msExchHo meServerName=*)))(&(objectCategory=person)(objectClass=user)(|(homeMDB=*)(msExchHomeServ erName=*))))) LastUpdatedRecipientFilter : (Alias -ne $null -and ((ObjectCategory -like 'person' -and ObjectClass -eq 'user' -and - not(Database -ne $null) -and -not(ServerLegacyDN -ne $null)) -or (ObjectCategory -like ' person' -and ObjectClass -eq 'user' -and (Database -ne $null -or ServerLegacyDN -ne $nul l)))) RecipientFilterApplied : True IncludedRecipients : ConditionalDepartment : {} ConditionalCompany : {} ConditionalStateOrProvince : {} ConditionalCustomAttribute1 : {} ConditionalCustomAttribute2 : {} ConditionalCustomAttribute3 : {} ConditionalCustomAttribute4 : {} ConditionalCustomAttribute5 : {} ConditionalCustomAttribute6 : {} ConditionalCustomAttribute7 : {} ConditionalCustomAttribute8 : {} ConditionalCustomAttribute9 : {} ConditionalCustomAttribute10 : {} ConditionalCustomAttribute11 : {} ConditionalCustomAttribute12 : {} ConditionalCustomAttribute13 : {} ConditionalCustomAttribute14 : {} ConditionalCustomAttribute15 : {} RecipientContainer : RecipientFilterType : Custom IsValid : True ExchangeVersion : 0.1 (8.0.535.0) DistinguishedName : CN=All Users,CN=All Address Lists,CN=Address Lists Container,CN=DOMAIN,CN=Microsoft Exchang e,CN=Services,CN=Configuration,DC=domain,DC=no Identity : \All Users Guid : 10a38421-9f37-4aee-a409-613b60caf769 ObjectCategory : jfg.no/Configuration/Schema/Address-Book-Container ObjectClass : {top, addressBookContainer} WhenChanged : 29.06.2010 11:30:13 WhenCreated : 13.04.2010 10:58:59 WhenChangedUTC : 29.06.2010 09:30:13 WhenCreatedUTC : 13.04.2010 08:58:59 OrganizationId : OriginatingServer : MBX-01.domain.no [PS] C:\> Note, it is edited from my side in order to hide forest / domain-specific information. MCTS: Messaging | MCSE: S+M

This is Exchange 2007 SP3: Container : \ DisplayName : All Users Name : All Users RecipientFilter : LdapRecipientFilter : (& (mailnickname=*) (| (&(objectCategory=person)(objectClass=user)(!(homeMDB=*))(!(msExchHomeServerName=*))) (&(objectCategory=person)(objectClass=user)(|(homeMDB=*)(msExchHomeServerName=*))) )) LastUpdatedRecipientFilter : RecipientFilterApplied : False IncludedRecipients : ConditionalDepartment : ConditionalCompany : ConditionalStateOrProvince : ConditionalCustomAttribute1 : ConditionalCustomAttribute2 : ConditionalCustomAttribute3 : ConditionalCustomAttribute4 : ConditionalCustomAttribute5 : ConditionalCustomAttribute6 : ConditionalCustomAttribute7 : ConditionalCustomAttribute8 : ConditionalCustomAttribute9 : ConditionalCustomAttribute10 : ConditionalCustomAttribute11 : ConditionalCustomAttribute12 : ConditionalCustomAttribute13 : ConditionalCustomAttribute14 : ConditionalCustomAttribute15 : RecipientFilterType : Legacy IsValid : True OriginatingServer : dc14.domain.edu John L. McCurdy, EE Messaging Services Administrator - Principal Assistant Building Coordinator 201 Telecom Bldg University of Missouri Columbia, MO 65211 Ph: 573.882.1042 * Fax: 573.884-6000 Email: john@missouri.edu

On Exchange 2010, it is RecipientFilterApplied : True. Thus you see the contents of RecipientFilter. On Exchange 2007, it's RecipientFilterApplied : False. Thus there is no content. This was just an example address list. I don't have custom address lists on our Exchange 2010 server at home. So I guess, as soon you test it with a custom address list in Exchange, you'll see some sensible output ... hopefully. Btw, you can add / extend the attributes you want to see with the Select-Object statement, if you need additional information.MCTS: Messaging | MCSE: S+M

We do have a list that has been converted already, and it IS applied, still no data in the .csv Container : \ DisplayName : Columbia Name : Columbia RecipientFilter : TextEncodedORAddress -like 'c=US;a= ;p=University of MO;o=Columbia*' LdapRecipientFilter : (textEncodedORAddress=c=US;a= ;p=University of MO;o=Columbia*) LastUpdatedRecipientFilter : TextEncodedORAddress -like 'c=US;a= ;p=University of MO;o=Columbia*' RecipientFilterApplied : True IncludedRecipients : ConditionalDepartment : ConditionalCompany : ConditionalStateOrProvince : ConditionalCustomAttribute1 : ConditionalCustomAttribute2 : ConditionalCustomAttribute3 : ConditionalCustomAttribute4 : ConditionalCustomAttribute5 : ConditionalCustomAttribute6 : ConditionalCustomAttribute7 : ConditionalCustomAttribute8 : ConditionalCustomAttribute9 : ConditionalCustomAttribute10 : ConditionalCustomAttribute11 : ConditionalCustomAttribute12 : ConditionalCustomAttribute13 : ConditionalCustomAttribute14 : ConditionalCustomAttribute15 : RecipientFilterType : Custom IsValid : TrueJohn L. McCurdy, EE Messaging Services Administrator - Principal Assistant Building Coordinator 201 Telecom Bldg University of Missouri Columbia, MO 65211 Ph: 573.882.1042 * Fax: 573.884-6000 Email: john@missouri.edu

I suggest you refer to the following article to use CSVDE tool to export information to check the result. http://www.computerperformance.co.uk/Logon/Logon_CSVDE_Export.htm Thanks. Novak Wu TechNet Subscriber Support in forum If you have any feedback on our support, please contact tngfb@microsoft.com Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

You must do something different from me. Now I had the chance to test this on an Exchange 2007 Mailbox server (SP3/RU3). It works exactly as on Exchange 2010. MCTS: Messaging | MCSE: S+M

How is thing going on? If there is any progress or question, please feel free to post it here. Regards, Novak Wu TechNet Subscriber Support in forum If you have any feedback on our support, please contact tngfb@microsoft.com Please remember to click Mark as Answer on the post that helps you, and to click Unmark as Answer if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

Thanks to those that posted help. Unfortunately, I have not found a straightforward solution. CSVDE looked promising but I did not have enough time to learn its intricacies, before time constraints required that I go ahead and update the Address Lists with E2007 OPATH filters. That effort appears to have been successful. Thanks again, all. I hope to get back to CSVDE later - it appears to be quite powerful.John L. McCurdy, EE Messaging Services Administrator - Principal Assistant Building Coordinator 201 Telecom Bldg University of Missouri Columbia, MO 65211 Ph: 573.882.1042 * Fax: 573.884-6000 Email: john@missouri.edu