how to track user login asp.net identity

Question

I have created an ASP.NET web application using MsSQL and Entity Framework 6.4.4 with individual account authentication, the app works fine but I would like to track user last login time/date as well as login count each time the user connects to the web application.

is there a way to do it, so far I din't find a solution in the many search done. thanks for the help

Pasang Tamang · Answer

Hi, If you are using ASP.NET Identity then you can customize it. Check below code example. public class ApplicationUser : IdentityUser { public DateTime LastLoginDate{ get; set; } public int LoginCount{ get; set; } } Check this article also https://procodeguide.com/asp-net-core/user-management-in-aspnet-core/. This explains a lot about customizing Identity. Regards, Pasang

Raymond G · Answer

Hi, thanks for the feedbacks I have followed Passang procedure and looks to work for a NEW login but I still miss track of users already logged in who checked the remember me, I will try to find a solution for this.

Vishal Joshi · Answer

Hello There are several ways to track user login activity. User Activity logging app using Action Filter and log4net. https://weblogs.asp.net/shijuvarghese/user-activity-logging-in-asp-net-mvc-app-using-action-filter-and-log4net Use database TRIGGERs to tap events at table level and then perform logging. This will be completely 'abstract' to the app. I've "LastModifiedBy" field in each table so I'll get the 'actor' data and I can do the logging but this might limit me to DB-operations & need me to track other app-activities separately. but if its worth I can consider it. Simple old way of using two tables: Activity (stores ALL the activities along with its actor) & ActivityType (lists types of activities). I've a service layer so either I can have a "ServieBase" class which taps ALL the CRUD events and logs the one in which I'm interested. Everything is handled from within the code. Trace Activities with NLog. In case we don't need to store data in database and keep database lignweight, we can use NLog to trace user activities. https://tpodolak.com/blog/2017/02/18/asp-net-core-tracking-flow-requests-nlog/ Thanks

Pasang Tamang · Answer

You can check this article also https://www.c-sharpcorner.com/UploadFile/90fded/how-to-customized-identity-in-Asp-Net-mvc5/. Btw, you will have to update last login date when user login into the system. Regards, Pasang