ttaad4560s000Print Range of Audit Files (Multi Lines) (ttaad4463m000)

Use this session to print the contents of the audit files. You can specify which table fields must be printed in the report.

Note: 
  • The audit files only contain information about table fields for which audit trail is activated.
  • You can print an audit file only if these conditions are met:
    • Printing is allowed for the audit file: that is, the Printing allowed check box in the Audit Trail Security (ttaud3137m000) session must be selected for the audit file.
    • You are authorized to print the audit file. Audit authorizations are specified in the Audit Authorizations (ttaad4562m000) and Audit Authorizations (ttaad4162s000) sessions. See the online help of the Audit Authorizations (ttaad4162s000) session.

To print the audit files:

  1. Specify the table and the company for which the audit files must be printed.
  2. Specify the range of data to be printed.
  3. Specify whether the output of the session must be sent to a report or a file. Then specify the report settings or the file name.
  4. Specify the fields that must be printed in the report. You can specify 12 fields of the selected table, provided that they are non-combined fields.
  5. Specify which types of transactions must be printed by selecting one or more check boxes in the Status to Print section.
  6. Click Print, select the desired report and start the print process. You can select one of these reports:
    • Range of Audit Files (Sorted by Date/Time)
    • Range of Audit Files (Sorted by Session)
    • Range of Audit Files (Sorted by User)

Field Information

Table

The package code of the table for which the audit files must be printed.

Table

The code of the module to which the table belongs.

Table

The identification code of the table.

A table is uniquely identified by the combination of package code, module code and table code.

Company

The company for which the audit files must be printed.

Transaction

Specify a range of transactions.

Session

Specify a range of sessions. Only transactions caused by sessions that are within this range will be printed.

User

Specify a range of LN users. Only transactions performed by users that are within this range will be printed. This selection possibility is useful when you are interested in the changes performed by a particular user.

Date

Specify a date range.

Output to report

If this check box is selected, the output of the session is sent to a report.

Paper Size

The paper size, "A4 width" (188 characters) or "A3 width" (215 characters), for the report. A message is displayed when the selected fields do not fit within the selected size.

Print in Landscape Format

If this check box is selected, the report is printed in landscape format.

If this check box is cleared, the report is printed in portrait format.

Output to file

If this check box is selected, the output of the session is sent to a file. The report is not used. There is no limitation to the width of the output.

Filename

The path, including the directory, in which the output file is stored.

Columns to Print

A table field that you want to include in the report. The table field must be present in the selected table. This session reads its data from the audit files of the selected table; it does not read the table itself. Therefore it makes only sense to select table fields that are audited. If you select fields that are not audited, these fields will be empty in the report.

Note: 
  • Do not select the table's primary key field(s). The primary key (e.g. item code) is required to identify records and is therefore always printed by default.
  • You can select up to 12 additional table fields.
  • Do not select combined fields since they will not be processed. You must select the child fields as separate fields instead.
Committed

If this check box is selected, transactions with the Committed status are printed. These are transactions that are completed successfully. All changes made during these transactions are stored in the database.

Aborted

If this check box is selected, transactions that have the Aborted status are printed. These are transactions that failed. No changes were stored in the database.

Prepared

If this check box is selected, transactions that have the Prepared status are printed. These are transactions that are already logged in the audit files, but are not yet committed in the database.