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 |