PERF_CLIENT_OPERATIONS

This table stores the data collected by the Client Operation monitor.

The table contains one record for each client operation. A client operation is an action performed by the user in the ALM user interface. For example:

  • clicking the Authenticate button in the Login window

  • selecting the Attachments tab in the Defects module

  • expanding a folder in the test plan tree

A client operation type is described by type, data, and context. The column prefix for the table is PCO. For example, PCO_OPERATION_ID.

COLUMN NAME

DESCRIPTION

OPERATION_ID

A unique GUID assigned to the operation.

CLIENT_MACHINE_NAME

The client host name in which the operation was performed.

LOGIN_SESSION_ID

The login session ID.

PROJECT_SESSION_ID

The project session ID.

PROJECT

The domain and project name, in the format <domain name>/<project name>.

USER_NAME

The user name.

OPERATION_TYPE

The type of the operation. For example:

  • Button Clicked

  • Tab Selected

  • Tree Node Expanded

OPERATION_DATA

The operation's data. For example:

  • The clicked button label, such as Login

  • The selected tab label, such as Attachments

OPERATION_CONTEXT

The path to the window in which the operation was performed. For example:

  • Module: Business Components .Net; View: EntityTypeViewControl; View: ComponentStepsViewControl; View: DesignStepsViewControl

  • Form: Component Step Details

CLIENT_START_TIME

The start time of the operation as a date time data type.

CLIENT_END_TIME

The end time of the operation as a date time data type.

CLIENT_START_TIME_MS

The start time of the operation as the number of milliseconds since 01/01/1970.

CLIENT_TOTAL_TIME

The total milliseconds that passed from the start of the operation until the end of the operation.