The SYSAUTHLOG Table
SYSAUTHLOG is the table where all the journaled log entries are maintained. Log File settings are maintained in the Policy Configuration window. These settings include enabling or disabling the Auto Clear of the log feature and, if Auto Clear is enabled, the maximum number of entries and the maximum age in days of log entries to permit. Please see the Policy Configuration Window elsewhere in this document.
The SYSAUTHLOG Dictionary
| Column Name | Type | Pos | S/M | DataType | Just | Len | Heading |
|---|---|---|---|---|---|---|---|
| ACTION | F | 0*3 | S | VARCHAR(255) | L | 20 | Action |
| APPLICATION | F | 0*1 | S | VARCHAR(255) | L | 20 | Application |
| CREATED | F | 0*2 | S | DATETIME | R | 21 | Created |
| ID | F | 0*0 | S | VARCHAR(255) | L | 20 | Id |
| RESULT | F | 1 | S | VARCHAR(255) | L | 20 | Result |
| COMMENTS | F | 2 | S | VARCHAR(255) | L | 20 | Comments |
| USERNAME | F | 3 | S | VARCHAR(255) | L | 20 | Username |
| CURRENT_RTI_AUTH_USER | F | 4 | S | VARCHAR(255) | L | 20 | Current Logged In RTI_AUTH User Name |
In addition, a BTREE index must be created on the “CREATED” column so that the Auto Clear feature, if enabled, can properly select and clear SYSAUTHLOG rows.