Try OpenEdge Now
skip to main content
Programming Interfaces
Data Management : Auditing : Developing auditing tools : Custom audit archiving tools : Accessing the audit data and supporting tables
 
Accessing the audit data and supporting tables
You can write your own tools to archive audit data in other ways than are supported by the OpenEdge Audit Archiving utility. For example, where the OpenEdge Audit Archiving utility dumps audit data to .adb files, you might want to move the data directly from the database used for short-term storage directly to a database that you use for long-term storage. For another example, the Audit Archiving utility never deletes the audit archive events generated during the process of archiving the audit data in a given database. You might want your custom audit archiving tool to delete the audit archiving events that are generated in short-term storage during the process of archiving.
Caution: Archiving audit data requires special privileges because it is the only auditing activity that allows audit data to be programmatically created and deleted. Maintain appropriate security for any tool that you build to do audit archiving. For more information, see Audit archiving security
The tables for auditing archiving include:
*_aud-audit-data — Contains the audit records generated as a result of enabling audit events in an active audit policy. For archiving, you generally move the records in this table from short-term to long-term storage.
*_aud-audit-data-value — Optionally, contains the before and after field values for database events that modify fields in one record per modified field. For archiving, you generally move the records in this table from short-term to long-term storage.
*_aud-event — Defines the audit events that generate the audit records in _aud-audit-data. For archiving, you generally copy (not move) the records to long-term storage for audit events represented by the generated audit records.
*_client-session — Optionally, records information about the client login session, including how the login session was authenticated, in order to support nonrepudiation of the audit data. For archiving, you generally copy (not move) the _client-session records to long-term storage that are associated with the generated audit records you are archiving.
Note: Records for a client session are only available if you specify the option to record client sessions in the database whose short-term audit data you are archiving. For more information on recording client sessions, see Generating client login session context.
*_db-detail — Contains audit data about the database being archived, that is, the database where the audit trail being archived was originally generated. For archiving, you generally copy the _db-detail records to long-term storage that are associated with the generated audit records you are archiving. There can be more than one _db-detail record if you are archiving audit data from more than one audit-enabled database. This provides access to the MAC key (database passkey) used to validate audit data record seals from each database that provides audit data records for archiving. For more information, see Audit archiving security.
For more information on these tables, see the sections on the audit data tables in OpenEdge Getting Started: Core Business Services - Security and Auditing.