Skip to main content

Data Export: All users and their last login time and date

Data export to show all users and the last time they logged into SelectHR.

H
Written by Harry Ledger
Updated over 5 months ago

To create an export to see the last time each user logged in, follow the steps below.

  1. In the Admin Tool, click Import/Export Data.

  2. Click Create an export definition.

  3. Click Select the data to export.

  4. Connect to the SelectSystem database.

  5. Click the SQL tab.

  6. Copy the SQL data below into the blank space.

    SELECT Security.Users.[User Name], Security.Users.[Windows User Name], Security.Users.[Last Login Time], Security.Users.[Last Logout Time], Security.Users.[Away From], Security.Users.[Returning On], Security.Users.[First Login Time] FROM Security.Users

  7. Click Data. The results will be generated.

  8. In the top left corner, select Person Number as the key field.

  9. In the bottom right corner, click OK.

  10. Name the export definition.

  11. Browse to a file location to save this instance of the export.

  12. Click Next, Next, Finish.

Related Articles
Check a user account is linked to one employee
Data Export: All running absence workflows
Data Export: All users, their assigned menu sets and assigned roles
Audit: Identify changes made to an employee's Bank Details using an audit export
Data Export: Auditing User Account logins, Menu Set & Group Assignments
Did this answer your question?