SA Data Archive System Audit Log Tracking Report ranges and options

Ranges

See Reports - Ranges overview.

Options

Archive Date

The date in this option minus the value from the Number of Days to Keep field is the last date that the data is retained. Any data that is older and meets the deletion criteria is archived or purged.

The default value of **/**/** represents the current date. If you set up parameters for a stored report, leave the default value so the report reflects the current date when it is generated.

Specify -1 to -7 to go back up to 7 days. For example, if you specify **/-7/**, then the current date less 7 days is used for the date.

(A)rchive and Purge, or (P)urge Only

Specify A to save the selected transactions to disk or tape and then delete those transactions from the database.

Specify P to delete the selected transactions without first saving them to disk or tape. Use this method with extreme caution. If information is not archived, you cannot restore the information.

Print Detail for Transactions?

Select Yes to print the primary key data for each record that is archived or purged. This could produce a lengthy report.

Select No to print only a summary of the file name and number of transactions archived or deleted.

Tape Command (Shell Script File Name)

Specify a shell script file name for archiving. It will be executed as a UNIX shell script to copy the archive file to another directory or to save it to off-line media.

/rd/opsys folder in the RD_HOME directory of your system files. Set up this script with the correct UNIX read and execute security for the operator that performs the archive function. The tape command script is the name of a script that resides in the

During the archive process, .sh is appended to the name that you specify in this field. For example, if you specify archive94 as the shell script file name, the /RD_HOME/rd/opsys/archive94.sh script is initiated. The script should contain a single UNIX command directing the output to an appropriate tape device on your system, for example, | cpio -ocuvB > /dev/rmt0.

If you do not enter a shell script file name, the archive file is archive.a.

Command Type-(F)ile or (D)irect

Specify F to use the Tape Command value to archive data to the system file.

Specify D to archive directly to a tape device.

Number of Days to Keep Records

Specify the number of days to subtract from the archive date to use as an endpoint for selecting records. For example, if the archive date is 07/01/20 and the number of days to keep is 120, records from 03/02/20 through 06/30/20 are kept. Records before 03/02/20 are archived.

If this field is zero or blank, no records are archived or purged.

Table Name

Specify the system file name, such as OEEH for sales order headers, or OEEL for sales order lines. The table that you specify is the table that you are archiving to.

Operator

Specify the operator initials to archive for the table that you specified in the Table Name option.

Leave this field blank to archive all operators in the system to this table.

Function Name

Specify one function name, such as OEET or POET, to archive the audit log to. This is the function that caused the update to occur. This function archives to the table that you specified in the Table Name option.

Leave this field blank to archive all function names to the audit logs.