Tracy Laugle
asked on
How do I interpret the date from a CSVDE export?
My domain runs two domain controllers with Windows Server 2003. I am trying to get data to support an Active Directory cleanup, so I need a clean, usable export of Active Directory using CSVDE. I have my command written using the filters I need, and it exports beautifully except for one thing: The dates and times that I need are in numerical format (I believe it is Unicode), for example 129207559115462000 is one date/time for a user's last logon. The closest I have come to it Julian time / universal time, but it doesn't match up. Can anyone help me to figure out what date and time this should be? Is there a script that will convert these values to a more recognizable format?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
That's actually an LDAP timestamp. This site: http://www.morecavalier.com/index.php?whom=Apps%2FLDAP+timestamp+converter will allow you to convert it to readable time.
ASKER
This is exactly what I needed! A thousand thank yous! ACBrown2010 - your solution works if I only had a few dates to convert - I have thousands, so the Excel command was what solved my problem. Thanks to all for your help.
adfind from Joe Richards http://www.joeware.net/freetools/tools/adfind/index.htm
adfind -default -f "&(objectcategory=person)(
by the way if you are trying to cleanup old computers and/or users then old computer by Joe Richards is another great tool (has -users switch)
http://www.joeware.net/freetools/tools/oldcmp/index.htm
Thanks
Mike