Imanami Community

Hi

I have been asked to produce a database synchronised from Active Directory and dumping cn, contact details and contents of the lastLogonTimestamp attribute.

Is it possible to synchronise the lastLogonTimestamp attribute, decoding it along the way, and to store it in a SQL table?

Thanks

CarpMan

---

CarpMan

Hello CarpMan,

Attached is a script that can be used to export to an .xls file the lastLogon date for Active Directory accounts.  In order to use the script you will need to save it to your desktop or server, then change the file extension from .txt to .vbs.  The machine the script is saved to will need to have Microsoft Excel installed on it as well.  Double click on the lastlogonScript.vbs to begin.  You will be prompted with a dialog box to enter the number of days the last time a user logged in.  If you set the value to zero (0) it will return all users and their lastLogon date.  After the .xls file is generated it can be used as the source file for the DTM job to synchronize the lastLogon time stamp to the SQL database.

If you have questions about the information provided above, please post back with your response.  Looking forward to hearing from you soon.

BTW: The script can be called using a .bat file that is scheduled to run on a consistent basis, as well.