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:
-
Select the System 1 parameter and choose ‘Edit RFC Destination’ from its context menu to display the RFC Destination dialog.
-
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.