Solved

ad users report

Posted on 2013-12-02
6
243 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Installing a printer using group policy preferences is not that hard let’s take a look at it. First lets open up your group policy console and edit the policy you want to add it to. I recommend creating a new policy for each printer makes it a l…
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 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…

910 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

19 Experts available now in Live!

Get 1:1 Help Now