Article Details
Id:18111
Product:finPOWER Connect
Type:NEW
Version:3.04.00
Opened:03/02/2021
Closed:21/04/2021
Released:30/06/2021
Job: J025903

Users; Last login date for a User now stored on the database

Previously, to determine the last login date for a User, the most recent "User Login" Audit Log had to be retrieved manually. In addition, it was possible via the User Policy to switch auditing for successful logins off, which would have made it impossible to determine the last login date for a User.

There is now a dedicated database field "LastLoginUtcDate" on the User table which can be used to reliably query login dates, regardless of User Policy settings.

The following Business Layer Properties and Functions are available to get these dates from the Business Layer:

finUser.LastLoginDate
finUser.LastLoginUtcDate

finUserRO.GetLastLoginDate(lastLoginDate)
finUserRO.GetLastLoginUtcDate(lastLoginUtcDate)