Monitor 10.15 | Service Monitoring in Integration Server | Data Management | Viewing Archived Data Details
 
Viewing Archived Data Details
On the Data management page, you can view a summary of the current contents of the IS Core Audit Log database, and details about archive operations that were performed in the past.
You can determine if it is safe to archive or delete audit data by checking the Archive summary table, which displays a summary of the data that is currently available in the IS Core Audit Log database. You can use this information to determine the amount of data in the audit log tables, and decide how long to retain data. If you have a high count of table rows, kept over a long period of time, and you try to delete it at once, you might run into issues. To avoid these issues, always choose the largest retention period possible for the archive run.
The following table describes the fields of the Archive summary table.
Column Name
Description
Component
Component type (service, document, or server data).
Table name
Name of the database table that holds the data.
Count rows
Number of rows in the table.
Earliest
Date and time of the earliest record in the table.
Latest
Date and time of the latest record in the table.
In the Archive history table, you can view a record of the past archive operations.
Note:
The Archive history table does not display information about the delete operations that were completed in the past.
The following table describes the fields of the Archive history table.
Column Name
Description
Operation
Type of event that occurred.
Procedure name
Name of the stored procedure that was invoked by the archive process.
Status
Code that shows whether the archive operation was a service archive or a document archive, as follows:
*0 - document archive
*1 - service archive
Event text
Message that the database returns after the stored procedure completes.
Insert date/time
Date and time when the data was inserted into the Archive database component.
Update date/time
Date and time when the data was updated in the Archive database component.
Log ID
Unique counter for each record in the operation_log table in the Archive database component.