Read DUA Data Actions
Read DUA Data actions retrieve the daily usage audit (DUA) data collected in the specified RFC Destination’s DUA tab. The retrieved DUA data is stored in a number of Table datasets, along with a summary of the data retrieved.
| Action Property | Description |
|---|---|
| Application Archive | A Table dataset which stores application statistics retrieved from the RFC Destination’s DUA tab. Non-printable characters in the retrieved data are replaced with # characters. |
| Application Statistics | A Table dataset which stores a summary of the Application Archive dataset, grouped by object type, object name and account. Non-printable characters in the retrieved data are replaced with # characters. |
| Info | A Table dataset which stores a summary of the data retrieved. |
| RFC Destination | An RFC Destination parameter or dataset whose DUA tab has been used to extract DUA data. |
| Users Archive | A Table dataset which stores users statistics retrieved from the RFC Destination’s DUA tab. Non-printable characters in the retrieved data are replaced with # characters. |
| Users Statistics | A Table dataset which stores a summary of the Users Archive dataset, grouped by object type, object name and account. Non-printable characters in the retrieved data are replaced with # characters. |
The Application Archive dataset stores the following details:
| Column | Description |
|---|---|
| TYPE | The type of a used object. |
| NAME | The name of the used object. |
| ACCOUNT | This column is set to ‘cumul.’ for SAP kernel releases earlier than 700, and to <blank> for SAP kernel releases 700 and above. |
| COUNT | The usage count for this usage of the object. |
| DATE | The usage date for this usage of the object, in the format YYYYMMDD. |
The Application Statistics dataset provides a summary of the Application Archive dataset, grouping the entries by object type, object name and account, and summing the COUNT values for each object. The Application Statistics dataset stores the following details:
| Column | Description |
|---|---|
| TYPE | The type of a used object. |
| NAME | The name of the used object. |
| ACCOUNT | This column is set to ‘cumul.’ for SAP kernel releases earlier than 700, and to <blank> for SAP kernel releases 700 and above. |
| COUNT | The total usage count for the object, obtained from the retrieved performance history data. |
The Info dataset stores the following details:
| Column | Description |
|---|---|
|
Attr |
The name of an attribute. |
|
Value |
The value of the attribute. |
|
Count |
For COUNT attributes, this column stores the number of rows in the specified table. |
The Attr column may have the following values:
| Attr | Description |
|---|---|
|
SCHEDULE_ON |
This attribute is included if a schedule has been enabled for the retrieval of performance history data. |
|
SCHEDULE_DAY |
This attribute refers to the day for which the retrieval of performance history data is scheduled. |
|
SCHEDULE_RUNTIME |
This attribute refers to the time (in milliseconds) taken for the scheduled run to complete. |
|
SCHEDULE_MONTHS |
This attribute refers to the number of months of performance history data retrieved by the scheduled run. |
|
COUNT |
This attribute refers to the number of rows in the Table dataset specified in the Value column. |
|
LAST_TIME_RUN |
This attribute refers to the date and time when performance history data was last retrieved for the specified RFC Destination. |
|
START_DATE |
This attribute refers to the start date used for the retrieval of performance history data. |
|
MONTHS |
This attribute refers to the number of months of performance history data retrieved. |
|
STATUS |
This attribute refers to the status of the retrieval operation. |
The Value column may have the following values:
| Value | Description |
|---|---|
|
DuaAppRaw |
Refers to the raw application statistics retrieved from SAP. |
|
DuaAppArch |
Refers to the Application Archive dataset. |
|
DuaAppSum |
Refers to the Application Statistics dataset. |
|
DuaUserRaw |
Refers to the raw users statistics retrieved from SAP. |
|
DuaUserArch |
Refers to the Users Archive dataset. |
|
DuaUserSum |
Refers to the Users Statistics dataset. |
|
true |
The value of the SCHEDULE_ON attribute. |
|
<Date/Time> |
The value for the LAST_TIME_RUN attribute. |
|
<Date> (YYYYMMDD) |
The value for the START_DATE attribute. |
|
<Number> |
The value for the SCHEDULE_RUNTIME, SCHEDULE_MONTHS and MONTHS attributes. |
|
SUCCESS/FAILED |
The value of the STATUS attribute. |
The Users Archive dataset stores the following details.
| Column | Description |
|---|---|
| TYPE | The type of a used object. |
| NAME | The name of the used object. |
| ACCOUNT | The SAP account that used the object. |
| PERIOD | The day when the object was used, specified in the format YYYYMMDD. |
| COUNT | The usage count for this usage of the object. |
| DATE | The usage date for this usage of the object, in the format YYYYMMDD. |
The Users Statistics dataset provides a summary of the Users Archive dataset, grouping the entries by object type, object name and account, and summing the COUNT values for each object. The Users Statistics dataset stores the following details.
| Column | Description |
|---|---|
| TYPE | The type of a used object. |
| NAME | The name of the used object. |
| ACCOUNT | The SAP account that used the object. |
| PERIOD | The day when the object was used, specified in the format YYYYMMDD. |
| COUNT | The total usage account for the object. |
In the Users Archive and Users Statistics datasets, the COUNT column is always 0 when data is retrieved from SAP kernel releases earlier than 700.
Example:
To examine the details for a Read DUA action, double-click the action node, or select ‘View Details’ from the node’s context menu. The Details screen displays the number of rows written to the Application Archive, Application Statistics, Users Archive and Users Statistics datasets, and the time taken for the action to complete.