0
If I query the directory, I get the following results.
ldapsearch2.4 -x -b "dc=localhost,dc=com" "cn=auser" "+" | grep stamp
createTimestamp: 20100407122221Z
modifyTimestamp: 20100407122221Z
createTimestamp: 20100407122436Z
modifyTimestamp: 20111229151358Z
I am pulling the directory into an spread sheet so we can perform an audit on our list of users. The current date stamp is not simple to convert into a spread sheet understandable date time object.
This helped me understand how the actual date is stored but I still need a way to convert it. http://www.novell.com/coolsolutions/qna/6668.html
This will return Greenwich Mean Time (GMT) in the following format: yyyymmddhhmmssZ
Excellent. Ensure that the conversion cell supports the entire generalized time syntax as defined in rfc4517.
– Terry Gardner – 2012-06-30T09:32:18.353@TerryGardner, the time syntax can be set by the format options proved by office. Libra Office simply stores it a long int, http://help.libreoffice.org/Common/Number_Format_Codes.
– nelaaro – 2012-07-02T08:12:35.830