last access of users

lele9 · 2012-01-25 12:37:59

how can i see last access timestamp of each user?

ab · 2012-01-25 13:32:36

Search in the TAuthSession.User property of TSQLRestServer.fSessions[] array: the last access time stamp is stored in LastAccess property.

Please note that access to the fSessions[] array is protected by a fSessionCriticalSection lock.

See some code for safe access to fSessions[] array in TSQLRestServer.SessionGetUser() method.

lele9 · 2012-01-25 15:42:28

yes i know session but with this i can have just the user logged in, instead i want to know the last access of all user. it's possible?

ab · 2012-01-25 16:13:31

No, it is not possible by default, since there is no such data stored within the database.
The only data available is in the TAuthSession in-memory tables.

You will have to save it in the database, e.g. in a dedicated audit-trail table (like in the MainDemo).
Or you may use the TSQLAuthUser.Data blob field to store some data within (e.g. via a RecordSave), and set the latest accessed date and time (and IP, or other).

lele9 · 2012-01-25 16:47:57

i understand.
i think there is an easy way to do but its ok, when i have time to try i post my solution for other user.
thanks a lot.
Emanuele.

lestat · 2012-03-05 10:28:17

How can i convert the last access property in date and time?

Tanks

ab · 2012-03-05 13:09:06

This is an Iso8601 encoded property, i.e. a Int64 which can be mapped into a Iso8601 object.

See the documentation about this type.

You can use Iso8601(aTimeProperty).ToDateTime e.g.

lestat · 2012-03-07 13:39:47

Thanks ab.

it works with iso8601now but with last access it returns an error.
for example lastaccess is 19775435, and iso86now is 135032268700

ab · 2012-03-07 14:23:49

I'm sorry, I did not check the source code earlier.
So my answer above was incorrect.

lastaccess is NOT an Iso8601 timestamp.
This is a cardinal value retrieved from GetTickCount. GetTickCount is much faster than the TDateTime equivalency.
There is no easy way of converting it into a time stamp.
Purpose of LastAccess was not to be retrieved directly, but to handle session timeouts.

lestat · 2012-03-07 15:10:12

Thanks for your answer ab

mORMot Open Source

#1 2012-01-25 12:37:59

last access of users

#2 2012-01-25 13:32:36

Re: last access of users

#3 2012-01-25 15:42:28

Re: last access of users

#4 2012-01-25 16:13:31

Re: last access of users

#5 2012-01-25 16:47:57

Re: last access of users

#6 2012-03-05 10:28:17

Re: last access of users

#7 2012-03-05 13:09:06

Re: last access of users

#8 2012-03-07 13:39:47

Re: last access of users

#9 2012-03-07 14:23:49

Re: last access of users

#10 2012-03-07 15:10:12

Re: last access of users

Board footer