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: ![*](chapterTOC_bullet.png) 0 - document archive ![*](chapterTOC_bullet.png) 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. |