Used Objects App

The Used Objects App identifies objects that have been used according to the available performance history data. The App reports on standard and custom objects, users, application areas and SAP license type assignments. The results are presented in a Dashboard report and an associated Excel report.

A user with LiveCompare Editor privileges must prepare this App by making sure that performance history data is available for the ‘Performance History System’ RFC Destination. See the ‘Prerequisites’ section below for details.

DevOps Categories

Operations.

Prerequisites

Before running the Used Objects App for the first time, you will need to make sure that performance history data is available on the RFC Destination selected for the ‘Performance History System’ system. Select the RFC Destination in the LiveCompare hierarchy and click the PHD tab. Select the source for performance history data, and if necessary the number of months of data to retrieve, then click ‘Update Data’. The performance history data may also be retrieved using a schedule. See the Retrieving Performance History Data help topic for details.

If required, the Business Critical Objects External Data Source should be populated with a set of business critical objects that are always included in the results. The External Data source is populated from a .CSV file with TYPE and NAME columns. Use the External Data Source’s ‘Replace Data File’ option in the LiveCompare Studio to upload your own .CSV file.

Running the App

To run the Used Objects App, select the App from the Apps screen and create an App variant. Set the ‘Analysis System’ field to the RFC Destination for the system to be analyzed, and the ‘Performance History System’ field to the RFC Destination for the system from which performance history data has been obtained. In the ‘Performance History Range’ list box, select the range of performance history data to be used in the analysis.

If required, edit the ‘USR02 Filter’ table to specify a filter for user records read from the USR02 table. The default filter retrieves dialog users with unlocked accounts, and dialog users with accounts that have been locked due to unsuccessful logins.

Click ‘Run’. When the variant has completed, its results may be accessed from the App Cockpit screen.

App Results

The Used Objects App generates a Dashboard report which includes the following charts:

  • The Used Objects by Type column chart summarizes the used objects by object type.
  • The Standard vs. Custom pie chart provides a summary of the used and standard custom objects.
  • The Top Used Applications column chart column groups the used standard and custom objects by Application Area. The top 10 Application Areas are listed.
  • The Accounts by License Type pie chart summarizes the users of used objects by their license type.
  • The Account Usage by License Type column provides a summary of account usage by license type.
    • NO_USAGE indicates the number of accounts for each license type whose object usage count is NULL
    • SLIGHT_USAGE indicates the number of accounts for each license type whose object usage count is less than 6.
    • BROAD_USAGE indicates the number of accounts for each license type whose object usage count is greater than 5.
  • The Performance History System panel displays the name of the SAP performance history system.
  • The Performance History panel displays the number of rows of performance history data retrieved, and the date range for which performance history data is available.
  • The Business Critical Objects panel lists the number of business critical objects specified in the ‘Business Critical Objects’ External Data Source.
  • The Used Objects to Ignore panel lists the number of ignored objects filtered by the UsedObjectsToIgnore External Data Source.

The Dashboard report also includes links to the following reports:

Used Objects Details

This Excel report includes the following spreadsheets:

Dashboard

This spreadsheet includes the following charts:

  • The Used Objects by Type column chart summarizes the used objects by object type.
  • The Standard vs. Custom pie chart provides a summary of the used and standard custom objects.
  • The Top Used Applications column chart column groups the used standard and custom objects by Application Area. The top 10 Application Areas are listed.
  • The Accounts by License Type pie chart summarizes the users of used objects by their license type.
  • The Account Usage by License Type column provides a summary of account usage by license type.
    • NO_USAGE indicates the number of accounts for each license type whose object usage count is NULL
    • SLIGHT_USAGE indicates the number of accounts for each license type whose object usage count is less than 6.
    • BROAD_USAGE indicates the number of accounts for each license type whose object usage count is greater than 5.
  • The Performance History System panel displays the name of the SAP performance history system.
  • The Performance History panel displays the number of rows of performance history data retrieved, and the date range for which performance history data is available.
  • The Business Critical Objects panel lists the number of business critical objects specified in the ‘Business Critical Objects’ External Data Source.
  • The Used Objects to Ignore panel lists the number of ignored objects filtered by the UsedObjectsToIgnore External Data Source.

Help

This spreadsheet provides help for each of the spreadsheet reports.

UsedObjects

This spreadsheet includes details of the used objects according to the available performance history data, excluding any objects matched in the UsedObjectsToIgnore External Data Source. The spreadsheet includes the following columns:

Column Description
APP_AREA The used object’s Application Area.
TYPE The type of a used object.
NAME The name of the used object.
DESCRIPTION The description for the used object.
TOTAL_USAGE The total usage count for the object according to the available performance history data.
USERS The number of accounts that used the object.
CUSTOM This column is set to ‘Yes’ for custom objects.
BUSINESS_CRITICAL This column is set to ‘Yes’ for business critical objects.
DEVCLASS The used object’s Development Class.
Category This column is set to ‘Standard’ for standard objects, or to ‘Custom’ for custom objects.

UserAttrs

This spreadsheet includes details for each of the accounts in the users statistics obtained from the performance history data. The spreadsheet includes the following columns:

Column Description
ACCOUNT User’s account name.
NAME_FIRST User’s first name.
NAME_LAST User’s last name.
USED_OBJECTS The number of objects used by this account according to the available performance history data. Click a link in this column to display the objects in the UserStats spreadsheet.
LICENSE The SAP license associated with this account.
USTYP The account’s User Type, obtained from the USR02 table. Possible values are: ‘A’ (Dialog), ‘B’ (System), ‘C’ (Communications Data), ‘L’ (Reference), ‘S’ (Service).
CLASS The account’s User Group, obtained from the USR02 table.
UFLAG The account’s Lock Status, obtained from the USR02 table. Possible values are: ‘0’ (Not Locked), ‘32’ (Locked Globally by Admin), ‘64’ (Locked Locally by Admin), ‘128’ (Locked due to Incorrect Logons).
GLGTB The account’s Valid To date, obtained from the USR02 table.
ERDAT The account’s creation date, obtained from the USR02 table.
TRDAT The account’s last logon date, obtained from the USR02 table.

UserStats

This spreadsheet lists the users statistics obtained from the performance history data, excluding any objects matched in the UsedObjectsToIgnore External Data Source.

ObjectsToIgnore

This spreadsheet lists the used objects to ignore. These objects are filtered from the UsedObjects report by the UsedObjectsToIgnore External Data Source.

Analysis Input Data

This Excel report contains a copy of the input parameters used to produce the App’s Dashboard report. The value of each input parameter is stored in a separate worksheet, which is named after the parameter whose value it contains.

Standard Apps