Solved

ad users report

Posted on 2013-12-02
6
244 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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
PowerShell update AD Fields from CSV file 17 39
Special copy setup request 8 48
GPupdate /sync 1 35
Why would someone make a DC a member of the administrator's group 6 40
In this article, we will see the basic design consideration while designing a Multi-tenant web application in a simple manner. Though, many frameworks are available in the market to develop a multi - tenant application, but do they provide data, cod…
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

813 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