Summarized Process table (CC_PROCESS)
This table contains one row per summarized process.
| Element | Type | Description |
|---|---|---|
| BYTES_TRANSFERRED | bigint |
The current number of bytes transferred by the current step in an active/ queued process performing a file transfer. The default summarizer does not set this value for completed processes. |
| CORRELATION_ID | varchar |
The correlation ID associated with the process. It is not set by the default summarizer. |
| CURRENT_STEP_NAME | varchar |
The current step name for an active/ queued process. The default summarizer does not set this value for completed processes. |
| DURATION | bigint | The total number of milliseconds taken by the process to complete. |
| ENDED | datetime | The time at which the process finished. |
| LAST_MESSAGE_ID | varchar | The last known message ID associated with the process. |
| LAST_MESSAGE_TEXT | varchar | The last message text associated with the process. |
| NODE_TYPE_ID | bigint | A reference to the NODE_TYPE value in the table NODE_TYPE. |
| NUM_EVENTS | bigint | The number of events associated with the process. |
| NUM_TRANSFERS | bigint | The number of transfers associated with the process. |
| ORIG_NODE | varchar |
The name of the server from which the process originated. It will match the value for EVENTS.ORIG_NODE for events associated with the process. |
| PARENT_ID | bigint |
A reference to the PROCESS_ID of the parent process of this process. It is not set by the default summarizer. |
| PCT_COMPLETE | Integer |
The percent of an active/ queued process that is completed. The default summarizer does not set this value for completed processes. |
| PROC_ID | varchar | The processId of the process. It will match the value for EVENTS.PROC_ID for events associated with the process. |
| PROC_NAME | varchar |
The name of the process. It will match the value for EVENTS.PROC_NAME for events associated with the process. |
| PROC_STATUS | varchar |
The status of the process. It may be one of the following values:
|
| PROCESS_ID | bigint | A unique identifier assigned to the process by Control Center. |
| QUEUE_NAME | varchar |
The process queue name for active/ queued processes. The default summarizer does not set this value for completed processes. |
| REMOTE_NODE | varchar | Server(s) associated with the process. Note: The process did not originate from
this server.
|
| RETURN_CODE | varchar | The return code for the process |
| SERVER_ID | bigint |
A reference to the SERVER_ID value in CC_SERVER for the monitored server the data about the process came from. |
| STARTED | datetime | The full date and time at which the transfer started. |
| STARTED_DAY | datetime | The time, down to the date, the transfer started |
| STARTED_MONTH | datetime | The time, down to the month, the transfer started |
| STEP_NAMES | varchar | A comma separated list of step names associated with the process. |
| SUBMITTER | varchar | The name of the process submitter. It will match the value for EVENTS.SUBMITTER for events associated with the process. |
| TAG1 | varchar | Tag1 tag mapped value |
| TAG2 | varchar | Tag2 tag mapped value |
| TAG3 | varchar | Tag3 tag mapped value |
| TAG4 | varchar | Tag4 tag mapped value |
| TAG5 | varchar | Tag5 tag mapped value |
| TAG6 | varchar | Tag6 tag mapped value |
| TAG7 | varchar | Tag7 tag mapped value |
| TAG8 | varchar | Tag8 tag mapped value |
| TAG9 | varchar | Tag9 tag mapped value |
| TAG10 | varchar | Tag10 tag mapped value |