Daily check for password expire - mid night service

New Implementation :

• Need to create midnight service that will sent email for password expires.
• This service will run for active users (Admin ,Partner,Broker)
• Service will send password expiration emails to those company having "No automatic expiration" and "The number of days prior to password expiration" set to non Zero.
• This service will send email till password is not expire.
• Password expiration email send frequency should be daily at mid night.

• Development Efforts :*
  *User Interface Changes : *No UI changes required.

Business logic Changes :

• Get all user list whose password will be about expired with his First Name, Last Name,Email ID,Last Date of Password Changed, Password expire within days.
• Email will send to all Active user (Admin,Partner,Broker) directly.
• Send Password expirartion mail to user one by one with all detaills.
• Need to integtate all business logic into to existing mid night service

Database Changes :

• Write a Script to retive all active and Non HSPL companies having "No automatic expiration" and "The number of days prior to password expiration" set to non Zero.
• Write a Script that return all formatted user data whose password is about to expires in grid with First Name, Last Name ,Email ID,Last Date of Password Changed, Password expire within days.

Testing (Test Scenario) :

1. Email should be with proper details.
2. Email should be send prior day of "The number of days prior to password expiration" before expires and afterwards till user not change password.
3. Every user should be received email one time in a day.
4. Logging proper Email log (failure and success).
5. Should not received once user change password.

Hi ,

We have done with code changes and unit testing and ready for review.

Affected Files:

• /trunk/WORKTERRAweb/Database Objects/OnlineEnrollment/04_Stored Procedures/dbo.OES_SP_GetSystemUserListForPasswordExpired.sql - Newly Added
• /trunk/WORKTERRAweb/App/Supporting Projects/ServiceScheduler/PasswordExpirationNotification.vb - Newly Added
• /trunk/WORKTERRAweb/App/Supporting Projects/ServiceScheduler/App.config
• /trunk/WORKTERRAweb/App/Supporting Projects/ServiceScheduler/ServiceScheduler.vb

Jaideep Vinchurkar Please have a review.

Thanks !

Hi Vishal Bajad,

Below are my review comments, Please do the changes accordingly,

Good to LB check in

Hi Ashwin Wankhede / Khandu Kshirsagar ,

We need to add batch file in scheduler to run this service daily at around 1.00 AM. Please do the needful or share process to add batch file once this patch gets deployed on LB.

Thanks !

CC : Jaideep Vinchurkar

Hi Vishal Bajad

Batch file is added in Scheduler(On LB). and job created which will run daily at 1 am.

Ashwin Wankhede,Jaideep Vinchurkar

Hello Vishal Bajad

Please refer Test Cases

WT-11069.xls

cc: Sachin Hingole Prasad Pise Rakesh Roy Hrishikesh Deshpande

Thank you !

Hi Vishal Bajad

I Will re verify this ticket once WT-11508 will get fixed on LB

cc: Sachin Hingole Prasad Pise Rakesh Roy Hrishikesh Deshpande

Thank you !

Hi Vishal Bajad

I have verified this change request on LB

Verified With Companies " For QA City Of Durham and For QA Matt

Verified with Multiple Company Admin Logins

Individual Mails to Change password is coming to Admin user

As Disscussed with Jaideep Vinchurkar Summary of Mails to Change password are not Coming

Hence, Reopening This ticket

cc: Sachin Hingole Prasad Pise Rakesh Roy Hrishikesh Deshpande

Thank you !

Hi Priya Handepatil ,

I am able to see password expiry notification summary mails, Please find attached snap regarding the same.

Snapshot :

Please confirm and let me know if you have any query.

Thanks
CC : Jaideep Vinchurkar Sachin HingolePrasad PiseRakesh RoyHrishikesh Deshpande

Hi Vishal Bajad

I have verified this issue

Summary of Mails to Change password are appearing

Hence, Marking it as on Hold because, All Tickets will move ahead together on stgae

cc: Sachin Hingole Prasad Pise Rakesh Roy Hrishikesh Deshpande

Thank You !