users last logon date

[Guest Close Guest]

How to create a report that shows the last logon date/time for the AD users?
Appreciate any help.

[Guest Close cmccullough]

Re: users last logon date

To get last logon information from your users, it is best to use Exporter Pro for this because it can check all domain controllers, whereas Hyena will only look at one controller. Last Logon is stored locally on each domain controller and not part of the data that gets replicated between them.

Click on your domain in Hyena to select it, then go to Tools->Exporter Pro->Export Selected Objects. Click the Settings button, then double-click on Detailed Users under Active Directory. Check the box to enable it and enter an output filename. Click the button for Set Options and check the box to export information from all domain controllers. Also make sure Last Logon is listed in the window as one of the fields to export.

Run that export and when finished you can open the output file with Excel.

[Guest Close Guest]

Re: users last logon date

Thank You for this fast reply !

[Guest Close Trammel]

Re: users last logon date

Go in to custom querys and add a custom field lastlogontimestamp. This is replicated between domain controlers for users and computers.

Pretty sure this is in another thread somewhere. Just found this while looking up something my self

[Guest Close Guest]

Re: users last logon date

This solution worked fine for me.
Many thanks.

[kstanush Administrator Find all posts View Profile Close kstanush]

Re: users last logon date

Using LastLogonTimeStamp can save a lot of time, but do a quick Google search on it to understand how it works. Its not really the last time, but close, so it shows accounts with activity, but not always the absolute last one.