Diagnostic log (server) database tables

This database contains all diagnostic log items of the server. The diagnostic logs are all the calls against the API of the system.

diag_log_ents

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

Table 1. diag_log_ents
Column name	Description	Data type
diag_log_ents_id	The unique id of the item.	bigint (8 bytes long integer) (Primary key) NULL is not allowed.
diag_log_ent_method	The web method of the API call.	nvarchar(50) NULL is not allowed.
diag_log_ent_type	The type of the method of the call.	nvarchar(50) NULL is not allowed.
diag_log_ent_arg_type	The argument type of the call.	nvarchar(100) NULL is allowed.
diag_log_ent_arg_value	The argument value of the call.	nvarchar(100) NULL is allowed.
diag_log_ent_datetime	The date time when the item was created.	datetime NULL is not allowed.
diag_log_ent_req_id	The id of the requestor of the call.	bigint (8 bytes long integer) NULL is not allowed.
diag_log_ent_req_name	The name of the requestor.	nvarchar(200) NULL is allowed.
diag_log_ent_req_uniq_name	The unique name of the requestor.	nvarchar(500) NULL is allowed.
diag_log_ent_req_snr	The serial number of the requestor.	nvarchar(100) NULL is allowed.
diag_log_ent_req_org_name	The organization name of the requestor.	nvarchar(100) NULL is allowed.
diag_log_ent_ent_id	The id of the entity.	bigint (8 bytes long integer) NULL is allowed.
diag_log_ent_ent_name	The name of the entity.	nvarchar(200) NULL is allowed.
diag_log_ent_ent_snr	The serial number of the entity.	nvarchar(100) NULL is allowed.
diag_log_ent_ent_org_name	The organization name of the entity.	nvarchar(100) NULL is allowed.
diag_log_ent_app_cpnt	The name of the component (usually Portal).	nvarchar(50) NULL is allowed.
diag_log_ent_svc_cpnt	The name of the service of the component (usually Application).	nvarchar(50) NULL is allowed.
diag_log_ent_adnl_info	The additional information/configuration of the item.	nvarchar(max) NULL is allowed.