S.02 - Users by Role
This workflow accesses the AGR_USERS table to extract user accounts with specified SAP roles. 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 by Role Table dataset, which has the following columns:
| Column | Description |
|---|---|
| AGR_NAME | Role name. |
| UNAME | SAP user account with this role. |
| PERSNUMBER | User’s personnel number. |
| NAME_FIRST | User’s first name. |
| NAME_MIDDLE | User’s middle name. |
| NAME_LAST | User’s last 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.02 - Users by Role 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’.
To specify the SAP roles on which to report:
-
Select the Roles parameter and choose ‘Edit Select List’ from its context menu to display the String List Editor dialog.
-
Modify the existing roles and add new rows to the table as appropriate, then click ‘Save’.
Save the workflow using the ‘Save’ toolbar button.
Running the Workflow
To run the S.02 - Users by Role 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 by Role dataset and choose ‘View Details’ from the context menu to display the result table.