How to find users last login time stamp?

Hi anamikav ,

As a sustainable solution I would say it is much better or easier to read the log file and store it in your DB and use a mechanism to check the users who has not logged in to system for the specified day and notify them and deactivate them. We have similar kind of requirement and we have adopted this approach because this will put lot more less strain on system and easy to maintain and do not have issues where when we need to zip out log files to reduce memory and so on.etc.

You can read each login audit file form previous day and directly write to DB. You should have a clean up mechanism to tables to delete older data so house keeping is done. you can have another process to check for users how have not logged in to system and send notification and later deactivate. If you have a huge user base and just using a function to check a single user last date would user lot of system resources and will be a very slow process.

Regards
Suresh

Hi anamikav ,

As a sustainable solution I would say it is much better or easier to read the log file and store it in your DB and use a mechanism to check the users who has not logged in to system for the specified day and notify them and deactivate them. We have similar kind of requirement and we have adopted this approach because this will put lot more less strain on system and easy to maintain and do not have issues where when we need to zip out log files to reduce memory and so on.etc.

You can read each login audit file form previous day and directly write to DB. You should have a clean up mechanism to tables to delete older data so house keeping is done. you can have another process to check for users how have not logged in to system and send notification and later deactivate. If you have a huge user base and just using a function to check a single user last date would user lot of system resources and will be a very slow process.

Regards
Suresh