How to fetch Last Login date of Users from DB?
Issue Description
Last Login date of Users column is null in dbo.users table.
Resolution
From Orchestrator version 2022.10, the data is stored at the identity level. During the login procedure, a new entry is consistently created in the [UserLoginAttempts] table, linked to each user, making it possible to locate the most recent entry for each user and find the latest time in the CreationTime column.