ecc_event
The table below describes the ecc_event table.
This table contains the following foldable columns:
- sys_id_value
- cmdb_ci_value
- task_value
- agent_correlator_display_value
- agent_correlator_value
- agent_display_value
- agent_value
- cmdb_ci_display_value
- component_display_value
- component_value
- name_display_value
- name_value
- outage_display_value
- outage_value
- payload_display_value
- payload_value
- severity_display_value
- severity_value
- source_display_value
- source_value
- status_display_value
- status_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_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
- task_display_value
- type_display_value
- type_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 |
|
task_value Foreign Key linked to column sys_id_value in task table |
SQL_VARCHAR(64) | True | True |
|
agent_correlator_display_value |
SQL_VARCHAR(500) | True | True |
|
agent_correlator_value |
SQL_VARCHAR(200) | True | True |
|
agent_display_value |
SQL_VARCHAR(500) | True | True |
|
agent_value |
SQL_VARCHAR(80) | True | True |
|
cmdb_ci_display_value |
SQL_VARCHAR(500) | True | True |
|
component_display_value |
SQL_VARCHAR(500) | True | True |
|
component_value |
SQL_VARCHAR(200) | True | True |
|
name_display_value |
SQL_VARCHAR(500) | True | True |
|
name_value |
SQL_VARCHAR(200) | True | True |
|
outage_display_value |
SQL_VARCHAR(500) | True | True |
|
outage_value |
SQL_BIT | True | True |
|
payload_display_value |
SQL_LONGVARCHAR(1024) | True | True |
|
payload_value |
SQL_LONGVARCHAR(1024) | True | True |
|
severity_display_value |
SQL_VARCHAR(500) | True | True |
|
severity_value |
SQL_VARCHAR(80) | True | True |
|
source_display_value |
SQL_VARCHAR(500) | True | True |
|
source_value |
SQL_VARCHAR(200) | True | True |
|
status_display_value |
SQL_VARCHAR(500) | True | True |
|
status_value |
SQL_VARCHAR(80) | 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_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 |
|
task_display_value |
SQL_VARCHAR(500) | True | True |
|
type_display_value |
SQL_VARCHAR(500) | True | True |
|
type_value |
SQL_VARCHAR(80) | True | True |