Utility Tool – Program To Lock Inactive Users

Requirement: A program with functionality to identify and notify users who have not logged in the system for a certain time period. Program should send log-in reminder e-mail to users for two time stamps; for the third time stamp, it should lock user accounts and send e-mails notifying users of account expiration.

This program should generate a consolidated report having all the users notified by e-mail with their corresponding statuses.

This program should have a ‘Test Run’ Mode where user can execute and see the report with user account status without actually locking accounts or sending e-mails.

Solution Explanation: The program logic for this requirement is attached with this document. The current time stamps considered in the program for first e-mail reminder is 50 days and for second reminder it is 80 days. If the user has not logged in for 90 days or more (third time stamp) then user account will be locked and user will be notified via e-mail.

Steps of Execution

Execute the program ‘Z_REP_USER_LOCK’ (default date is current date)

Note: With ‘Test Run’ marked, no users are locked and emails are not sent either; this is for report generation and review purpose only.

Status Report: The output report will have consolidated list of all the users falling under criteria of inactive users with their account status:

E-mail Notification:

Below is the E-Mail structure for 50 and 80 days:

From: sysadminteam@company.com [mailto:sysadminteam@company.com]
Sent: Wednesday, July 17, 2013 2:09 PM
Subject: Important Information: User Account will be locked

Dear User,

This is to notify you that you have not logged into System XYZ Client 100 for last 80 Days.

Please use your Login Credentials to Log-in and avoid account locking.

Please write to us for further enquiry

Thanks & Regards,
System Admin Team.

This is a system generated mail. Please do not reply.

Below is the E-Mail structure for 90 days:

From: sysadminteam@company.com [mailto:sysadminteam@company.com]
Sent: Wednesday, July 17, 2013 2:09 PM
Subject: Important Information: User Account has expired

Dear User,

This is to notify you that you have not logged into System XYZ Client 100 for last 90 Days.

Hence your Account has expired.

Please write to us for further enquiry

Thanks & Regards,
System Admin Team.

This is a system generated mail. Please do not reply.

Below is the execution process of the program followed by status report and generated e-mail notification.