Solved

ad users report

Posted on 2013-12-02
6
240 Views
Last Modified: 2013-12-02
Is there anyway to get a report from Active Directory of all user accounts, listing the following fields

1.Account name
2.Last login date
3.Password expires (yes/no)
4.Password last set date
5.Account status (i.e. open, locked/expired, disabled)

Ideally written into a text file, or csv etc.
0
Comment
Question by:pma111
  • 2
  • 2
  • 2
6 Comments
 
LVL 9

Assisted Solution

by:Zenvenky
Zenvenky earned 250 total points
ID: 39689535
I think this can can accomplished by powershell. I found one powershell script in Technet which gives you last logon info about user.

http://gallery.technet.microsoft.com/scriptcenter/Get-Active-Directory-User-bbcdd771
0
 
LVL 53

Accepted Solution

by:
Will Szymkowski earned 250 total points
ID: 39689623
Use the following command below to accomplish this...

Export to CSV
Get-ADUser -Filter * -Properties * | Select sAMAccountName, LastLogonDate, PasswordExpired, PasswordLastSet, Enabled | Export-csv "c:\exportedusers.csv"

Export to txt
Get-ADUser -Filter * -Properties * | Select sAMAccountName, LastLogonDate, PasswordExpired, PasswordLastSet, Enabled | out-file "c:\exportedusers.txt"

Will.
0
 
LVL 3

Author Comment

by:pma111
ID: 39689734
Will - in what tool do you run that command?
0
Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

 
LVL 53

Expert Comment

by:Will Szymkowski
ID: 39689752
This is a Powershell Script. Also make sure that you run the below command before it will work...

Import-Module activedirectory

Then run the above commands.

Will.
0
 
LVL 3

Author Comment

by:pma111
ID: 39689791
do you have to run that on the domain controller? When you run

Import-Module activedirectory

Where are you importing it from? Do you need to install anything first?
0
 
LVL 9

Expert Comment

by:Zenvenky
ID: 39689982
Yes, you need to install Powershell if you have Server 2003. If you have Server 2008 and above versions then by default Powershell installed. However you need to one more feature to install / import AD modules, check this links..

AD Modules
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

Do you have users whose passwords are expiring and they are constantly calling you?  Well I sure did and needed a way to put an end to this.  We have a lot of remote users which would not be notified that their passwords were expiring since they wer…
Find out how to use Active Directory data for email signature management in Microsoft Exchange and Office 365.
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles from a Windows Server 2008 domain controller to a Windows Server 2012 domain controlle…

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

17 Experts available now in Live!

Get 1:1 Help Now