Exporting Address list contents to file
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
June 16th, 2011 3:42pm
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
Free Windows Admin Tool Kit Click here and download it now
June 16th, 2011 4:53pm
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
June 17th, 2011 10:47am
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
Free Windows Admin Tool Kit Click here and download it now
June 17th, 2011 12:04pm
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
June 17th, 2011 12:12pm
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
Free Windows Admin Tool Kit Click here and download it now
June 17th, 2011 12:26pm
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
June 17th, 2011 3:51pm
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.
Free Windows Admin Tool Kit Click here and download it now
June 19th, 2011 11:46pm
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
June 20th, 2011 5:43am
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.
Free Windows Admin Tool Kit Click here and download it now
June 27th, 2011 1:48am
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
June 27th, 2011 6:36pm