application csvde.exe that already resides on your domain controllers.
Although, since it is the quick and dirty method, you will end up with a
CSV file that contains all of the attributes of the objects exported. It
should be easy enough to copy and paste the name and mail columns. Here
is an example if the contacts are all within one OU:
csvde -m -f parents.csv -d "ou=3Dparents,dc=3Dschool,dc=3Dorg" -r
"(objectClass=3Dcontact)"
Entering csvde on a command line by itself will give you a quick help
guide.
-Matthew
___________________________________________=20
Matthew Datcher
Senior Network Engineer
CCDP, CCNP, CCSP, MCNE, MCSE
designDATA
7606 Lindbergh Drive | Gaithersburg, Maryland 20879
240.599.1500 (direct) | 301.921.6696 (main) | 240.599.1555 (system desk)
mdatcher@designDATA.com | http://www.designDATA.com
New to designDATA? Watch our 3 minute introductory video here!
http://www.designdata.com/designdata-movie.html
Notice: This email message, including any attachments, is for the sole
use of the recipients to whom it is addressed, and may contain
information that is proprietary, privileged and/or confidential. If you
are not the intended recipient, please contact the sender by reply email
and delete the original message without making any copies. If you are
not the intended recipient, unauthorized review, copying, use,
disclosure, or distribution is improper and may be subject to legal
sanctions. Although this e-mail and any attachments are believed to be
free of any virus or other defect that might affect any computer system
into which it is received and opened, it is the responsibility of the
recipient to ensure that it is virus free and no responsibility is
accepted by designDATA for any loss or damage arising in any way from
its use.
-----Original Message-----
From: A forum for independent school educators
[mailto:ISED-L@LISTSERV.SYR.EDU] On Behalf Of Dickenson, Steven
Sent: Friday, November 05, 2010 9:24 AM
To: ISED-L@LISTSERV.SYR.EDU
Subject: Re: Need some help with Active Directory lists
Download Quest's free ActiveRoles PowerShell commandlets and install it
on a computer with PowerShell installed.
http://www.quest.com/powershell/activeroles-server.aspx
Then, assuming all of these contacts are in a single OU in your Active
Directory, run this command in the ActiveRoles PowerShell:
Get-QADObject -SearchRoot 'mydomain.local/Parent Emails' -Type Contact |
Select-Object name,primarysmtpaddress | Export-CSV -Path
'c:\parentemails.csv'
Replace 'mydomain.local/Parent Emails' with your domain and OU path.
S
-----Original Message-----
From: A forum for independent school educators
[mailto:ISED-L@LISTSERV.SYR.EDU] On Behalf Of Bernadette Roche
Sent: Thursday, November 04, 2010 6:02 PM
To: ISED-L@LISTSERV.SYR.EDU
Subject: Need some help with Active Directory lists
I'm out of my knowledge base on this one. I need to export the parent
email addresses we have set up as contacts in our active directory
distribution lists. Ideally, I would love to export to Excel, but right
now, I'll take anything.
=20
Any help would be greatly appreciated!!
=20
Bernadette Roche
Director of Technology
Oakhill Day School
816.436.6228
=20
[ For info on ISED-L see
https://www.gds.org/podium/default.aspx?t=3D128874 ]
Submissions to ISED-L are released under a creative commons,
attribution, non-commercial, share-alike license.
RSS Feed, http://listserv.syr.edu/scripts/wa.exe?RSS&L=3DISED-L
[ For info on ISED-L see
https://www.gds.org/podium/default.aspx?t=3D128874 ]
Submissions to ISED-L are released under a creative commons,
attribution, non-commercial, share-alike license.
RSS Feed, http://listserv.syr.edu/scripts/wa.exe?RSS&L=3DISED-L
[ For info on ISED-L see https://www.gds.org/podium/default.aspx?t=3D128874 ]
Submissions to ISED-L are released under a creative commons, attribution, non-commercial, share-alike license.
RSS Feed, http://listserv.syr.edu/scripts/wa.exe?RSS&L=3DISED-L
