ad users report

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.
Who is Participating?

Improve company productivity with a Business Account.Sign Up

Will SzymkowskiConnect With a Mentor Senior Solution ArchitectCommented:
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"

ZenVenkyConnect With a Mentor ArchitectCommented:
I think this can can accomplished by powershell. I found one powershell script in Technet which gives you last logon info about user.
pma111Author Commented:
Will - in what tool do you run that command?
Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

Will SzymkowskiSenior Solution ArchitectCommented:
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.

pma111Author Commented:
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?
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.