discovery_device_history

The table below describes the discovery_device_history table.

This table contains the following foldable columns:

  • sys_id_value
  • cmdb_ci_value
  • status_value
  • classified_as_display_value
  • classified_as_value
  • cmdb_ci_display_value
  • completed_display_value
  • completed_value
  • current_state_display_value
  • current_state_value
  • dns_name_display_value
  • dns_name_value
  • issues_display_value
  • issues_link_display_value
  • issues_link_value
  • issues_value
  • last_state_display_value
  • last_state_value
  • scan_status_display_value
  • scan_status_value
  • scratchpad_display_value
  • scratchpad_value
  • source_display_value
  • source_value
  • started_display_value
  • started_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
  • 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
  • workflow_state_display_value
  • workflow_state_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

status_value

Foreign Key linked to column sys_id_value in discovery_status table
 SQL_VARCHAR(64) True True

classified_as_display_value

 SQL_VARCHAR(500) True True

classified_as_value

 SQL_VARCHAR(160) True True

cmdb_ci_display_value

 SQL_VARCHAR(500) True True

completed_display_value

 SQL_VARCHAR(500) True True

completed_value

 SQL_INTEGER(signed) True True

current_state_display_value

 SQL_VARCHAR(500) True True

current_state_value

 SQL_VARCHAR(80) True True

dns_name_display_value

 SQL_VARCHAR(500) True True

dns_name_value

 SQL_VARCHAR(80) True True

issues_display_value

 SQL_VARCHAR(500) True True

issues_link_display_value

 SQL_VARCHAR(500) True True

issues_link_value

 SQL_VARCHAR(510) True True

issues_value

 SQL_INTEGER(signed) True True

last_state_display_value

 SQL_VARCHAR(500) True True

last_state_value

 SQL_VARCHAR(80) True True

scan_status_display_value

 SQL_VARCHAR(500) True True

scan_status_value

 SQL_VARCHAR(80) True True

scratchpad_display_value

 SQL_LONGVARCHAR(1024) True True

scratchpad_value

 SQL_LONGVARCHAR(1024) True True

source_display_value

 SQL_VARCHAR(500) True True

source_value

 SQL_VARCHAR(80) True True

started_display_value

 SQL_VARCHAR(500) True True

started_value

 SQL_INTEGER(signed) 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

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

workflow_state_display_value

 SQL_VARCHAR(500) True True

workflow_state_value

 SQL_VARCHAR(256) True True