About Configuring a Cube for Usage Metrics Tracking

You can track the usage of users in your system. Usage metrics are stored in the MI_USAGE_METRICS system table. When a user logs in to GE Digital APM, actions for which usage metrics tracking has been enabled will be stored for that session and saved in batch to the MI_USAGE_METRICS table when the user logs out of GE Digital APM.

The following actions can be recorded in the MI_USAGE_METRICS table:

Login.
Logout.
Session time.
URL visit.

The following columns of data are stored in the MI_USAGE_METRICS table:

USME_KEY: The key value assigned to the action to identify it in the usage metrics table.
USME_EVENT_TYPE_DVD: The type of event (login, logout, session time, or URL visit).
SEUS_KEY: The key value associated with the Security User who performed the action.
USME_EVENT_DT: The date and time the action was performed.
USME_EVENT_DESC_TX: A description of the action. For URL visits, this column stores the URL.
USME_MEASR_NBR: For session time entries, a numeric value that represents the session time.

Note: Usage metrics are recorded only for activities performed via GE Digital APM. Usage metrics are not recorded for activities performed in the GE Digital APM Administrative Applications.

To view the usage metrics that have been tracked for your system, you must create a cube based upon the MI_USAGE_METRICS table. After you create the cube, you must create a join between the MI_USAGE_METRICS table and the MIV_MI_IS_A_USER table. You must also join the MIV_MI_IS_A_USER table to the MIV_MI_HUMAN_RESOURCE table.

Note: Before you can use the cube in the Metrics and Scorecards module, you must enable usage metrics tracking via the Monitoring page in Configuration Manager.

GE Digital APM Installation and Upgrade