Try OpenEdge Now
skip to main content
Core Business Services - Security and Auditing
Overview : OpenEdge Core Business Services : Auditing service : Querying and reporting
Querying and reporting
Because the audit data is stored in standard OpenEdge database tables, you can easily query against the tables contents as long as you know the database schema. You can search by user ID, event ID, date, context, transaction, audit group, database connection, or authenticated client session.
You can also report on audit data using one of the built-in audit trail indexes, and using either a prefiltered report or a custom filtered report. The prefiltered reports are organized by category, such as audit policy, database schema, or user accounts, and allow you to specify a date range or audit event ID range, where to output the report (terminal, printer, XML file, or text file), and whether you want the contents to appear in a detailed or a summary format. You can also generate a custom report based on criteria you choose.
For a description of the audit table schema, see Audit Data Tables. For more information about querying and reporting, see Querying and Reporting on Audit Data.