Try OpenEdge Now
skip to main content
Basic Database Tools
Database Menu Reference : Reports option : Auditing Reports option
 

Auditing Reports option

If you are connected to an audit-enabled database, you can access the Auditing Reports submenu by choosing Reports > Auditing Reports. For a description of each auditing report, see the following table. For a complete description of OpenEdge auditing events and event IDs, see OpenEdge Getting Started: Core Business Services - Security and Auditing.
Table 5. Auditing reports
Report
Description
Track Audit Policy Changes
Details audit policy maintenance, commit, and dump/load events—events with the following IDs are tracked by this report: 300, 301, 10010, 10303, and 10304
Track Database Schema Changes
Details schema modification actions such as creating tables and modifying sequence definitions—events with IDs between 5000 and 5041 are tracked by this report
Track Audit Data Administration (Dump/Load)
Details the dump, load, and archival of audit data. Events with the following IDs are tracked by this report: 10300, 10301, and 10302
Track Application Data Administration (Dump/Load)
Details the dump and load of application data—events with the following IDs are tracked by this report: 10213 and 10214
Track User Account Changes
Details create, update, and delete events, as well as the user who made the changes—events with the following IDs are tracked by this report: 100, 101, and 102
Track Security Permissions Changes
Details role maintenance and permissions maintenance auditing events—events with IDs between 510 and 517 are tracked by this report
Track SQL Permissions Changes
Details create, update, and delete events, as well as the user who made the change—events with IDs of 210 through 212 and 400 through 422 are tracked by this report
Track Authentication System Changes
Details authentication system maintenance events and authentication system domain maintenance events—events with IDs between 500 and 507 are tracked by this report
Client Session Authentication Report
Details application access through authentication domains
Database Administration Report (Utilities)
Details activities performed by command-line database administration utilities—events with IDs between 10100 and 10212 are tracked by this report
Database Access Report (Login/Logout/etc)
Details login and logout events performed on an OpenEdge database—events with IDs between 10500 and 10611 are tracked by this report
Track Encryption Policy Changes
Reports any events related to encryption policy maintenance—events with IDs 11400-11402, 11500-11502, and 11600-11602 are tracked by this report
Track Key-store Changes
Reports any events related to the key store and autostart—events with IDs 11100-11114 and 11200-11207 are tracked by this report
Database Encryption Administration (Utilities)
Reports events such as enabling and disabling encryption for your database, and scan and update utilities—events with IDs 11000, 11001, 11300, and 11301 are tracked by this report
Custom Audit Data Filter Report
Allows you to limit the amount of custom audit data on which the Data Dictionary reports
* Track Audit Policy Changes report
* Track Database Schema Changes report
* Track Audit Data Administration (Dump/Load) report
* Track Application Data Administration (Dump/Load) report
* Track User Account Changes report
* Track Security Permissions Changes report
* Track SQL Permissions Changes report
* Track Authentication System Changes report
* Client Session Authentication report
* Database Administration Utilities report
* Database Access report (Login/Logout/etc)
* Track Encryption Policy Changes report
* Track Key-store Changes report
* Database Encryption Administration (Utilities) report
* Custom Audit Data Filter report
* OpenEdge Auditing Report Options dialog box