SYNCHRONIZATION_HISTORY table

This table stores the history information of all the synchronizations that occurred.

Column Name Description Data type
SYNC_ID* ID for this synchronization activity. Primary key. Numeric
REQUESTOR* Requestor of this request. Character (255)
REQ_TYPE This attribute specifies the type of request. DS indicates full data synchronization. IDS indicates Incremental Synchronization. Character (255)
REQ_NAME Name of request. For example, Data Synchronization. Character (255)
STATUS Status like Started, Failure, Success, or Warning1. Character (255)
TENANT Tenant DN for which synchronization is run. Character (255)
STATUS_DETAIL Detail string of the status. Character (255)
SCHEDULED_TIME Time for which this synchronization was scheduled. This attribute is deprecated. To get data synchronization schedule information, use the RESOURCES_SYNCHRONIZATIONS table. Numeric
SUBMITTED_TIME Time when this request was submitted. Numeric
STARTED_TIME* Time when this synchronization started. Primary key. Numeric
COMPLETED_TIME Time when this synchronization completed. Numeric
SERVER_NAME Name of ISIM Server that started the synchronization. Character (255)

* Indicates the column is required and not null.

1 Indicates the column or the value is added in release 5.0.

Parent topic: Reports tables