Export First Name, Last name, e-mail from AD

[Ray Bell]

How can you export First Name, Last name, and e-mail from Active Directory?

I want to export it so that i can import it into sql server.

Any help would be most appreciated.

Thanks.
Ray.

 

[Marc]

If this is for a one shot, you can use the information
described there:
http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/netdir/adsi/distributed_query.asp

If you intend to constantly synchronize SQL from AD,
you'd better investigate a solution based on MLMS/MIIS:
http://www.microsoft.com/windowsserver2003/technologies/di
rectory/miis/default.mspx

Marc