SECURITYLOG - Database Reporting Guide - Foundation 23.1 - Foundation 23.1 - Ready - OnBase - external

Database Reporting Guide

Platform
OnBase
Product
Database Reporting Guide
Release
Foundation 23.1
License

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.

SECURITYLOG Table Values
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.

SECURITYLOG Table Indexes
Index Name Included Columns
securitylog1 logdate
securitylog2 usernum, logdate
securitylog3 actionnum, logdate