Active Directory accounts created in the last 90 days

The following should filter out the users only.


dsquery * -filter "(&(objectClass=user)(whenCreated>=20101022083730.0Z))"

The date is in UTC format which means YYYYMMDDHHMMSS.0z

Format "whenCreated" & "whenChanged" CSVDE Fields in Excel

The formula you need to use is;

=MID(D10,7,2)&"/"&MID(D10,5,2)&"/"&LEFT(D10,4)

How to format fields in CSVDE csv dump to display as a date?

The formula to convert from Active Directory LastLogon or LastLogonTimestamp for excel is:


Code :
1.=IF(C2>0,C2/(8.64*10^11) - 109205,"")

Obviously change the C2 to mirror the filed with the date data.