|
|
|
|
Used to track run time changes to the database. An entry is added for each change request honored by SDB. Each entry includes date/time of change, user name and associated data, information identifying the tables and entries changed, the tracking transaction number, and the location in the detailed transaction file of this transaction. Note, that since the database may be exported, edited and imported, this file may be reduced to contain only the most recent changes.
Structure name: auditLog_t. Table base file name: audit. Table define: TBL_AUDIT.
| Member Name | Key | Range | Type | Description |
|---|---|---|---|---|
| al_TransactionNum | Unique | Any | DWORD | The transaction number assigned to this database change by SDB. |
| al_Side | 1 or 2 | WORD | If the change was performed by the SDB on side A, the value is 1. If the change was performed by the SDB on side B, the value is 2. | |
| al_Date | Yes | Any | DOUBLE | PICS date/time of the change. The units are days since 1/1/1980. |
| al_User | Yes | Description Characters | CHAR(16) | Name of the user that performed the change. |
| al_Node | Description Characters | CHAR(32) | Computer name of the user making the change. | |
| al_Note | Description Characters | CHAR(512) | A note by the user describing the change. | |
| al_FileName | NT filename | CHAR(256) | Name of the transaction file which contains the details about the change | |
| al_FileOffset | Any | DWORD | Offset into the transaction file when the detail change record begins. | |
| al_TransLen | Any | WORD | Length of the detail change record in bytes. | |
| al_AccessToken | DWORD | User's access token. | ||
| al_IPaddr | Any | DWORD | IP address of the user's computer. | |
| al_Operation | Any valid SDB change database command | WORD | The command given to SDB, such as SDB_MODIFYANAALARM. | |
| al_Tables | Any | DWORD | A bit is set for each table modified. The bit number set corresponds to the table id from Tables.h | |
| al_Tables2 | Any | DWORD | A bit is set for each table modified. The bit number set corresponds to the table id plus 32 from Tables.h Currently, TBL_COUNT is less then 32 tables, so this field is zero. | |
| al_TableID | 0 to TBL_COUNT | WORD | The table containing the key used to identify the change. | |
| al_KeyID | 0 to the field count for the key table | WORD | The field id from Sdb-Def.h which identifies the primary record changed. | |
| al_KeyValue | Depends of key | DWORD | The value of the identifing key field. |
|
|
|
|