Users connection time

[TJ53]

Hi, we have a “log” table where a new “session” record is created when a user enters in the system, and when closing the database the is edited in order to keep the timestamp when the user enters and exit. This way we keep track of database usage time.

The problem is when a user gets disconnected from the server (lost internet connection, or some issue with iPhones or iPads).

Is there any way to get the approximate time when a user gets disconnected? is there any workaround to know how long a user has been connected to a database after loosing connection?

Any tip would be appreciated, thanks!