Link to home
Start Free TrialLog in
Avatar of WellingtonIS

asked on

export my user accounts to a spreadsheet

Is there any way I can export my users to a spreadsheet from Active Directory.  I know you can go to the individual OU's and click export but then I have to put it all together in a spreadsheet.  I have a query for enabled users which lists all my users.  I was wondering if I can somehow export that to a file?
Avatar of Gary Dewrell
Gary Dewrell
Flag of United States of America image

Sure can. You can use powershell to do it.  Lot of options so I am going to give you a link.
Avatar of WellingtonIS


OK the only thing is all my users have a wrm in front of there name.  So somewhere I have to note that.
the error I'm getting is Get-ADuser not name of a cmdlet...
ARe you doing this from the DC?  What version of OS is your DC?

To do this remotely you  have to have the Active Directory cmdlets installed. See this article for how to setup your PC for remote AD management.

 or you can also download QADTools from Quest. (Free and has a lof of extra commandlets)
I have no access to the DC only AD tools.
If the DC is 2008 R2 then you can remotely do it via powershell. Follow the article I posted above.
Avatar of Leon Fester
Leon Fester
Flag of South Africa image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
thanks  DSQuery did the trick.