Skip to Content

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)

Selection Screen.png

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:

Report Ouput.png

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: Click Here

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: Click Here

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.

 

To report this post you need to login first.

8 Comments

You must be Logged on to comment or reply to a post.

  1. Hi,

    The report should be very useful, I’m just having abit of a problem.  I get this abap dump when executing…

    ________________________

    Error analysis

        An exception occurred that is explained in detail below.

        The exception, which is assigned to class ‘CX_OS_OBJECT_NOT_FOUND’, was not

         caught in

        procedure “ADD_RECIPIENT” “(METHOD)”, nor was it propagated by a RAISING

         clause.

        Since the caller of the procedure could not have anticipated that the

        exception would occur, the current program is terminated.

        The reason for the exception is:

        Could not find the referenced object with the OID

        “52EA3EBB829F1560E1008000AC11420B” (instance GUID) and

        “37A7F90DEE3E049BE10000009B38F87A” (class GUID)

    __________________________

    Can you help me on this, as i’m new in ABAP…

    Thanks,

    (0) 

Leave a Reply