Thanks. I was actually looking for kind of excel formula when I have all number on one row and the other row will show me the good stuff :)
-----Original Message----- From: William M. Ryan [mailto:[EMAIL PROTECTED] Sent: May 30, 2008 11:33 AM To: Active Directory Admin Issues Subject: Re: csvde question Read the following article which describes how to do this and some of the other issues related to last logon times stored in AD http://www.microsoft.com/technet/scriptcenter/topics/win2003/lastlogon.m spx William M. Ryan Information Technology Specialist 4 Bureau of Information Technology Services NYS DOH Division of Nutrition "Ara Avvali" <[EMAIL PROTECTED]> To 05/30/2008 11:28 "Active Directory Admin Issues" AM <[email protected] > cc Please respond to "Active Directory Subject Admin Issues" csvde question <[EMAIL PROTECTED] nbelt-software.co m> Hello everyone, I just ran a csvde from our AD to get a report of last logged on time. Numbers are in 1.2856E+17 and I can't figure out how to convert it to "human" readable format. Do you have the formula on top of your mind? Appreciated ~ NEW: CounterSpy Enterprise: Centralized Antispyware - #1 in eWEEK Test! ~ ~ <http://www.sunbelt-software.com/product.cfm?id=400> ~ IMPORTANT NOTICE: This e-mail and any attachments may contain confidential or sensitive information which is, or may be, legally privileged or otherwise protected by law from further disclosure. It is intended only for the addressee. If you received this in error or from someone who was not authorized to send it to you, please do not distribute, copy or use it or any attachments. Please notify the sender immediately by reply e-mail and delete this from your system. Thank you for your cooperation. ~ NEW: CounterSpy Enterprise: Centralized Antispyware - #1 in eWEEK Test! ~ ~ <http://www.sunbelt-software.com/product.cfm?id=400> ~ ~ NEW: CounterSpy Enterprise: Centralized Antispyware - #1 in eWEEK Test! ~ ~ <http://www.sunbelt-software.com/product.cfm?id=400> ~
