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?

Gary Dewrell

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

http://stackoverflow.com/questions/4381943/how-to-export-csv-of-active-directory-objects

WellingtonIS

ASKER

OK the only thing is all my users have a wrm in front of there name. So somewhere I have to note that.

WellingtonIS

ASKER

the error I'm getting is Get-ADuser not name of a cmdlet...

Gary Dewrell

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.
http://technet.microsoft.com/en-us/magazine/gg413289.aspx

or you can also download QADTools from Quest. (Free and has a lof of extra commandlets)

WellingtonIS

ASKER

I have no access to the DC only AD tools.

Gary Dewrell

If the DC is 2008 R2 then you can remotely do it via powershell. Follow the article I posted above.

ASKER CERTIFIED SOLUTION

Leon Fester

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

WellingtonIS

ASKER

thanks DSQuery did the trick.