The Logger Remark Audit report is a generic report for viewing changes to logger remark data, available in EQuIS Live.
To enable auditing on the DT_LOGGER_REMARK table, a database administrator would execute the following command (see Database Auditing):
exec equis.add_audit 'dbo','dt_logger_remark';
The Logger Remark Audit report can be run as a scheduled EQuIS Information Agent (EIA), at the desired frequency, to automatically view data as often as needed.
The report can also be run in EQuIS Professional or Enterprise (using the EZView widget) to view the data manually, without having to schedule an EIA. It has the following input parameters:
•Date Range – Select a start and end date for the data.
The XT_AUDIT table contains the audit information and the VW_AUDIT view includes the appropriate joins/functions to show meaningful text values. The following SQL statement (which can be executed using the EQuIS SQL Form or SQL Server Management Studio) can also be used to show the audit information.
SELECT * FROM vw_audit WHERE table_name = 'dt_logger_remark' ORDER BY audit_utc_date ASC;
To remove auditing, you can either delete or disable the triggers that were added by enabling auditing (see Database Auditing).
Copyright © 2021 EarthSoft, Inc • Modified: 02 Aug 2020