When was extranet user last logged in prior to this login

Hans Ravnsfjall

Posted on 29/05/2020 11:13:31

Is it possible to get info about a current logged in extranet user, and when he/she was last logged in, prior to this current session?

Is it possible to get this info, in a template? If so, how can this be achieved?

/Hans

Replies

Hans Ravnsfjall

Posted on 02/06/2020 10:12:44

Is this possible? :)

Nicolai Pedersen

Posted on 02/06/2020 11:56:59

You can find it in [StatExtranet] table in the database.

If you are using the new "Tracking" feature in DW, you can find it in "TrackingEvent" table with the EventName being "User.Login" and the [TrackingEventEntityKey] being the userid.

Hans Ravnsfjall

Posted on 02/06/2020 15:17:25

Ok, perfect

How could I implement this in Template?

Any example on how this could be accessed?

/Hans

Nicolai Pedersen

Posted on 02/06/2020 16:18:36

This post has been marked as an answer

Something like this:

@{ 
        if(Model.CurrentUser != null)
        {
            DateTime? lastlogin = null;
            using (var reader = Dynamicweb.Data.Database.CreateDataReader(String.Format("SELECT TOP (1) [StatExtranetTimeStamp] FROM [StatExtranet] where [StatExtranetAccessUserID] = {0} order by [StatExtranetTimeStamp] desc", Model.CurrentUser.ID)))
            {
                if (reader.Read())
                {
                    lastlogin = Dynamicweb.Core.Converter.ToNullableDateTime(reader["StatExtranetTimeStamp"], null);
                }
            }
            if (lastlogin.HasValue)
            {
                <span>User last logged in: @lastlogin.Value.ToString("g")</span>
            }
            else
            {
                <span>Seems like you have never logged in before. Welcome!</span>
            }
        }
    }

Votes for this answer: 1

Hans Ravnsfjall

Posted on 02/06/2020 16:29:10

Fantastic Nicolai, thank you 👍🏻

You must be logged in to post in the forum

Developer forum

When was extranet user last logged in prior to this login

Replies