cmdb_ci

The table below describes the cmdb_ci table.

This table contains the following foldable columns:

  • sys_id_value
  • asset_value
  • assigned_to_value
  • assignment_group_value
  • change_control_value
  • company_value
  • cost_center_value
  • department_value
  • location_value
  • maintenance_schedule_value
  • managed_by_value
  • manufacturer_value
  • model_id_value
  • owned_by_value
  • schedule_value
  • support_group_value
  • supported_by_value
  • vendor_value
  • asset_display_value
  • asset_tag_display_value
  • asset_tag_value
  • assigned_display_value
  • assigned_to_display_value
  • assigned_value
  • assignment_group_display_value
  • attributes_display_value
  • attributes_value
  • can_print_display_value
  • can_print_value
  • category_display_value
  • category_value
  • change_control_display_value
  • checked_in_display_value
  • checked_in_value
  • checked_out_display_value
  • checked_out_value
  • comments_display_value
  • comments_value
  • company_display_value
  • correlation_id_display_value
  • correlation_id_value
  • cost_cc_display_value
  • cost_cc_value
  • cost_center_display_value
  • cost_display_value
  • cost_value
  • delivery_date_display_value
  • delivery_date_value
  • department_display_value
  • discovery_source_display_value
  • discovery_source_value
  • dns_domain_display_value
  • dns_domain_value
  • due_display_value
  • due_in_display_value
  • due_in_value
  • due_value
  • fault_count_display_value
  • fault_count_value
  • first_discovered_display_value
  • first_discovered_value
  • fqdn_display_value
  • fqdn_value
  • gl_account_display_value
  • gl_account_value
  • install_date_display_value
  • install_date_value
  • install_status_display_value
  • install_status_value
  • invoice_number_display_value
  • invoice_number_value
  • ip_address_display_value
  • ip_address_value
  • justification_display_value
  • justification_value
  • last_discovered_display_value
  • last_discovered_value
  • lease_id_display_value
  • lease_id_value
  • location_display_value
  • mac_address_display_value
  • mac_address_value
  • maintenance_schedule_display_value
  • managed_by_display_value
  • manufacturer_display_value
  • model_id_display_value
  • model_number_display_value
  • model_number_value
  • monitor_display_value
  • monitor_value
  • name_display_value
  • name_value
  • operational_status_display_value
  • operational_status_value
  • order_date_display_value
  • order_date_value
  • owned_by_display_value
  • po_number_display_value
  • po_number_value
  • purchase_date_display_value
  • purchase_date_value
  • schedule_display_value
  • serial_number_display_value
  • serial_number_value
  • short_description_display_value
  • short_description_value
  • skip_sync_display_value
  • skip_sync_value
  • start_date_display_value
  • start_date_value
  • subcategory_display_value
  • subcategory_value
  • support_group_display_value
  • supported_by_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_path_display_value
  • sys_domain_path_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
  • unverified_display_value
  • unverified_value
  • vendor_display_value
  • warranty_expiration_display_value
  • warranty_expiration_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

asset_value

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

assigned_to_value

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

assignment_group_value

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

change_control_value

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

company_value

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

cost_center_value

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

department_value

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

location_value

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

maintenance_schedule_value

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

managed_by_value

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

manufacturer_value

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

model_id_value

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

owned_by_value

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

schedule_value

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

support_group_value

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

supported_by_value

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

vendor_value

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

asset_display_value

 SQL_VARCHAR(500) True True

asset_tag_display_value

 SQL_VARCHAR(500) True True

asset_tag_value

 SQL_VARCHAR(80) True True

assigned_display_value

 SQL_VARCHAR(500) True True

assigned_to_display_value

 SQL_VARCHAR(500) True True

assigned_value

 SQL_TIMESTAMP True True

assignment_group_display_value

 SQL_VARCHAR(500) True True

attributes_display_value

 SQL_LONGVARCHAR(1024) True True

attributes_value

 SQL_LONGVARCHAR(1024) True True

can_print_display_value

 SQL_VARCHAR(500) True True

can_print_value

 SQL_BIT True True

category_display_value

 SQL_VARCHAR(500) True True

category_value

 SQL_VARCHAR(80) True True

change_control_display_value

 SQL_VARCHAR(500) True True

checked_in_display_value

 SQL_VARCHAR(500) True True

checked_in_value

 SQL_TIMESTAMP True True

checked_out_display_value

 SQL_VARCHAR(500) True True

checked_out_value

 SQL_TIMESTAMP True True

comments_display_value

 SQL_VARCHAR(8000) True True

comments_value

 SQL_VARCHAR(8000) True True

company_display_value

 SQL_VARCHAR(500) True True

correlation_id_display_value

 SQL_VARCHAR(1024) True True

correlation_id_value

 SQL_VARCHAR(1024) True True

cost_cc_display_value

 SQL_VARCHAR(500) True True

cost_cc_value

 SQL_VARCHAR(6) True True

cost_center_display_value

 SQL_VARCHAR(500) True True

cost_display_value

 SQL_VARCHAR(500) True True

cost_value

 SQL_NUMERIC(38,3) True True

delivery_date_display_value

 SQL_VARCHAR(500) True True

delivery_date_value

 SQL_TIMESTAMP True True

department_display_value

 SQL_VARCHAR(500) True True

discovery_source_display_value

 SQL_VARCHAR(500) True True

discovery_source_value

 SQL_VARCHAR(80) True True

dns_domain_display_value

 SQL_VARCHAR(500) True True

dns_domain_value

 SQL_VARCHAR(510) True True

due_display_value

 SQL_VARCHAR(500) True True

due_in_display_value

 SQL_VARCHAR(500) True True

due_in_value

 SQL_VARCHAR(80) True True

due_value

 SQL_TIMESTAMP True True

fault_count_display_value

 SQL_VARCHAR(500) True True

fault_count_value

 SQL_INTEGER(signed) True True

first_discovered_display_value

 SQL_VARCHAR(500) True True

first_discovered_value

 SQL_TIMESTAMP True True

fqdn_display_value

 SQL_VARCHAR(500) True True

fqdn_value

 SQL_VARCHAR(510) True True

gl_account_display_value

 SQL_VARCHAR(500) True True

gl_account_value

 SQL_VARCHAR(80) True True

install_date_display_value

 SQL_VARCHAR(500) True True

install_date_value

 SQL_TIMESTAMP True True

install_status_display_value

 SQL_VARCHAR(500) True True

install_status_value

 SQL_INTEGER(signed) True True

invoice_number_display_value

 SQL_VARCHAR(500) True True

invoice_number_value

 SQL_VARCHAR(80) True True

ip_address_display_value

 SQL_VARCHAR(500) True True

ip_address_value

 SQL_VARCHAR(510) True True

justification_display_value

 SQL_VARCHAR(500) True True

justification_value

 SQL_VARCHAR(160) True True

last_discovered_display_value

 SQL_VARCHAR(500) True True

last_discovered_value

 SQL_TIMESTAMP True True

lease_id_display_value

 SQL_VARCHAR(500) True True

lease_id_value

 SQL_VARCHAR(80) True True

location_display_value

 SQL_VARCHAR(500) True True

mac_address_display_value

 SQL_VARCHAR(500) True True

mac_address_value

 SQL_VARCHAR(80) True True

maintenance_schedule_display_value

 SQL_VARCHAR(500) True True

managed_by_display_value

 SQL_VARCHAR(500) True True

manufacturer_display_value

 SQL_VARCHAR(500) True True

model_id_display_value

 SQL_VARCHAR(500) True True

model_number_display_value

 SQL_VARCHAR(500) True True

model_number_value

 SQL_VARCHAR(510) True True

monitor_display_value

 SQL_VARCHAR(500) True True

monitor_value

 SQL_BIT True True

name_display_value

 SQL_VARCHAR(500) True True

name_value

 SQL_VARCHAR(510) True True

operational_status_display_value

 SQL_VARCHAR(500) True True

operational_status_value

 SQL_INTEGER(signed) True True

order_date_display_value

 SQL_VARCHAR(500) True True

order_date_value

 SQL_TIMESTAMP True True

owned_by_display_value

 SQL_VARCHAR(500) True True

po_number_display_value

 SQL_VARCHAR(500) True True

po_number_value

 SQL_VARCHAR(80) True True

purchase_date_display_value

 SQL_VARCHAR(500) True True

purchase_date_value

 SQL_DATE True True

schedule_display_value

 SQL_VARCHAR(500) True True

serial_number_display_value

 SQL_VARCHAR(500) True True

serial_number_value

 SQL_VARCHAR(510) True True

short_description_display_value

 SQL_VARCHAR(2000) True True

short_description_value

 SQL_VARCHAR(2000) True True

skip_sync_display_value

 SQL_VARCHAR(500) True True

skip_sync_value

 SQL_BIT True True

start_date_display_value

 SQL_VARCHAR(500) True True

start_date_value

 SQL_TIMESTAMP True True

subcategory_display_value

 SQL_VARCHAR(500) True True

subcategory_value

 SQL_VARCHAR(80) True True

support_group_display_value

 SQL_VARCHAR(500) True True

supported_by_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_path_display_value

 SQL_VARCHAR(500) False True

sys_domain_path_value

 SQL_VARCHAR(510) 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

unverified_display_value

 SQL_VARCHAR(500) True True

unverified_value

 SQL_BIT True True

vendor_display_value

 SQL_VARCHAR(500) True True

warranty_expiration_display_value

 SQL_VARCHAR(500) True True

warranty_expiration_value

 SQL_DATE True True