Summarized File Transfer (CC_FILE_TRANSFER)
This table contains one row per summarized file transfer.
| Element | Type | Description |
|---|---|---|
| CORRELATION_ID | varchar |
The correlation ID associated with the transfer. It is not set by the default summarizer. |
| DURATION | bigint | The total number of milliseconds taken by the transfer to complete. |
| ENDED | datetime | The time at which the transfer finished. |
|
ENDED_DAY |
datetime | The time, down to the date, the transfer ended |
|
ENDED_HOUR |
datetime | The time, down to the hour, the transfer ended |
|
ENDED_MONTH |
datetime | The time, down to the month, the transfer ended |
| FILE_SIZE | bigint | The size of the file transferred. |
| FILE_TRANSFER_ID | bigint | A unique identifier assigned to the transfer by Control Center. |
| FILE_TYPE | varchar |
The filetype. It is derived from the name of the file transferred by the default summarizer by taking the text after the last period (“.”) of its name. |
| LOCAL_FILE_NAME | varchar |
The name of the file transferred. Depending on the originating server of the transfer, and the direction of transfer, this may either be the transfer source or destination file name. |
| LOCAL_ORG | varchar |
The organization of the local file for the transfer. It is not set by the default summarizer. |
| LOCAL_PATH | varchar |
The file path of the local file for the transfer. It is not set by the default summarizer. |
| NODE_TYPE_ID | bigint | A reference to the NODE_TYPE value in the table NODE_TYPE. |
| PROCESS_ID | bigint | A reference to the PROCESS_ID value in the table CC_PROCESS for the process this transfer was a part of. |
| PROTOCOL | varchar | The protocol used for the transfer. It is not set by the default summarizer. |
| REMOTE_FILE_NAME |
The name of the file transferred. Depending on the originating server of the transfer, and the direction of transfer, this may either be the source or destination file name. |
|
| REMOTE_ORG | varchar |
The organization of the remote file for the transfer. It is not set by the default summarizer. |
| REMOTE_PATH | varchar |
The file path of the remote file for the transfer. It is not set by the default summarizer. |
| REMOTE_SERVER_ID | bigint |
A reference to the SERVER_ID in CC_SERVER of the remote server for the transfer. It is not set by the default summarizer. |
| RETURN_CODE | varchar | Return code value for transfer |
| SERVER_ID | bigint |
A reference to the SERVER_ID value in CC_SERVER for the monitored server, the data about the transfer 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_HOUR | datetime | The time, down to the hour, the transfer started |
| STARTED_MONTH | datetime | The time, down to the month, the transfer started |
| STEP_NAME | varchar | The process step name for the transfer |
| 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 |
| TRANSFER_STATUS | varchar |
The status of the transfer. It may be one of the following values:
|
| XFER_DIRECTION | varchar |
The direction of a transfer from the monitored server’s point of view. It may be either of these:
|