JoshDale
asked on
Exporting Active Directory Users/Groups To A Excell Spreadsheet
How can I do this?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
kelo501
LDIFDE is a great tool, but it will output data in column format, rather than the table format needed by excel
CSVDE will do it in table format if you wish
However, both tools are only supplied on a Server installation of the OS and neither are particularly simple to use, which is why I suggested DUMPSEC (which has a nice GUI too!)
Cheers
JamesDS
LDIFDE is a great tool, but it will output data in column format, rather than the table format needed by excel
CSVDE will do it in table format if you wish
However, both tools are only supplied on a Server installation of the OS and neither are particularly simple to use, which is why I suggested DUMPSEC (which has a nice GUI too!)
Cheers
JamesDS
JamesDS,
To each their own, I guess....
I prefer to use LDIFDE to modify or delete, csvde.exe when I am just getting users in non-exchange domains. I have not used the dumpsec tool. The thing is if your going to work with AD for long these two tools are great to know. Add a little mail merg and you can do quite a few things.
Is DUMPSEC free/shareware?
V.
kelo501
To each their own, I guess....
I prefer to use LDIFDE to modify or delete, csvde.exe when I am just getting users in non-exchange domains. I have not used the dumpsec tool. The thing is if your going to work with AD for long these two tools are great to know. Add a little mail merg and you can do quite a few things.
Is DUMPSEC free/shareware?
V.
kelo501
VBS can do this for you. :)
kelo501
yup Dumpsec is free
Enjoy!
Cheers
JamesDS
yup Dumpsec is free
Enjoy!
Cheers
JamesDS
ASKER
That Dumpsec app is pretty cool.
I just create a query, export it to comma seperated text, and rename it to a csv file.
I just create a query, export it to comma seperated text, and rename it to a csv file.
Here is the info for more help.
Using LDIFDE to Import and Export Directory Objects to Active Directory
http://support.microsoft.com/default.aspx?scid=kb;en-us;237677