The OnBase SECURITYLOG table stores information related to system security (e.g., logging on to or off of the Client, Web Client or Unity Client, modifying Licensing, Creating/Modifying passwords). The SECURITYLOG table is located in DBSpace1.
| Column Name | Data Type | Description |
|---|---|---|
| securitylognum | bigint | |
| usernum | bigint | The unique identifier of the OnBase user who performed the logged action (crossreferenced to USERACCOUNT). |
| registernum | bigint |
The unique identifier of the workstation from which the action was performed (cross-referenced to REGISTEREDUSERS). |
| logdate | datetime | The date the transaction was logged. |
| messagetext | char(200) | Text message describing the transaction. |
| actionnum | bigint | See Log Table Actions in Appendix A. |
| subactionnum | bigint | |
| extrainfo1 | bigint | |
| severityflag | bigint | |
| tracelvl | bigint |
The indexes for the SECURITYLOG table are located in DBSpace1.
| Index Name | Included Columns |
|---|---|
| securitylog1 | logdate |
| securitylog2 | usernum, logdate |
| securitylog3 | actionnum, logdate |