Try OpenEdge Now
skip to main content
Core Business Services - Security and Auditing
Auditing : Querying and Reporting on Audit Data : Reporting on audit data with prefiltered and custom reports
 

Reporting 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 section.)
*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.
Figure 8. Detail orientation report output
The following figure shows a report in summary orientation.
Figure 9. Summary orientation report output
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 10. 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