Derivation Hierarchy

Subclasses:
cmdb_ci_service_business, cmdb_ci_service_auto, service_offering, cmdb_ci_service_technical, cmdb_ci_service_group
Siblings:
cmdb_ci_config_file, cmdb_ci_san_zone_member, cmdb_ci_san_zone_alias, cmdb_ci_cim_profile, cmdb_ci_rack, cmdb_ci_vcenter_host_group, cmdb_ci_ip_phone, cmdb_ci_lb_pool_member, cmdb_ci_vcenter_datastore_disk, cmdb_ci_lb_interface, cmdb_ci_endpoint, cmdb_ci_ups_bypass, cmdb_ci_oslv_image, cmdb_ci_ip_service, cmdb_ci_db_catalog, cmdb_ci_crac, cmdb_ci_storage_hba, cmdb_ci_san_connection, cmdb_ci_circuit, cmdb_ci_tomcat_connector, cmdb_ci_port, cmdb_ci_cloud_resource_base, cmdb_ci_cluster, cmdb_ci_printing_hardware, cmdb_ci_san_zone_alias_member, cmdb_ci_information_object, cmdb_ci_network_adapter, cmdb_ci_storage_pool_member, cmdb_ci_business_capability, cmdb_ci_san, cmdb_ci_monitoring_hardware, cmdb_ci_pdu_outlet, cmdb_ci_print_queue, cmdb_ci_hardware, cmdb_ci_fc_port, cmdb_ci_oslv_image_tag, cmdb_ci_peripheral, cmdb_ci_translation_rule, cmdb_ci_qualifier, cmdb_ci_ups_output, cmdb_ci_business_process, cmdb_ci_san_endpoint, cmdb_ci_zone, cmdb_ci_vcenter_vm_group, cmdb_ci_veritas_disk_group, cmdb_ci_group, cmdb_ci_storage_fileshare, cmdb_ci_storage_volume, cmdb_ci_vm_object, cmdb_ci_os_packages, cmdb_ci_memory_module, cmdb_ci_san_fabric, cmdb_ci_ip_device, cmdb_ci_oslv_local_image, cmdb_ci_cluster_node, cmdb_ci_san_zone_set, cmdb_ci_cluster_vip, cmdb_ci_san_zone, cmdb_ci_lb_pool, cmdb_ci_display_hardware, cmdb_ci_network_host, dscy_net_base, cmdb_ci_storage_controller, cmdb_ci_appl, cmdb_ci_dns_name, cmdb_ci_imaging_hardware, cmdb_ci_ip_address, cmdb_ci_subnet, cmdb_ci_ups_input, cmdb_ci_storage_device, cmdb_ci_environment, cmdb_ci_vpc, cmdb_ci_vpn, cmdb_ci_cluster_resource, cmdb_ci_drs_vm_config, cmdb_ci_net_app_host, cmdb_ci_vcenter_cluster_drs_rule, cmdb_ci_ups_alarm, cmdb_ci_patches, cmdb_ci_lb_vlan, cmdb_ci_lb_service, cmdb_ci_database, cmdb_ci_acc, cmdb_ci_datacenter, cmdb_ci_storage_pool, cmdb_ci_storage_export, cmdb_ci_spkg, cmdb_ci_disk_partition, cmdb_ci_batch_job, cmdb_ci_facility_hardware, cmdb_ci_oslv_container, cmdb_ci_computer_room, cmdb_ci_websphere_cell, cmdb_ci_cloud_key_pair, cmdb_ci_ip_network, cmdb_ci_alias, cmdb_ci_application_cluster, cmdb_ci_lpar, cmdb_ci_comm, cmdb_ci_business_app, cmdb_ci_net_traffic

Table Details

Name:
cmdb_ci_service
Label:
Service (en)
Created On:
2022.09.17 01:51:52
Created By:
system
Updated On:
2022.09.17 01:51:52
Updated By:
system
Column Updated On:
2022.12.31 15:53:25
Column Updated By:
david.loo
Scope Name:
Global
Scope:
global
Listing:
open
Dictionary:
open

Columns

+ Status Name Label Datatype Length Scope Reference Included By
  aliases
Aliases string 40 Global cmdb_ci_service
  asset
Asset reference 32 Global alm_asset cmdb
+
asset_tag
Asset tag string 80 Global cmdb
  assigned
Assigned glide_date_time 40 Global cmdb
  assigned_to
Assigned to reference 32 Global sys_user cmdb
  assignment_group
Change Group reference 32 Global sys_user_group cmdb
  attestation_score
Attestation Score integer 40 Global cmdb_ci
  attestation_status
Attestation Status string[choice] 40 Global cmdb_ci
  attested
Attested boolean 40 Global cmdb_ci
  attested_by
Attested By reference 32 Global sys_user cmdb_ci
  attested_date
Attested Date glide_date_time 40 Global cmdb_ci
  attributes
Attributes string 65000 Global cmdb_ci
  business_contact
Business contact reference 32 Global sys_user cmdb_ci_service
  business_need
Business need string 40 Global cmdb_ci_service
  business_relation_manager
Business relation manager reference 32 Global sys_user cmdb_ci_service
  business_unit
Business Unit reference 32 Global business_unit cmdb_ci
  busines_criticality
Business criticality string[choice] 40 Global cmdb_ci_service
  can_print
Can Print boolean 40 Global cmdb_ci
  category
Category string 40 Global cmdb_ci
  change_control
Approval group reference 32 Global sys_user_group cmdb_ci
  checked_in
Checked in glide_date_time 40 Global cmdb
  checked_out
Checked out glide_date_time 40 Global cmdb
  checkout
Checkout string[choice] 40 Global cmdb_ci_service
  comments
Comments string 4000 Global cmdb_ci
  company
Company reference 32 Global core_company cmdb
  compatibility_dependencies
Compatibility dependencies string 40 Global cmdb_ci_service
  consumer_type
Consumer type string[choice] 40 Global cmdb_ci_service
  correlation_id
Correlation ID string 512 Global cmdb_ci
  cost
Cost float 40 Global cmdb
  cost_cc
Cost currency string[choice] 3 Global cmdb
  cost_center
Cost center reference 32 Global cmn_cost_center cmdb
  delivery_date
Order received glide_date_time 40 Global cmdb
  delivery_manager
Delivery manager reference 32 Global sys_user cmdb_ci_service
  department
Department reference 32 Global cmn_department cmdb
  discovery_source
Discovery source string[choice] 40 Global cmdb_ci
  dns_domain
DNS Domain string 255 Global cmdb_ci
  due
Due glide_date_time 40 Global cmdb
  due_in
Due in string[choice] 40 Global cmdb
  duplicate_of
Duplicate Of reference 32 Global cmdb_ci cmdb_ci
  end_date
End date glide_date_time 40 Global cmdb_ci_service
  environment
Environment string[choice] 40 Global cmdb_ci
  fault_count
Fault count integer 40 Global cmdb_ci
  first_discovered
First discovered glide_date_time 40 Global cmdb_ci
  fqdn
Fully qualified domain name string 255 Global cmdb_ci
  gl_account
GL account string 40 Global cmdb
  install_date
Installed glide_date_time 40 Global cmdb
  install_status
Install Status integer[choice] 40 Global cmdb
  invoice_number
Invoice number string 40 Global cmdb
  ip_address
IP Address ip_addr 255 Global cmdb_ci
  justification
Justification string[choice] 80 Global cmdb
  last_discovered
Most recent discovery glide_date_time 40 Global cmdb_ci
  last_review_date
Last review date glide_date_time 40 Global cmdb_ci_service
  lease_id
Lease contract string 40 Global cmdb
  life_cycle_stage
Life Cycle Stage reference 40 Global life_cycle_stage cmdb_ci
  life_cycle_stage_status
Life Cycle Stage Status reference 40 Global life_cycle_stage_status cmdb_ci
  location
Location reference 32 Global cmn_location cmdb
  mac_address
MAC Address string 24 Global cmdb_ci
  maintenance_schedule
Maintenance schedule reference 32 Global cmn_schedule cmdb_ci
  managed_by
Managed by reference 32 Global sys_user cmdb
  managed_by_group
Managed By Group reference 32 Global sys_user_group cmdb_ci
  manufacturer
Manufacturer reference 32 Global core_company cmdb
  model_id
Model ID reference 32 Global cmdb_model cmdb
  model_number
Model number string 255 Global cmdb_ci
  monitor
Monitor boolean 40 Global cmdb_ci
  monitoring_requirements
Monitoring requirements string 40 Global cmdb_ci_service
 
D
name
Name string 255 Global cmdb
  number
Number string 40 Global cmdb_ci_service
  operational_status
Operational status integer[choice] 40 Global cmdb_ci
  order_date
Ordered glide_date_time 40 Global cmdb
  owned_by
Owned by reference 32 Global sys_user cmdb
  parent
Parent reference 32 Global cmdb_ci_service cmdb_ci_service
  portfolio_status
Phase string[choice] 40 Global cmdb_ci_service
  po_number
PO number string 40 Global cmdb
  prerequisites
Prerequisites translated_html 65536 Global cmdb_ci_service
  price_model
Price model string[choice] 40 Global cmdb_ci_service
  price_unit
Price unit string 40 Global cmdb_ci_service
  published_ref
Published Item reference 32 Global cmdb_ci_service cmdb_ci_service
  purchase_date
Purchased glide_date 40 Global cmdb
  schedule
Schedule reference 32 Global cmn_schedule cmdb_ci
  serial_number
Serial number string 255 Global cmdb
  service_classification
Service classification string[choice] 40 Global cmdb_ci_service
  service_level_requirement
Service level requirement translated_html 8000 Global cmdb_ci_service
  service_owner_delegate
Delegate reference 32 Global sys_user cmdb_ci_service
  service_status
Status string[choice] 40 Global cmdb_ci_service
  short_description
Short Description string 1000 Global cmdb_ci
  skip_sync
Skip sync boolean 40 Global cmdb
  sla
SLA reference 32 Global sla cmdb_ci_service
  spm_service_portfolio
Service portfolio reference 32 Global spm_service_portfolio cmdb_ci_service
  spm_taxonomy_node
Taxonomy node reference 32 Global spm_taxonomy_node cmdb_ci_service
  stakeholders
Stakeholders glide_list 1024 Global sys_user cmdb_ci_service
  start_date
Start date glide_date_time 40 Global cmdb_ci
  state
State string[choice] 40 Global cmdb_ci_service
  subcategory
Subcategory string 40 Global cmdb_ci
  supported_by
Supported by reference 32 Global sys_user cmdb
  support_group
Support group reference 32 Global sys_user_group cmdb
  sys_class_name
Class sys_class_name[choice] 80 Global cmdb
  sys_class_path
Sys class path sys_class_path 255 Global cmdb
  sys_created_by
Created by string 40 Global cmdb
  sys_created_on
Created glide_date_time 40 Global cmdb
  sys_domain
Domain domain_id 32 Global cmdb
  sys_domain_path
Domain Path domain_path 255 Global cmdb
 
K
sys_id
Sys ID GUID 32 Global cmdb_ci_service
  sys_mod_count
Updates integer 40 Global cmdb
  sys_updated_by
Updated by string 40 Global cmdb
  sys_updated_on
Updated glide_date_time 40 Global cmdb
  unit_description
Unit description html 4000 Global cmdb_ci_service
  unverified
Requires verification boolean 40 Global cmdb
  used_for
Used for string[choice] 40 Global cmdb_ci_service
  user_group
Users supported reference 32 Global sys_user_group cmdb_ci_service
  vendor
Vendor reference 32 Global core_company cmdb
  version
Version string 40 Global cmdb_ci_service
  warranty_expiration
Warranty expiration glide_date 40 Global cmdb
P
Passive
M
Mandatory
D
Display Value
K
Key
U
Unique
X
Deleted

Table Distribution

Washington Vancouver Uta Tokyo (Vanilla) Tokyo Sandiego

Deviating Attributes

Column Current Environment Washington Vancouver Uta Tokyo (Vanilla) Sandiego
asset_tag different different different different different
cmdb_ot_entity missing missing missing missing missing
csat_score missing missing missing missing
ip_address different
perf_score missing missing missing missing
product_instance_id missing missing missing missing missing
total_vulnerable_items missing missing missing missing missing
vulnerability_risk_score missing missing missing missing missing

Referenced

cmdb_ci referenced from table:
alm_asset, alm_entitlement, ast_contract_instance, bsm_chart, bsm_graph, cert_audit_result, change_request_imac, cmdb_alias, cmdb_ci, cmdb_ci_config_file_tracked, cmdb_ci_endpoint_manual, cmdb_ci_end_of_life_ledger, cmdb_ci_fc_port, cmdb_ci_ip_network, cmdb_ci_ip_service, cmdb_ci_lb_interface, cmdb_ci_lb_pool, cmdb_ci_lb_pool_member, cmdb_ci_lb_service, cmdb_ci_lb_vlan, cmdb_ci_memory_module, cmdb_ci_network_adapter, cmdb_ci_os_packages, cmdb_ci_outage, cmdb_ci_patches, cmdb_ci_state_management_task_to_ci, cmdb_ci_storage_device, cmdb_ci_storage_export, cmdb_ci_storage_pool, cmdb_ci_storage_pool_member, cmdb_ci_storage_volume, cmdb_ci_ucs_blade, cmdb_ci_ucs_chassis, cmdb_ci_ucs_rack_unit, cmdb_ci_vpn, cmdb_datasource_last_update, cmdb_data_management_task_to_ci, cmdb_dependent_ci_ledger, cmdb_discovery, cmdb_dynamic_ire_match, cmdb_environment_to_ci, cmdb_group_contains_ci, cmdb_health_result, cmdb_instance_run_history, cmdb_ip_service_ci, cmdb_ire_output_comparison_item, cmdb_key_value, cmdb_m2m_business_process_ci, cmdb_multisource_data, cmdb_outage_ci_mtom, cmdb_peer, cmdb_pid, cmdb_policy_ci_exclusion_list, cmdb_printer_instance, cmdb_print_queue_instance, cmdb_properties, cmdb_related, cmdb_rel_ci, cmdb_rel_group, cmdb_rel_person, cmdb_rel_team, cmdb_resource_location, cmdb_serial_number, cmdb_software_instance, cmdb_subscriber, cmdb_switch_port, cmn_notif_message, conflict, contract_rel_ci, csdm_dashboard_action_report_result, csdm_dashboard_reports_result, csdm_dashboard_type_report_result, diagnostic_event, discovery_active_error, discovery_device_duplicate_ips, discovery_device_history, discovery_log, discovery_log0000, discovery_log0001, discovery_log0002, discovery_log0003, discovery_log0004, discovery_log0005, discovery_log0006, discovery_log0007, dl_u_assignment, dscy_router_interface, dscy_route_interface, dscy_route_next_hop, dscy_switchport, dscy_swtch_fwd_rule, dscy_swtch_partition, dsl, duplicate_audit_result, ecc_event, ecc_event0000, ecc_event0001, ecc_event0002, ecc_event0003, ecc_event0004, ecc_event0005, ecc_event0006, fm_expense_line, itam_ci_usage, itil_agreement_ci, itil_agreement_target_ci, kb_knowledge, m2m_kb_ci, map_cell, ngbsm_view, release_cis, sa_notification, sa_notification0000, sa_notification0001, sa_notification0002, sa_notification0003, sa_notification0004, sa_notification0005, sa_notification0006, sc_req_item, service_availability, service_offering_commitment, sm_ci_field_data, sm_flapper_strategy_data, sn_cmdb_ws_attestation_task_to_ci, statemgmt_cmdb_actions, statemgmt_ops_state, svc_changes, svc_ci_assoc, svc_model_assoc_ci, task, task_ci, task_cmdb_ci_service, unauth_chg_notifications
cmdb_ci_service referenced from table:
cmdb_ci_service, cmdb_convert_bulk_services_entry, cmdb_health_result_service_map, cmdb_health_scorecard_service, conflict, m2m_sp_status_subscription, release_product, sa_hash, sa_m2m_service_entry_point, sc_cat_item_service, service_in_scope, service_out_scope, svc_ci_assoc, svc_rel_assoc, sys_customer_trend, task

shift+click on node to show path. mouse scroll to zoom, dblclick to zoom in, dblclick+shift to zoom out