Audit
The Audit Log enables the Administrator to see what changes users have made in the OneVizion® System. This allows the ability to view a history of changes made to Tasks and WorkPlans. The Audit Log table is updated, whenever a change is made to the Task information. The Audit Log reflects Task updates made through the application pages and the Import function. Administrators have the ability to recover deleted Trackors®, view a History Log of recovered items, and export Audit Log data to a CSV or Excel file.
Audit Log Page
Administration
Users will need access to the Security Group: AUDIT_LOG
Users may 'Pin' features to their command bar by using the ellipsis menu.
Configuring the Application Grid
Use the view options and filter parameters to select the data elements to be displayed on the Audit Log page. Once configured, users may save the settings to local or global view options and filter.
The system administrator will probably configure some view options and filters during the implementation of the OneVizion system. Before beginning to configure a new Audit Log page, always check to see if a view option or filter already exists.
Using View Options
Select the specific data to display on the page by choosing and organizing the columns. For more overall information, please refer to the View Options documentation.
Using Filters
The Filter applet on the Audit Log page is unique. For more overall information, please refer to the Filters documentation.
On the Audit Log page, you should set a date range of no more than 31 days with help of Date/Time or Recovery Attempt filters.
WP_TASKS and WP_WORKPLAN are the table names that pertain specifically to Tasks and WorkPlans.
Filter Applet
Field Name | Field Description |
---|---|
Table Name | Contains the list of table names that have an audit log. |
Column Name | Enter the name of the column that was changed. For example, the XITOR_KEY in the XITOR table or the CONFIG_FIELD_ID in the case of CONFIG_VALUE updates. |
Action | Contains the available actions including Bulk File Download, Deletion, Insert, Object Access, Report Download, and Update. Either I (insert), U (update), or D (delete). |
PKey | The primary key of the updated record. This can be the XITOR_ID for Trackor updates, WP_WORKPLAN_ID for Workplan updates, etc. |
User | User name of the user who updated this record. |
Line Number | Used to filter on specific line numbers of multi-line fields. For more information on multi-line fields, please refer to the Fields documentation. |
From Number | Numeric value of the property before being updated. |
To Number | Numeric value of the property after being updated. |
From Char | Text value of the property before being updated. |
To Char | Text value of the property after being updated. |
From Date | Date value of the property before being updated. |
To Date | Date value of the property after being updated. |
Trackor Type | This is the Trackor Key of the record that was updated, if appropriate. |
Trackor Type | Selector that allows the user to filter on a specific Trackor Type. |
Date/Time | Allows the user to filter to a specific date range when the changes took place. |
Recovery Attempt | Allows the user to filter to a specific date range when data recovery took place. |
Show only recoverable Trackors | Shows only the Trackors that were deleted and can be recovered. |
Show only recovered Trackors | Shows only the Trackors that have been recovered. |
Recovering an Audit Log ID
Use the Recover feature to undo the deletion of specific Trackors. For example, if a user mistakenly deletes a Trackor, filter to that row on the Audit Log page, check the checkbox on the row displaying the deletion, and click on the icon.
A Recovering is in progress window will pop up with a running timer, and the Recovery Log applet will appear within that window once the recovery process is complete.
Recovery Log Applet
On the Trackor Browser page which contains the deleted and now recovered Trackor. It will be tagged as “New”.
Viewing the Recovery History
To view the Recover History for an item highlight it and click the icon.
Recovery History Applet
Accessing Recovery Messages
To access the Recovery Messages click the hyperlink in the Date/Time column.
Recovery Messages Window
Exporting the Audit Log and Export History
To export the data displayed on the application grid to a CSV file (so it can be used in another program such as Microsoft Excel) or directly to Excel click the Export/Export History Icon.