Audit log database tables

This database contains all audit log items explicit for changes in the system and/or tracking of objects.

log_ents

This table stores and contains information of the audit log items.

Table 1. log_ents
Column name	Description	Data type
log_ents_id	The unique id of the item.	bigint (8 bytes long integer) (Primary key) NULL is not allowed.
log_ent_last_row	The data of previous row index.	varbinary(max) NULL is allowed.
log_ent_type	The type of audit log (usually the task type id).	int (4 bytes integer) NULL is not allowed.
log_ent_level	The level of audit log (usually the current state of a task).	int (4 bytes integer) NULL is not allowed.
log_ent_created	The date time when the audit log was created.	datetime NULL is allowed.
log_ent_version	The version flag of the audit log for compability purpose.	nvarchar(50) NULL is allowed.
log_ent_client_id	The type of device used for login.	nvarchar(100) NULL is allowed.
log_ent_org_name	The current organization name of the item.	nvarchar(100) NULL is allowed.
log_ent_org_ofc_name	The current office name of the item.	nvarchar(100) NULL is allowed.
log_ent_req_name	The name of requestor (usually the requestor user of a task).	nvarchar(200) NULL is allowed.
log_ent_req_uniq_name	The unique name of the requestor.	nvarchar(500) NULL is allowed.
log_ent_req_snr	The serial number of the requestor.	nvarchar(100) NULL is allowed.
log_ent_proc_name	The name of the procesor (usually the processor of current state of a task).	nvarchar(200) NULL is allowed.
log_ent_proc_uniq_name	The unique name of the processor.	nvarchar(500) NULL is allowed.
log_ent_proc_snr	The serial number of the processor.	nvarchar(100) NULL is allowed.
log_ent_end_usr_name	The name of the end user (usually the user entity in a task).	nvarchar(200) NULL is allowed.
log_ent_end_usr_uniq_name	The unique name of the end user.	nvarchar(500) NULL is allowed.
log_ent_end_usr_snr	The serial number of the end user.	nvarchar(100) NULL is allowed.
log_ent_tkn_snr	The serial number of a token.	nvarchar(100) NULL is allowed.
log_ent_tkn_seqnr1	The sequence number of a token.	nvarchar(100) NULL is allowed.
log_ent_tkn_seqnr2	The secondary sequence number of the token.	nvarchar(100) NULL is allowed.
log_ent_tkn_tml_name	The name of the token template.	nvarchar(300) NULL is allowed.
log_ent_crt_cn	The common name of a certificate.	nvarchar(500) NULL is allowed.
log_ent_crt_snr	The serial number of a certificate.	nvarchar(100) NULL is allowed.
log_ent_task_ent_descr	The common description of the entity of a task.	nvarchar(500) NULL is allowed.
log_ent_task_type_adnl	The additional task type information.	nvarchar(max) NULL is allowed.
log_ent_app	The type of application of the audit log (usually Net iD Portal).	int (4 bytes integer) NULL is allowed.
log_ent_crt	The signing certificate of the item.	nvarchar(max) NULL is allowed.
log_ent_data_text	The audit log item in clear text.	nvarchar(max) NULL is allowed.
log_ent_data	The binary data of the item.	varbinary(max) NULL is not allowed.
log_ent_signature	The signature of the item (PKCS#7).	varbinary(max) NULL is allowed.
log_ent_adnl_info	The additional information/configuration of the item.	nvarchar(max) NULL is allowed.