Solved

Exporting Active Directory Users/Groups To A Excell Spreadsheet

Posted on 2004-09-01
7
171 Views
Last Modified: 2010-04-12
How can I do this?
0
Comment
Question by:JoshDale
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 16

Accepted Solution

by:
JamesDS earned 500 total points
ID: 11959240
JoshDale
Take a look at DUMPSEC from somarsoft.com

Cheers

JamesDS
0
 
LVL 3

Expert Comment

by:kelo501
ID: 11959695
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
 
LVL 16

Expert Comment

by:JamesDS
ID: 11960026
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
Free Webinar: AWS Backup & DR

Join our upcoming webinar with experts from AWS, CloudBerry Lab, and the Town of Edgartown IT to discuss best practices for simplifying online backup management and cutting costs.

 
LVL 3

Expert Comment

by:kelo501
ID: 11960124
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
 
LVL 18

Expert Comment

by:exx1976
ID: 11960474
VBS can do this for you.  :)
0
 
LVL 16

Expert Comment

by:JamesDS
ID: 11960541
kelo501

yup Dumpsec is free
Enjoy!

Cheers

JamesDS
0
 

Author Comment

by:JoshDale
ID: 11964530
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

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

NTFS file system has been developed by Microsoft that is widely used by Windows NT operating system and its advanced versions. It is the mostly used over FAT file system as it provides superior features like reliability, security, storage, efficienc…
While it may be true that the internet is a place of possibilities, it is also a hostile environment lurking with many dangers. By clicking on the wrong link, trusting the wrong person or using a weak password, you are virtually inviting hackers to …
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question