How do I interpret the date from a CSVDE export?
Posted on 2010-09-22
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?