Five New Optimizely Certifications are Here! Validate your expertise and advance your career with our latest certification exams. Click here to find out more
AI OnAI Off
Does EPiServer store the users verified date?
With the regular SqlMembershipProvider, EPiServer only has access to what is stored in the default database table aspnet_Membership.
Fields stored in this table are:
UserId, Password, PasswordFormat, PasswordSalt, MobilePIN, Email, LoweredEmail, PasswordQuestion, PasswordAnswer, IsApproved, IsLockedOut, CreateDate, LastLoginDate, LastPasswordChangedDate, LastLockoutDate, FailedPasswordAttemptCount, FailedPasswordAttemptWindowStart, FailedPasswordAnswerAttemptCount, FailedPasswordAnswerAttemptWindowStart, Comment.
As the account is probably created (but locked) until the email verification link is clicked, you don't really have any fields that will tell you the date of verification (or even first successful login).
Sep 23, 2013 21:55
This thread is locked and should be used for reference only. Please use the Episerver CMS 7 and earlier versions forum to open new discussions.
Hi,
Does EPiServer also store the users verified date (the date on which the user clicks on the email to verify his/her account)?
If so, how can I retrieve thi?
With the help of this post (http://www.epinova.no/blog/arild-henrichsen/dates/2011/10/handling-episerver-users-and-roles-reference-list/) I managed to retrieve the user-account-creation-date and the last-updated-date:
// determine when user is created var user = EPiServer.Common.Settings.DefaultSecurity.GetUserByUserName(userName); var userCreatedDate = user.CreateDate; // determine when user-profile is updated var ePiServerProfile = EPiServerProfile.Get(userName); var userUpdateDate = ePiServerProfile.LastUpdatedDate; Log.DebugFormat("user with email [{0}] is created at [{1}] and updated at [{2}]", email, userCreatedDate, userUpdateDate );Leonard