JDBC Driver for ServiceNow

Build 22.0.8479

cmdb_task_chg

The ServiceNow view cmdb_task_chg.

Columns

Name Type References Description
task_sys_id String
task_applied Bool
task_applied_date Datetime
task_ci_item String
task_ci_item_link String
task_manual_proposed_change Bool
task_sys_created_by String
task_sys_created_on Datetime
task_sys_mod_count Int
task_sys_tags String
task_sys_updated_by String
task_sys_updated_on Datetime
task_task String
task_task_link String
task_xml String
chg_sys_id String
chg_active Bool
chg_activity_due Datetime
chg_additional_assignee_list String
chg_approval String
chg_approval_history String
chg_approval_set Datetime
chg_assigned_to String
chg_assigned_to_link String
chg_assignment_group String
chg_assignment_group_link String
chg_backout_plan String
chg_business_duration Long
chg_business_service String
chg_business_service_link String
chg_cab_date Date
chg_cab_delegate String
chg_cab_delegate_link String
chg_cab_recommendation String
chg_cab_required Bool
chg_calendar_duration Long
chg_category String
chg_change_plan String
chg_close_code String
chg_close_notes String
chg_closed_at Datetime
chg_closed_by String
chg_closed_by_link String
chg_cmdb_ci String
chg_cmdb_ci_link String
chg_comments String
chg_comments_and_work_notes String
chg_company String
chg_company_link String
chg_conflict_last_run Datetime
chg_conflict_status String
chg_contact_type String
chg_correlation_display String
chg_correlation_id String
chg_delivery_plan String
chg_delivery_plan_link String
chg_delivery_task String
chg_delivery_task_link String
chg_description String
chg_due_date Datetime
chg_end_date Datetime
chg_escalation Int
chg_expected_start Datetime
chg_follow_up Datetime
chg_group_list String
chg_impact Int
chg_implementation_plan String
chg_justification String
chg_knowledge Bool
chg_location String
chg_location_link String
chg_made_sla Bool
chg_number String
chg_on_hold Bool
chg_on_hold_reason String
chg_on_hold_task String
chg_opened_at Datetime
chg_opened_by String
chg_opened_by_link String
chg_order Int
chg_outside_maintenance_schedule Bool
chg_parent String
chg_parent_link String
chg_phase String
chg_phase_state String
chg_priority Int
chg_production_system Bool
chg_reason String
chg_reassignment_count Int
chg_rejection_goto String
chg_rejection_goto_link String
chg_requested_by String
chg_requested_by_date Datetime
chg_requested_by_link String
chg_review_comments String
chg_review_date Date
chg_review_status Int
chg_risk Int
chg_risk_impact_analysis String
chg_route_reason Int
chg_scope Int
chg_service_offering String
chg_service_offering_link String
chg_short_description String
chg_sla_due Datetime
chg_start_date Datetime
chg_state Int
chg_std_change_producer_version String
chg_std_change_producer_version_link String
chg_sys_class_name String
chg_sys_created_by String
chg_sys_created_on Datetime
chg_sys_domain String
chg_sys_domain_path String
chg_sys_mod_count Int
chg_sys_tags String
chg_sys_updated_by String
chg_sys_updated_on Datetime
chg_task_effective_number String
chg_test_plan String
chg_time_worked String
chg_type String
chg_u_comments String
chg_u_some_test_field String
chg_unauthorized Bool
chg_universal_request String
chg_universal_request_link String
chg_upon_approval String
chg_upon_reject String
chg_urgency Int
chg_user_input String
chg_variables String
chg_watch_list String
chg_wf_activity String
chg_wf_activity_link String
chg_work_end Datetime
chg_work_notes String
chg_work_notes_list String
chg_work_start Datetime
ci_sys_id String
ci_asset String
ci_asset_link String
ci_asset_tag String
ci_assigned Datetime
ci_assigned_to String
ci_assigned_to_link String
ci_assignment_group String
ci_assignment_group_link String
ci_attestation_score Int
ci_attested Bool
ci_attested_by String
ci_attested_by_link String
ci_attested_date Datetime
ci_attributes String
ci_can_print Bool
ci_category String
ci_change_control String
ci_change_control_link String
ci_checked_in Datetime
ci_checked_out Datetime
ci_comments String
ci_company String
ci_company_link String
ci_correlation_id String
ci_cost Float
ci_cost_cc String
ci_cost_center String
ci_cost_center_link String
ci_delivery_date Datetime
ci_department String
ci_department_link String
ci_discovery_source String
ci_dns_domain String
ci_due Datetime
ci_due_in String
ci_duplicate_of String
ci_duplicate_of_link String
ci_environment String
ci_fault_count Int
ci_first_discovered Datetime
ci_fqdn String
ci_gl_account String
ci_install_date Datetime
ci_install_status Int
ci_invoice_number String
ci_ip_address String
ci_justification String
ci_last_discovered Datetime
ci_lease_id String
ci_life_cycle_stage String
ci_life_cycle_stage_link String
ci_life_cycle_stage_status String
ci_life_cycle_stage_status_link String
ci_location String
ci_location_link String
ci_mac_address String
ci_maintenance_schedule String
ci_maintenance_schedule_link String
ci_managed_by String
ci_managed_by_group String
ci_managed_by_group_link String
ci_managed_by_link String
ci_manufacturer String
ci_manufacturer_link String
ci_model_id String
ci_model_id_link String
ci_model_number String
ci_monitor Bool
ci_name String
ci_operational_status Int
ci_order_date Datetime
ci_owned_by String
ci_owned_by_link String
ci_po_number String
ci_purchase_date Date
ci_schedule String
ci_schedule_link String
ci_serial_number String
ci_short_description String
ci_skip_sync Bool
ci_start_date Datetime
ci_subcategory String
ci_support_group String
ci_support_group_link String
ci_supported_by String
ci_supported_by_link String
ci_sys_class_name String
ci_sys_class_path String
ci_sys_created_by String
ci_sys_created_on Datetime
ci_sys_domain String
ci_sys_domain_path String
ci_sys_mod_count Int
ci_sys_tags String
ci_sys_updated_by String
ci_sys_updated_on Datetime
ci_unverified Bool
ci_vendor String
ci_vendor_link String
ci_warranty_expiration Date

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8479