Export Users

[Diane Walker]

We would like to export users from Active Directory (Windows 2000) to a SQL
Database. Is it possible? If so, what utility do you recommend? We just
want the user information such as name, telephone number, and dept.

Thank you.

 

[Tomasz Onyszko]

We would like to export users from Active Directory (Windows 2000) to a SQL
Database. Is it possible? If so, what utility do you recommend? We just
want the user information such as name, telephone number, and dept.

Use ADSI interface and ADO DB proider for Active Directory which comes
with it:
http://msdn.microsoft.com/library/d.../active_directory_service_interfaces_adsi.asp


Script in VBScript or program in VB to transfer this data will be very
simple and will let You to select exatcly this data You will need.

 

[Herb Martin]

Everything Tomasz said plus:

LDIFDE.exe or CSVDE.exe may be of help also.
(Resource kit/Support tools or MS Site downloads)

 

[Diane Walker]

How do I install ADSI?

Thanks.

Use ADSI interface and ADO DB proider for Active Directory which comes
with it:
http://msdn.microsoft.com/library/d.../active_directory_service_interfaces_adsi.asp


Script in VBScript or program in VB to transfer this data will be very
simple and will let You to select exatcly this data You will need.

 

[Diane Walker]

Thank you.

Everything Tomasz said plus:

LDIFDE.exe or CSVDE.exe may be of help also.
(Resource kit/Support tools or MS Site downloads)


--
Herb Martin


a

SQL

Use ADSI interface and ADO DB proider for Active Directory which comes
with it:

http://msdn.microsoft.com/library/d.../active_directory_service_interfaces_adsi.asp

 

[Herb Martin]

ADSI is "part of AD" -- it's the built in programming interface.

What you need is some programming tool that you understand
which has binding/commands for that interface.

VBS, VB, etc. Or one of the tools I mentioned.


--
Herb Martin

How do I install ADSI?

Thanks.

a

SQL

Use ADSI interface and ADO DB proider for Active Directory which comes
with it:

http://msdn.microsoft.com/library/d.../active_directory_service_interfaces_adsi.asp

 

[Diane Walker]

How do I get to ADSI? Can I install this tool at the workstation like the
Active Directory For Computers and Users snap-in? Thanks.

ADSI is "part of AD" -- it's the built in programming interface.

What you need is some programming tool that you understand
which has binding/commands for that interface.

VBS, VB, etc. Or one of the tools I mentioned.


--
Herb Martin

How do I install ADSI?

Thanks.

to

a We
just

http://msdn.microsoft.com/library/d.../active_directory_service_interfaces_adsi.asp

 

[Herb Martin]

How do I get to ADSI? Can I install this tool at the workstation like the
Active Directory For Computers and Users snap-in? Thanks.

ADSI is not a tool. It is a programming interface included on all
Win2000 class boxes, and added to legacy systems by the DSClient
upgrade.

ADSI is the interface USED by many such tools -- programmers use
ADSI to access AD without using a pre-existing program.

One may assume that AD Users and Computers is an ADSI-based
application. (As are things like ADSIEdit, AD Sites and Services, etc.)

If you are not a programmer (or have access to one's services) then
you need a pre-built tool like LDIFDE.exe.

Technically LDIFDE is NOT using ADSI, but rather the alternative
interface, an open standard called LDAP. These are (nearly) functionally
equivalent for AD and choice is more a matter of convenience or
style.

Try LDIFDE or CSVDE and see if the limitations are something you
can get by with. (LDIFDE is more powerful, but CSVDE is simpler
if you needs are modest.)

If these don't work for you, then you likely need a programmer's
assistance.

 

[Diane Walker]

Thank you very much for taking time to explain these.

 

[Herb Martin]

Thank you very much for taking time to explain these.

You're welcome -- I pretty much enjoy simple explanations
that are also useful.