Using CSVDE to export User Names and Email Addresses

[JCDugas]

I'm wondering if anyone out there knows how to export the User Name and Email Addresses of all of my users in Active Directory using the CSVDE or any other tools.

Thanks,

Jeremy

 

[GiaBetiu]

Try

csvde -f output.csv -l "sn, userPrincipalName, mail"
-r "(ObjectClass=User)



Gia Betiu
gia@almondeyes.net
Computer Eng. CNE 4, CNE 5, MCSE Win2K
new:

http://www.almondeyes.net

(just started)

 

[JCDugas]

Cool, that works!

How do I export for a particular OU?

Jeremy

 

[GiaBetiu]

You can study this article:

http://www.microsoft.com/windows200...indows2000/en/server/help/sag_ad_ldif_csv.htm

C:\>csvde -f output2.csv -l "userPrincipalName, mail" -r "(ObjectClass=User)" -d "ou=test,dc=cluster, dc=gia"

in case that you have the domain: "cluster.gia" and the OU inside of the cluster domain is "test".

Gia Betiu
gia@almondeyes.net
Computer Eng. CNE 4, CNE 5, MCSE Win2K
new:

http://www.almondeyes.net

(just started)

 

[tekistry]

My problem is related to this:
When I run this command :

CSVDE -f mstest.csv -r "(&(objectClass=user))" -l "objectClass, displayName, DN, mailNickname, targetAddress, mail"

I also get a bunch of computer accounts showing in the exported file like this:
CN=SA-NAME,CN=Computers,DC=mydomain,DC=co,DC=uk SA-NAME$ computer

I have tried other ObjectClass filters & this does not happen.
Any Ideas?

I have also tried GiaBetiu's suggestion :
csvde -f output.csv -l "sn, userPrincipalName, mail"
-r "(ObjectClass=User)

But still get computer accounts

Any ideas?
Thanks

---------------------------------------
save a life - visit:

http://www.thehungersite.com