Unsupported content


This version of the documentation is no longer supported. However, the documentation is available for your convenience. You will not be able to leave comments.

Managing process metrics

Process metrics data is generated by schedules and through the execution of workflow processes. You can collect this data from processes running on a grid by configuring the connection to the database appropriately.

For successful collection of process metrics data, the grid must have a configured connection to the database, and at least one peer on that grid must be designated as a synchronization point (sync point). Peers that have been designated as sync points upload the process metrics data to the database.

The first time that process metrics data is uploaded to the database, the system verifies that tables exist to contain the data. If the tables do not exist, the system creates them automatically.


The database user ID used in metric configuration must have authority to create tables, indexes, and sequences, and to populate data into the created tables on an ongoing basis.

The process metrics tables might become large over time as workflows execute. (For schema information for the process metrics tables, see Process metrics table information). You must resize these tables appropriately for your environment and execution load, and decide if and when to archive and purge the data.


BMC recommends that you contact your company's reporting, data warehouse, or database administrator for assistance with exporting and purging metric table data.

BMC Atrium Orchestrator Grid Manager does not display any collected process metrics. To view process metrics, you must use the tools available for the database program that you are using to collect the data. However, if you install the graphing components on the configuration distribution peer (CDP), you can generate process metrics reports.

This topic includes the following sections:

Process metrics table information

The process metrics data is contained in the metric and metric_detail tables within the database. There is no master table. The tables are created after process metrics data collection is configured. The metric_detail table has a foreign key relationship to the metric table.

The following tables offer details about the fields in each process metrics table.

Fields in the metric table




Unique record identifier of the metric and primary key


Name of the grid on which the process occurred for which the metric is recorded


Name of the peer where the process occurred for which the metric is recorded


Start time of the process or action whose information is recorded as a metric


Type of metric being recorded


Description of the process or action whose information is recorded as a metric


Length of time the process or action took to finish


Status of the process or action


Unique identifier of the process or action


User name of the person or system who invoked the process or the action

Fields in the metric_detail table


Description and sample values


Unique record identifier and primary key


Metric for which the VALUE is captured


Metric value that corresponds to the NAME attribute or item


Cross-referenced value for the ID in the metric table


Sequence number of the metric detail records of a metric record (internal use only)

Video demonstration

The following BMC Communities video series demonstrates how to collect process metrics data generated through the execution of BAO workflow processes. 

Part one (5:42) shows how to set up an external database, configure the process metrics database in Grid Manager, and designate a peer as a sync point.

The video mentions the Value Dashboard component, which is not supported in 7.7.x releases (it is available in 7.8 and later), however, you can use the graphing server to generate process metrics reports.


Part two (8:11) demonstrates how to restart the peer service, so that it reads the database driver file and creates the relevant metrics tables in the external database and how to verify that the tables are in the database. It shows how to set up a workflow to capture process metrics, export the export the process, activate it on the grid, set up appropriate permissions for the workflow, set up a process schedule that runs the workflow, turn on metrics collection, and verify that the metrics were collected.


Was this page helpful? Yes No Submitting... Thank you