Survey Performance History
This workflow provides a summary of the performance history data available on the specified SAP system. It helps you to determine values for the Start Date and End Date parameters in workflows that retrieve performance history data.
The workflow calls the SAPWL_WORKLOAD_GET_DIRECTORY RFC to extract the range of months for which performance history data is available. These results are stored in the Months With Data Table dataset, which has the following columns:
| Column | Description |
|---|---|
| STARTDATE | The first day of a month for which performance history data is available. |
| PERIODTYPE | This field is set to M. |
| HOSTID | This field is set to TOTAL. |
| FIRSTRECTI | The time of the first performance history record for this month. |
| FIRSTRECDY | The date of the first performance history record for this month. |
| LASTRECTI | The time of the last performance history record for this month. |
| LASTRECDY | The date of the last performance history record for this month. |
The workflow extracts the earliest value from the STARTDATE column, and uses this as the Start Date parameter for the Get Performance History Data action. The application statistics retrieved are stored in the Application Statistics dataset, which has the following columns:
| Column | Description |
|---|---|
| TYPE | The type of each used object. |
| NAME | The name of each used object. |
| ACCOUNT | The SAP account that used the object. |
| COUNT | The usage count for the object. |
Create RFC Destinations
Before you begin, you will need to create an RFC Destination for the SAP system you wish to analyze.
Prepare the workflow
To prepare the Survey Performance History workflow, drag its workflow template from the Templates > Tools folder into your own workspace, then modify the workflow as follows:
To specify the system to analyze:
-
Select the System 3 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.
Click 
to save the workflow.
Run the workflow
To run the Survey Performance History workflow, click the 
toolbar button, choose Run Now from the diagram’s context menu, or select F5. The currently running workflow action is marked with an animated display. When the workflow execution has completed, select each of the Months With Data and Application Statistics datasets and choose View Details from the context menu to display each of the result tables.