Try OpenEdge Now
skip to main content
Core Business Services - Security and Auditing
Auditing : Querying and Reporting on Audit Data : Generating a custom filtered report

Generating a custom filtered report

You can generate a report in which you filter the recorded data by criteria you select. For example, you can generate a report based on an audit data range, an audit event ID range, event-context matching, or by user ID or transaction ID. You can output the contents to the screen in a tabular format or dump the output to XML or text format.
If you choose to generate a custom report and you select no filter criteria, you generate a report of all auditing activity. In this case, a warning appears before the report is created to remind you that generating a report based on all the auditing activity can take a long time and create a very large file. You can choose to generate the full report, or you can choose to go back and supply filter criteria.
The following figure shows a sample custom audit data filter report (in a Windows platform) in which Terminal was chosen as the output and Detail was chosen as the orientation.
Figure 10. Sample custom audit data filter report
By selecting a column heading, you can view the report sorted in different orders (by date or time, for example). On UNIX, you can also sort the report by choosing the order: by Event Date/Time, Event Id, User Id, or Transaction Id.
You can view details about a particular record by selecting the record. The record details appear as shown in the following figure:
Figure 11. Custom audit data filter report detail
You can review the details about each record and sort through the records in the order you want.