Developer forum

Forum » Development » Login date

Login date

E-mail notifications

Reply
Posted on 14/04/2010 17:39:20


How can I get the last login date for each user?


Replies

 
Nicolai Høeg Pedersen
Posted on 15/04/2010 10:22:49
Reply

If it is for extranet users:

On stylesheet.mdb:
SELECT top 1 Statv2Session.Statv2SessionTimestamp
FROM Statv2Session
WHERE (((Statv2Session.Statv2SessionExtranetUserID)=424))
ORDER BY Statv2Session.Statv2SessionID DESC

 
Nicolai Høeg Pedersen
Posted on 15/04/2010 10:23:00
Reply

 
Posted on 15/04/2010 15:58:31
Reply
Thanks!!
 
Posted on 03/05/2010 10:28:59
Reply
Hi. I tried the code in a query but it doesnt seem to work correctly for me. It only returns a result for a few of our extranet users. And the time is only slightly accurate (105 min off) when the user is logged in. When the user is logged out, the query returns a older date.
Any ideas of what's wrong?
 
Nicolai Høeg Pedersen
Posted on 03/05/2010 10:34:07
Reply
Could you show some code? Especially your Query.
 
Posted on 03/05/2010 13:18:40
Reply
The query is identical to the code you posted earlier:
"SELECT top 1 Statv2Session.Statv2SessionTimestamp
FROM Statv2Session
WHERE (((Statv2Session.Statv2SessionExtranetUserID)=424))
ORDER BY Statv2Session.Statv2SessionID DESC"

I've looked at the StatV2Session table and only a few of the ExtranetUsers get's their sessions registered. And very few sessions at all are registered with a extranetuserID. And those that are registered only have the timestamp of the current session as long as they are logged in. After logout, the latest timestamp is lost.
I use "/admin/public/extranetlogoff.aspx?ID=XX" to logout
 
Nicolai Høeg Pedersen
Posted on 06/05/2010 09:49:40
Reply
Found a bug that resets the user login information in stat database if you use ExtranetLogoff.aspx.

Will be out with 7.1

 

You must be logged in to post in the forum