S.12 - Users With Initial Password

This workflow accesses details for user accounts that have an initial password set by the Administrator on the specified SAP system. These details are obtained from the USR02 table, by extracting rows that match the following criteria:

  • The USTYP field has the value A (Only dialog users may change their passwords).

  • The LTIME field has the value 0 (The user has not yet logged on).

  • The OCOD1 field has the value 0 (The user has not yet supplied a new password).

The personnel number for each user is obtained from the USR21 table, and the name associated with each user account is obtained from the ADRP table.

The results are stored in the Users With Initial Passwords Table dataset, which has the following columns:

Column Description
BNAME User name.
USTYP User type.
CLASS User group in user master maintenance.
LOCNT Number of incorrect logon attempts since the last successful logon.
ANAME Creator of the user master record.
ERDAT Creation date of the user master record.
TRDAT Last logon date.
LTIME Last logon time.
PWDSTATE Password status (1 = initial password set by the Administrator).
PERSNUMBER User's personnel number.
NAME_FIRST User’s first name.
NAME_LAST User’s last name.
NAME_MIDDLE User’s middle name.

Creating RFC Destinations

Before you begin, you will need to create an RFC Destination for the SAP system you wish to analyze.

Preparing the Workflow

To prepare the S.12 - Users With Initial Password workflow, drag its workflow template from the Templates folder into your own workspace, and modify the workflow as follows:

To specify the system to analyze:

  1. Select the System 1 parameter and choose ‘Edit RFC Destination’ from its context menu to display the RFC Destination dialog.

  2. Select the RFC Destination for the system to analyze, then click ‘Save’.

Save the workflow using the ‘Save’ toolbar button.

Running the Workflow

To run the S.12 - Users With Initial Password workflow, click the ‘Run’ toolbar button, choose ‘Run Now’ from the diagram’s context menu, or press F5. The currently running workflow action is marked with an animated display. When the workflow execution has completed, select the Users with Initial Passwords dataset and choose ‘View Details’ from the context menu to display the result table.