Avatar of WellingtonIS
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?
Windows Server 2003

Avatar of undefined
Last Comment
WellingtonIS

8/22/2022 - Mon
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...
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
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.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER CERTIFIED SOLUTION
Leon Fester

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
WellingtonIS

ASKER
thanks  DSQuery did the trick.