A.02 - Dormant users

This workflow accesses the USR02 table to retrieve user details for the specified SAP system. The TRDAT (Last Login Date) field is examined to identify users who have not logged in to the system for at least the number of days specified in the Days Since Last Logon parameter (this parameter is initially set to 30). The results are stored in the Dormant Users dataset, which has the following columns:

Column Description
BNAME User name.
TRDAT Last login date.
DAYDIFF The number of days since the user logged in to the system.
DORMANT This field is set to ‘true’ if the user has not logged in for at least the specified number of days, or if the user has never logged in at all. Otherwise it is set to ‘false’.

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 A.02 - Dormant users 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 to Audit 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’.

To specify the minimum number of days allowed since each user last logged in:

  1. Select the Days Since Last Logon parameter and view its details in the Property Editor.

  2. Enter a new numeric value for the parameter’s ‘String’ property.

To filter the USR02 table by specifying a ‘Valid to’ date:

  1. Select the Valid to Date (YYYYMMDD) parameter and choose ‘Edit Select List’ from its context menu to display the Select List Editor dialog.

  2. Modify the selection criteria to specify a ‘Valid to’ date, in the form YYYYMMDD. See the Select List Parameters help topic for details.

  3. Select the Read USR02 action and view its details in the Property Editor.

  4. Choose ‘Valid to Date (YYYYMMDD)’ from the drop down list next to the ‘Rows to Read’ action property.

Save the workflow using the ‘Save’ toolbar button.

Running the Workflow

To run the A.02 - Dormant users 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 Results_A02 dataset and choose ‘View Details’ from the context menu to display the result table.