Exporting an object list from AD

[Dean]

Does anyone know how I can export a list of computer
objects or any objects for that matter from an OU into
Excel?

Thanks,
Dean

 

[Guest]

Dean,

There's a utility called CSVDE -
http://www.microsoft.com/windowsxp/.../windowsxp/home/using/productdoc/en/csvde.asp

Never used it in anger myself, but I did try it in a laba
while ago, and it dumped AD info into CSV file format.

Good luck!

Barnski.

 

[Cary Shultz [A.D. MVP]]

Dean,

There is one solution for you as long as you want Excel! That would be
csvde. It should be natively available in WIN2000. I would suggest that
you enter csvde /? at a command prompt at a WIN2000 Server to verify this.

Are you familiar with csvde? if not, I am sure that you could do a google
and find a wealth of information on it.

Here are some MSKB Articles that might not directly apply to what you want
but should be of some benefit to you:

http://support.microsoft.com/default.aspx?scid=kb;en-us;276440
http://support.microsoft.com/default.aspx?scid=kb;en-us;327620
http://support.microsoft.com/default.aspx?scid=kb;en-us;298882

There is another tool out there called ldifde that is really great as well
but the output ( or input, depending on which way you are going ) is not
nearly as user friendly. It makes use of .ldf files that you can use
Notepad to open but the syntax is a bit challenging.

HTH,

Cary