?
Solved

how to extract all user accounts to excel format SBS2008

Posted on 2013-11-02
2
Medium Priority
?
2,237 Views
1 Endorsement
Last Modified: 2013-11-02
I'm getting close to max users in SBS2008 is there a way to extract all the users to excel for reporting purposes. I need to make notes and following up with accounts not being used that can be deleted.
1
Comment
Question by:WORKS2011
[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
2 Comments
 
LVL 40

Accepted Solution

by:
Subsun earned 2000 total points
ID: 39618872
Try..
Import-Module ActiveDirectory
Get-ADUser -Filter *  | export-CSV C:\users.csv

Open in new window


Or you can use CSVDE...
http://ss64.com/nt/csvde.html
CSVDE -f C:\MyUsers.csv -r (objectClass=User)

Open in new window

0
 
LVL 17

Author Closing Comment

by:WORKS2011
ID: 39619452
perfect THANK YOU!!! used the CSVDE.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Previously, on our Nano Server Deployment series, we've created a new nano server image and deployed it on a physical server in part 2. Now we will go through configuration.
Resolving an irritating Remote Desktop connection that stops your saved credentials from being used.
This tutorial will show how to configure a new Backup Exec 2012 server and move an existing database to that server with the use of the BEUtility. Install Backup Exec 2012 on the new server and apply all of the latest hotfixes and service packs. The…
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Suggested Courses

777 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