Report on audit data with prefiltered and custom reports

As audit data accumulates in the auditing tables, you can generate audit reports about the data based on criteria you specify. There are two basic types of reports:

• Prefiltered reports—Default reports organized by category. You can specify the date range you are interested in capturing in each report. (A list of the prefiltered reports appears at the end of this topic.)
• Custom filtered reports—Reports whose filter criteria, including date range, you establish.

To run these reports, you must have imported the preconfigured OpenEdge policies. For more information, see the Audit Policy Maintenance Help.

You can run the reports on all supported platforms. From Data Administration or the Data Dictionary, you can choose which report to run, select a specific date range, decide what kind of output you want (terminal, printer, XML file, or text file), and choose how you want the report contents to display (in detail or summary format). You can assign each report a name, and you can decide if you want to append a new report to an existing one. You can also determine whether the reports page length is fixed or continuous.

The following figure shows a report in detail orientation.

The following figure shows a report in summary orientation.

To choose the specific report you want to run, choose Database > Reports > Auditing Reports; then either select from one of the prefiltered report types listed or choose to generate your own custom audit data filter report. For the specific steps you follow, see the Data Administration Help.

The following table lists each of the prefiltered reports and describes the information the report contains.

Table 1. Prefiltered audit data reports

Report name	Description	Events
Track Audit Policy Changes	Reports on audit policy changes	Audit Policy Maintenance Events: record created, updated, or deleted Audit Policy Commit Events: audit policy run-time update/ commit changes Audit Policy Dump or Load Events: dump and load of audit policies
Track Database Schema Changes	Reports on all possible schema modification actions	Table created, updated, or deleted Table trigger created, updated, or deleted Table field created, updated, or deleted Table field trigger created, updated, or deleted Table index created, updated, or deleted Table index field created, updated, or deleted Sequence created, updated, or deleted Database property created or updated
Track Audit Data Administration (Dump/Load)	Reports on all archiving and loading of audit data	Audit archive or audit data load
Track Application Data Administration (Dump/Load)	Reports on archiving and loading of audit data	Database text archive or load
Track User Account Changes	Reports on user account activity	User account created, updated, or deleted
Track Security Permission Changes	Reports on privilege definition and privilege assignment activity	Privilege definition created, updated, or deleted Privilege assignment created, updated, or deleted
Track SQL Permissions Changes	Reports on all possible SQL privilege modifications	SQL database administrator created, updated, or deleted SQL table privilege created, updated, or deleted SQL column privilege created, updated, or deleted SQL sequence privilege created, updated, or deleted
Track Authentication System Changes	Reports on authentication system maintenance and authentication system domain maintenance activity	Authentication System Maintenance Events: authentication system created, updated, or deleted Authentication System Domain Maintenance Events: authentication domain created, updated, or deleted
Client Session Authentication Report	Reports on all application access through authentication domains	Each time an OpenEdge application uses an authentication system to authenticate a user
Database Administration Reports (Utilities)	Reports on activities performed through command-line database administration utilities	Database started, stopped, backed up, restored, or copied Database binary dump or binary load Database table moved Database index moved, index checked, index rebuilt, or index fixed Database area truncated Database SQL dumped or loaded
Database Access Report (Login/Logout/etc.)	Reports on all login- and logout-type activities on an OpenEdge database	Database user identity set or failed User login success, user logout, or user login failed SQL user login success, logout, or user login failed Database connect or disconnect SQL database connect or disconnect