Solved

AD Users With Expiration

Posted on 2016-08-09
9
31 Views
Last Modified: 2016-08-10
Hi,
      I am using ADFind to list my AD users. I would like to add the account expirations if possible. Here is the current script that gives me all the users with their names:

adfind -default -f "&(objectcategory=person)(objectclass=user)" samaccountname displayname -csv > c:\users.csv
Is this possible?

Thank you
0
Comment
Question by:daskas27
  • 5
  • 4
9 Comments
 
LVL 1

Expert Comment

by:SquigglyMonkey
ID: 41749681
Do you want to continue using adfind, or powershell?
0
 
LVL 1

Expert Comment

by:SquigglyMonkey
ID: 41749722
Use to luv me some joeware!!
adfind -default -f "&(objectcategory=person)(objectclass=user)" samaccountname displayname accountexpires -csv > c:\users.csv

Open in new window


You prolly can't really read it though, cause it is in MS speak....
0
 

Author Comment

by:daskas27
ID: 41750159
Me love joeware too! However the dates came back as: 9.22337E+18

Thank you
0
 
LVL 1

Accepted Solution

by:
SquigglyMonkey earned 500 total points
ID: 41750281
That's what I said. I don't think you can use that particular Joeware tool for that, not natively anyway.
open an elevated powershell session and try this:
import-module activedirectory
Get-AdUser -Filter * -Properties * | Select SAMAccountname, DisplayName, AccountExpirationDate | Export-CSV -Path C:\path\to\folder\file.csv

Open in new window

Change the path to wherever you need the exported file.
0
 

Author Comment

by:daskas27
ID: 41750335
I ran the last script in the elevated powershell as directed. It returned the names but no expiration dates. The column was there but they were all blank.
0
 
LVL 1

Expert Comment

by:SquigglyMonkey
ID: 41750374
Are the accounts set to "not expire"? Spot check and see if an account actually has an expiration date.
0
 

Author Comment

by:daskas27
ID: 41750406
Ah ha! That is it. Hey, thanks for your help. Would you want to throw in a lookup for expiring passwords?
0
 
LVL 1

Expert Comment

by:SquigglyMonkey
ID: 41750440
How about this,
get-aduser your-user-name -properties *

Open in new window


This will give you all the properties for your AD account, then find the one(s) you want and add it to the command I gave you above. :)
0
 

Author Closing Comment

by:daskas27
ID: 41750459
Thanks again
0

Join & Write a Comment

I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
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 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…
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 to another domain controller. Log onto the new domain controller with a user account t…

746 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

13 Experts available now in Live!

Get 1:1 Help Now