Query Active Directory

[Harrison Midkiff]

Hello:

I need to query my Active Directory to get all my OU's and User ID's and put
them into an Excel spreadsheet.

Does anyone know how to do this?

Harrison Midkiff

 

[Tony Murray [MVP]]

Harrison

Have a look at CSVDE.

http://www.microsoft.com/windows2000/techinfo/planning/act
ivedirectory/bulksteps.asp

You could also use VBA (together with ADSI) within Excel
to pull in the info.

Tony
www.activedir.org

 

[Harrison Midkiff]

Tony:

Thanks for your reply.

You don't happen to know of any utilities that can do this? This process
seems kind of drawn out.

Harrison Midkiff

 

[JB]

An easier way would be to open AD users and computers,
get the view you want, right click the object above (such
as an OU) and select "export list"