Sunday, July 12, 2009

LDAP Query for User Accounts Created Since a Specific Date

Just modify the date string to use the YYYYMMDDHHMMSS.0Z format. So, for June 1, 2009, you would specify "20090601000000.0Z"


(&(objectCategory=user)(whenCreated>=20090601000000.0Z))
Posted by at
Labels: , , , ,

10 comments:

  1. UnknownMarch 28, 2012 at 12:00 AM

    Awesome, thanks... this helped me so much!

    ReplyDelete
  2. AnonymousAugust 14, 2014 at 12:56 PM

    Awesome, thanks! Perfect!

    ReplyDelete
    Replies
    1. skatterbrainzAugust 14, 2014 at 1:53 PM

      Thank you! Glad it was helpful.

      Delete
    2. AnonymousAugust 14, 2014 at 4:38 PM

      Oh totally!

      BTW, love the catch phrase on the header :)

      Delete
  3. UnknownMay 26, 2015 at 9:24 AM

    I go looking for this information and am not surprised at all at who the OP is. Thanks Dave!

    ReplyDelete
  4. UnknownMay 26, 2015 at 9:24 AM

    I go looking for this specific bit of information and am not surprised at who the OP is. Thanks Dave!

    ReplyDelete
  5. UnknownSeptember 6, 2017 at 12:30 PM

    It worked! Is there a way to export the query result to a text or csv?

    ReplyDelete
  6. skatterbrainzSeptember 6, 2017 at 2:26 PM


    $Ldate = New-Object System.DateTime(2017,3,1)

    Get-ADUser -Properties name,distinguishedName,whenCreated -Filter {(objectClass -eq "user") -and (whenCreated -ge $Ldate)} |
    ConvertTo-Csv -NoTypeInformation |
    Out-File "adusers.csv"

    ReplyDelete
  7. gpirisFebruary 5, 2018 at 6:21 AM

    What about the deleted users?

    ReplyDelete
  8. skatterbrainzFebruary 5, 2018 at 10:02 AM

    I'm not sure what you're asking. If they're deleted and you don't have them in a Recycle Bin then they're gone.

    ReplyDelete

Subscribe to: Post Comments (Atom)