Solved

how to extract all user accounts to excel format SBS2008

Posted on 2013-11-02
2
1,805 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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

"Migrate" an SMTP relay receive connector to a new server using info from an old server.
OfficeMate Freezes on login or does not load after login credentials are input.
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

708 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

15 Experts available now in Live!

Get 1:1 Help Now