Is there a way to query a user's actual last-login date/time directly from the database, since IFS Cloud doesn't have the same server-log category that Apps8 used for this?

All FAQ questions / Security and access

Answer

One confirmed approach queries the user-client-profile tables directly — joining the profile identity table to its associated profile-value table and taking the most recent modified-date per user gives a workable last-accessed timestamp per user, as an alternative to relying on the newer login-event tables (which may not retain long-term history) or an external identity provider's own sign-in logs.

Documentation-based answer. Confirm the product and release before applying it. This answer has not been verified in an IFS environment.

← Browse Security and access questions