discovery_active_error

The table below describes the discovery_active_error 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
  • ip_display_value
  • ip_value
  • message_display_value
  • message_value
  • result_code_display_value
  • result_code_value
  • sensor_display_value
  • short_message_display_value
  • short_message_value
  • status_display_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
  • sys_mod_count_display_value
  • sys_mod_count_value
  • sys_tags_display_value
  • sys_tags_value
  • sys_updated_by_display_value
  • sys_updated_by_value
  • sys_updated_on_display_value
  • sys_updated_on_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

ip_display_value

SQL_VARCHAR(500) True True

ip_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

status_display_value

SQL_VARCHAR(500) True 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

sys_mod_count_display_value

SQL_VARCHAR(500) False True

sys_mod_count_value

SQL_INTEGER(signed) False True

sys_tags_display_value

SQL_VARCHAR(500) False True

sys_tags_value

SQL_VARCHAR(256) False True

sys_updated_by_display_value

SQL_VARCHAR(500) False True

sys_updated_by_value

SQL_VARCHAR(80) False True

sys_updated_on_display_value

SQL_VARCHAR(500) False True

sys_updated_on_value

SQL_TIMESTAMP False True