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 |