Webhook Audit Report

Report Name: Webhook Audit Report

File Name: EarthSoft.Reports.Library.d11175.dll

Dependencies: N/A

Software: EQuIS Professional and EQuIS Enterprise

Language: English

Output Type: Report Grid1 or JSON (when run as a Webhook)

Description: This report displays audit information from the XT_AUDIT table based on the selected parameters such as table, column, event, and start and end dates. When running as a Webhook, the report will use the current date/time and last run date/time instead of the start/end dates.

Installation Instructions: Download the Webhook Audit report, unblock the *.zip file and extract the EarthSoft.Reports.Library.d11175.dll file to the EQuIS Professional installation folder. For default installations this directory is C:\Program Files\EarthSoft\EQuIS or (for per-user installation) %localappdata%\Programs\EarthSoft\EQuIS\. The report will be available for selection once Professional has been relaunched. For use in EQuIS Enterprise and/or as an EIA, the report must be published to the database via EQuIS Professional.

Overview: Non-administrator users need a minimum of 'Viewer' permission on File, Facility and Group object types, and should have no 'Deny' permission for any object. Non-administrators running this report will get a limited set of results as they will not see which user made the changes, nor any audit results for XT_, ST_, and SDT_ tables.

Tables: XT_AUDIT, XT_COLUMN, XT_TABLE, ST_USER

Report Parameters

Start Date	The lower boundary of dates and times, exclusive (>). The Report Parameter Editors in Professional and Enterprise only allow for date selection, and time values will always translate to 00:00:00.
End Date	The upper boundary of the dates and times, inclusive (<=). The Report Parameter Editors in Professional and Enterprise only allow for date selection, and time values will always translate to 00:00:00.
Table/Column/Event	The table, column and event (Insert, Delete, Update) to report on. Multiple options can be selected.
User (optional)	The user(s) whose events to report. Multiple options can be selected.

Report Output

XT_AUDIT.*

XT_COLUMN.COLUMN_NAME

XT_TABLE.TABLE_NAME

ST_USER.USER_NAME

ST_USER.EMAIL_ADDRESS

1The Report Grid provides additional export options to Excel, Google Earth, Outlook, Shapefile, PDF, Text, Access, XML, or a printer.