[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 605
  • Last Modified:

Export Directory in Exchange 2003

I would like to export my Exchange accounts to a CVS file for importation into another organization.  In Exchange 5.5 it was a 2 step process that worked like a charm.  I have tired to use CSVDE but do not get the results I need or get syntax errors.  Any help greatly appreciated.
0
xmouser
Asked:
xmouser
  • 3
  • 3
1 Solution
 
aa230002Commented:
CSVDE is best to use in this case. Let me give you a sample query.

CSVDE -f File_name.csv -d "dc=microsoft,dc=com" -s <dc_name> -r "((objectClass=user))" -l "GivenName,name,displayName,mail,l,co,company"

modify the query according to your requirement.
1. change the file name
2. change the domain name. i have taken microsoft.com as an example.
3. put ur  DC name.

you should have windows support tools installed and at least read permissions on AD. (Domain Admins should be good)

Thanks,
Amit Aggarwal.
0
 
xmouserAuthor Commented:
Thanks for the fast response.  I understand the query and the changes I need to make. However, I am getting "The system cannot find the file specfied"  I have changed the name of File_name.csv as directed.  I even created a csv file with the name of the csv file I put in the query.  I am running the query on a computer, server, with supprot tools installed.
0
 
aa230002Commented:
Simple try to run CSVDE /? from command prompt.
I think the error message you are getting is pointing to the CSVDE.exe file and not the "file_name.csv" file.
make sure that you have CSVDE.exe file on your computer and run this command from there.

Thanks,
Amit Aggarwal.
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
xmouserAuthor Commented:
Actually it was a typo that I missed even though I went over it several times.  It works as intended.  

I probalby should have posted this in the original question but the output below is what I want as this is what I used to get from the directory export function of 5.5.  I bumped the points to 250.  Could you show me how to modify the query for these results?  If not, I will repost as a new question.  The points are yours for the great on the money response.

Obj-Class      First Name      Last name      Display Name    Alias Name      Directory Name      E-mail Address
Remote      Rey      Avilla      Avilla, Rey               n30gemd      30gemd                      SMTP:AvillaRe@test.com
0
 
aa230002Commented:
-l option in CSVDE is used to give the list of attributes that you want in your output. Here are the names of the attribute in AD as per your requirement.

E5.5                         AD
Obj-class                  objectClass
firstname                  givenname
lastname                  sn
display Name             displayName
Alias Name                mailnickname
email address            mail

so, final query should be like this ->
CSVDE -f File_name.csv -d "dc=microsoft,dc=com" -s <dc_name> -r "((objectClass=user))" -l "objectClass,givenname,sn,displayName,mailnickname,mail"

Thanks,
Amit Aggarwal.
0
 
xmouserAuthor Commented:
Beautiful, thanks for your help and patience. Mike
0

Featured Post

Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now