Question

Laserfiche Cloud User Information (how is Date and time Handled in Repository Administration/Management/User)

Laserfiche Cloud Web Client

Updated July 10, 2020

asked on July 9, 2020

When handling date and time for User Information about Last sign in and Last sign out .. can it handle time zones?

When logging in and logging out does the date and time get sent to the Laserfiche server from the client or does Laserfiche server pull the time from the system at the time of log in and log out

If Laserfiche server or DB is generating this time and date for Last sign in and Last sign out.. What is the Time format that is used for the Date and Time when gathering last sign in and last sign out?

I did some research and Laserfiche Cloud uses Microsoft Standard Date and time format strings and I’m guessing it could be format specifier “g” for General date/time pattern (short time) .
Is the time/date format converted in anyway? From “u” for Universal sortable pattern or is it stored in the same date\time format?

Does Management/User under Laserfiche Repository Administration follow the same client to server relationship as the On-Premise Laserfiche Administration Console?

If so … where in the on-premise SQL DB would the Last Login/Log Data be? Regardless if you can point me to the direction of that particular table that holds that data would be greatly appreciated 😊

0 0

Replies

replied on July 10, 2020 • Show version history

Hi Ethan,

User login times can be found (on-prem) in the [user_login] table in the SQL database. They are stored in the SQL datetime datatype, but it looks like they are rounded to seconds. The datetime datatype is format-irrelevant and you can convert it however you want in SQL.

The LF server will be grabbing the current datetime from the server's system info, not from the user's machine.

It stores these in GMT+0 and then will display it to the user in their local time zone. In my DB it shows the admin account as 4:01am on July 10th, but in the repository it says 12:01am (I'm GMT-4).

1 0

replied on July 10, 2020

When you sign out, you are signing out of the Laserfiche server and it knows what time it is, there's no need to communicate this part. All time values like this are stored as UTC in the backend database, so that they can be displayed to users in their timezone. The web management site knows what timezone the user is in, and represents the times appropriately.

1 0

You are not allowed to follow up in this post.

Question

Question

Laserfiche Cloud User Information (how is Date and time Handled in Repository Administration/Management/User)

Replies

Sign in to reply to this post.