Solved

how to extract all user accounts to excel format SBS2008

Posted on 2013-11-02
2
1,944 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
2 Comments
 
LVL 40

Accepted Solution

by:
Subsun earned 500 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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

A safe way to clean winsxs folder from your windows server 2008 R2 editions
This script can help you clean up your user profile database by comparing profiles to Active Directory users in a particular OU, and removing the profiles that don't match.
This tutorial will give a short introduction and overview of Backup Exec 2012 and how to navigate and perform basic functions. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as conne…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

815 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now