| # Print 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. To print the audit files: Specify the table and the company for which the audit files must be printed. Specify the range of data to be printed. 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. 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. Specify which types of transactions must be printed by selecting one or more check boxes in the Status to Print section. 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) 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. |