discovery_log

The table below describes the discovery_log table.

This table contains the following foldable columns:

• sys_id_value
• cmdb_ci_value
• device_history_value
• sensor_value
• status_value
• cmdb_ci_display_value
• device_history_display_value
• help_display_value
• help_value
• level_display_value
• level_value
• message_display_value
• message_value
• result_code_display_value
• result_code_value
• sensor_display_value
• short_message_display_value
• short_message_value
• source_display_value
• source_value
• status_display_value
• sys_class_name_display_value
• sys_class_name_value
• sys_created_by_display_value
• sys_created_by_value
• sys_created_on_display_value
• sys_created_on_value
• sys_domain_display_value
• sys_domain_value
• sys_id_display_value

The primary key columns in this table are returnable.

Column Name	SQL Type	Updatable	Nullable
sys_id_value Primary Key	SQL_VARCHAR(64)	False	False
cmdb_ci_value Foreign Key linked to column sys_id_value in cmdb_ci table	SQL_VARCHAR(64)	True	True
device_history_value Foreign Key linked to column sys_id_value in discovery_device_history table	SQL_VARCHAR(64)	True	True
sensor_value Foreign Key linked to column sys_id_value in ecc_queue table	SQL_VARCHAR(64)	True	True
status_value Foreign Key linked to column sys_id_value in discovery_status table	SQL_VARCHAR(64)	True	True
cmdb_ci_display_value	SQL_VARCHAR(500)	True	True
device_history_display_value	SQL_VARCHAR(500)	True	True
help_display_value	SQL_VARCHAR(8000)	True	True
help_value	SQL_VARCHAR(8000)	True	True
level_display_value	SQL_VARCHAR(500)	True	True
level_value	SQL_VARCHAR(80)	True	True
message_display_value	SQL_VARCHAR(8000)	True	True
message_value	SQL_VARCHAR(8000)	True	True
result_code_display_value	SQL_VARCHAR(500)	True	True
result_code_value	SQL_INTEGER(signed)	True	True
sensor_display_value	SQL_VARCHAR(500)	True	True
short_message_display_value	SQL_VARCHAR(8000)	True	True
short_message_value	SQL_VARCHAR(8000)	True	True
source_display_value	SQL_VARCHAR(500)	True	True
source_value	SQL_VARCHAR(80)	True	True
status_display_value	SQL_VARCHAR(500)	True	True
sys_class_name_display_value	SQL_VARCHAR(500)	False	True
sys_class_name_value	SQL_VARCHAR(160)	False	True
sys_created_by_display_value	SQL_VARCHAR(500)	False	True
sys_created_by_value	SQL_VARCHAR(80)	False	True
sys_created_on_display_value	SQL_VARCHAR(500)	False	True
sys_created_on_value	SQL_TIMESTAMP	False	True
sys_domain_display_value	SQL_VARCHAR(500)	False	True
sys_domain_value	SQL_VARCHAR(64)	False	True
sys_id_display_value	SQL_VARCHAR(500)	False	False