Solved

Posted on 2016-08-09
31 Views
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
• 5
• 4

LVL 1

Expert Comment

ID: 41749681
Do you want to continue using adfind, or powershell?
0

LVL 1

Expert Comment

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


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

Author Comment

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

Thank you
0

LVL 1

Accepted Solution

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

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

Author Comment

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

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

Author Comment

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

ID: 41750440
get-aduser your-user-name -properties *


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

ID: 41750459
Thanks again
0

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…