Exporting Active Directory Users/Groups To A Excell Spreadsheet

How can I do this?
JoshDaleAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
JamesDSConnect With a Mentor Commented:
JoshDale
Take a look at DUMPSEC from somarsoft.com

Cheers

JamesDS
0
 
kelo501Commented:
Use the "LDIFDE" utility

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
0
 
JamesDSCommented:
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
0
Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

 
kelo501Commented:
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
0
 
exx1976Commented:
VBS can do this for you.  :)
0
 
JamesDSCommented:
kelo501

yup Dumpsec is free
Enjoy!

Cheers

JamesDS
0
 
JoshDaleAuthor Commented:
That Dumpsec app is pretty cool.
I just create a query, export it to comma seperated text, and rename it to a csv file.
0
All Courses

From novice to tech pro — start learning today.