Power BI Connector for ServiceNow

Build 25.0.9454

cmdb_task_chg

Links Configuration Management Database (CMDB) tasks to related change requests to track dependencies and assess impact.

Columns

Name Type References Description
task_sys_id String Lists the system identifier (sys_id) that uniquely identifies the task record in the CMDB change log.
task_applied Bool Indicates whether the task has been applied successfully to the affected Configuration Item (CI).
task_applied_date Datetime Specifies the date and time when the task was applied to the CI.
task_ci_item String References the CI associated with the change task record.
task_ci_item_link String Provides a hyperlink to the CI record related to the change task.
task_manual_proposed_change Bool Indicates whether the proposed change was created manually rather than through an automated process.
task_sys_created_by String Lists the user or process that created the task record.
task_sys_created_on Datetime Displays the date and time when the task record was created.
task_sys_mod_count Int Tracks the number of times the task record has been modified.
task_sys_tags String Lists system tags associated with the task record for classification or reporting.
task_sys_updated_by String Identifies the user or process that last updated the task record.
task_sys_updated_on Datetime Shows the date and time when the task record was last updated.
task_task String References the parent task or workflow element related to this change task.
task_task_link String Provides a hyperlink to the parent task or workflow record.
task_xml String Stores the XML data associated with the change task, if applicable.
chg_sys_id String Lists the sys_id that uniquely identifies the change request associated with this record.
chg_active Bool Indicates whether the change request is currently active.
chg_activity_due Datetime Specifies the date and time when the next scheduled activity for the change request is due.
chg_additional_assignee_list String Lists additional users assigned to collaborate on the change request.
chg_approval String Shows the current approval status of the change request.
chg_approval_history String Contains the approval history log for the change request.
chg_approval_set Datetime Specifies the date and time when the approval process was initiated for the change request.
chg_assigned_to String Identifies the user assigned to complete the change request.
chg_assigned_to_link String Provides a hyperlink to the assigned user's record.
chg_assignment_group String Lists the group responsible for managing or executing the change request.
chg_assignment_group_link String Provides a hyperlink to the assignment group record.
chg_backout_plan String Describes the plan to revert changes if the change implementation fails.
chg_business_duration Long Tracks the total business duration of the change request, excluding non-working hours.
chg_business_service String References the business service affected by the change.
chg_business_service_link String Provides a hyperlink to the related business service record.
chg_cab_date Date Specifies the date when the change was reviewed by the Change Advisory Board (CAB).
chg_cab_delegate String Lists the delegate authorized to represent the CAB during the review process.
chg_cab_delegate_link String Provides a hyperlink to the delegate's record in the CAB review.
chg_cab_recommendation String Stores the recommendation provided by the CAB for the change request.
chg_cab_required Bool Indicates whether CAB review is mandatory for this change request.
chg_calendar_duration Long Tracks the total calendar time from the start to completion of the change request.
chg_category String Specifies the category of the change request, such as standard, normal, or emergency.
chg_change_plan String Describes the detailed plan for executing the change.
chg_close_code String Lists the closure reason code used when finalizing the change request.
chg_close_notes String Contains notes or remarks entered at the time of change closure.
chg_closed_at Datetime Specifies the date and time when the change request was closed.
chg_closed_by String Lists the user who performed the final closure of the change request.
chg_closed_by_link String Provides a hyperlink to the record of the user who closed the change request.
chg_cmdb_ci String References the CI affected by the change request.
chg_cmdb_ci_link String Provides a hyperlink to the CI record associated with the change request.
chg_comments String Stores general comments added during the lifecycle of the change request.
chg_comments_and_work_notes String Combines user comments and work notes related to the change request for audit purposes.
chg_company String Specifies the company associated with the change request.
chg_company_link String Provides a hyperlink to the company record in ServiceNow.
chg_conflict_last_run Datetime Displays the last date and time when the system ran a conflict detection check for the change request.
chg_conflict_status String Indicates whether any scheduling or dependency conflicts were found in the last conflict check.
chg_contact_type String Specifies how the change request was initiated, such as by email, phone, or self-service portal.
chg_correlation_display String Displays a readable reference used to correlate the change request with other records.
chg_correlation_id String Stores the correlation identifier used to link the change request with related system entries.
chg_delivery_plan String References the delivery plan outlining related implementation tasks.
chg_delivery_plan_link String Provides a hyperlink to the delivery plan record.
chg_delivery_task String References the delivery task associated with the change request.
chg_delivery_task_link String Provides a hyperlink to the delivery task record.
chg_description String Contains a detailed description of the change request, outlining its purpose and scope.
chg_due_date Datetime Indicates the date and time by which the change request is expected to be completed.
chg_end_date Datetime Specifies the date and time when the change implementation phase ended.
chg_escalation Int Displays the escalation level of the change request within the workflow.
chg_expected_start Datetime Specifies the planned start date and time for the change implementation.
chg_follow_up Datetime Indicates the date and time when a follow-up action or review is scheduled.
chg_group_list String Lists the groups involved in or notified about the change request.
chg_impact Int Rates the impact of the change request on business services using a predefined scale.
chg_implementation_plan String Details the steps required to implement the change successfully.
chg_justification String Explains the reasoning or business justification for the requested change.
chg_knowledge Bool Indicates whether the change request has been documented in the organization's Knowledge Base.
chg_location String Specifies the location associated with the change request.
chg_location_link String Provides a hyperlink to the location record.
chg_made_sla Bool Indicates whether the change request met its associated Service Level Agreement (SLA).
chg_number String Lists the unique identifier automatically generated for the change request.
chg_on_hold Bool Indicates whether the change request is currently on hold.
chg_on_hold_reason String Describes the reason why the change request has been placed on hold.
chg_on_hold_task String References the task causing the change request to be placed on hold.
chg_opened_at Datetime Displays the date and time when the change request was first opened.
chg_opened_by String Lists the user who initially created the change request.
chg_opened_by_link String Provides a hyperlink to the record of the user who opened the change request.
chg_order Int Displays the order in which this change request is processed relative to others.
chg_outside_maintenance_schedule Bool Indicates whether the change request was scheduled outside of the approved maintenance window.
chg_parent String References the parent record, if the change request is part of a larger change.
chg_parent_link String Provides a hyperlink to the parent change record.
chg_phase String Specifies the current phase of the change process, such as planning or implementation.
chg_phase_state String Describes the current substate or progress within the phase of the change.
chg_priority Int Displays the assigned priority of the change request, based on urgency and impact.
chg_production_system Bool Indicates whether the change affects a production system.
chg_reason String Provides an explanation of why the change is required.
chg_reassignment_count Int Tracks how many times the change request has been reassigned to different users or groups.
chg_rejection_goto String Specifies the next step or action if the change request is rejected.
chg_rejection_goto_link String Provides a hyperlink to the related record that defines rejection handling.
chg_requested_by String Lists the user who formally requested the change.
chg_requested_by_date Datetime Displays the date and time when the change was requested.
chg_requested_by_link String Provides a hyperlink to the record of the user who requested the change.
chg_review_comments String Contains comments or feedback provided during the review stage of the change request.
chg_review_date Date Specifies the date when the change request was reviewed.
chg_review_status Int Indicates the numeric status code representing the outcome of the change review.
chg_risk Int Rates the level of risk associated with the change request using a predefined scale.
chg_risk_impact_analysis String Contains the documented risk and impact analysis performed before change implementation.
chg_route_reason Int Specifies the numeric reason code used for routing the change request within workflow automation.
chg_scope Int Indicates the scope of the change, such as local, departmental, or enterprise-wide.
chg_service_offering String References the service offering impacted by the change request.
chg_service_offering_link String Provides a hyperlink to the impacted service offering record.
chg_short_description String Provides a brief summary of the change request.
chg_sla_due Datetime Displays the date and time when the SLA for the change is due.
chg_start_date Datetime Specifies the date and time when work on the change request began.
chg_state Int Indicates the current numeric state of the change request, such as new, in progress, or closed.
chg_std_change_producer_version String Lists the version of the standard change producer used to create the change request.
chg_std_change_producer_version_link String Provides a hyperlink to the version record of the standard change producer.
chg_sys_class_name String Specifies the system class name used to define the type of change request record.
chg_sys_created_by String Lists the user or process that created the change request record.
chg_sys_created_on Datetime Displays the date and time when the change request record was created.
chg_sys_domain String Specifies the domain to which the change request belongs.
chg_sys_domain_path String Shows the hierarchical domain path for the change request record.
chg_sys_mod_count Int Tracks the number of times the change request record has been modified.
chg_sys_tags String Lists any system tags applied to the change request record.
chg_sys_updated_by String Lists the user or process that last updated the change request record.
chg_sys_updated_on Datetime Displays the date and time when the change request record was last updated.
chg_task_effective_number String Shows the effective task number linked to the change request.
chg_test_plan String Describes the plan for testing after change implementation to ensure functionality.
chg_time_worked String Tracks the total time spent working on the change request.
chg_type String Specifies the type of change, such as standard, normal, or emergency.
chg_u_comments String Lists any user comments associated with the change request.
chg_u_some_test_field String Contains a test field used for internal or development purposes.
chg_unauthorized Bool Indicates whether the change was unauthorized or performed without approval.
chg_universal_request String References the universal request record associated with this change.
chg_universal_request_link String Provides a hyperlink to the related universal request record.
chg_upon_approval String Defines the next action to perform once the change request is approved.
chg_upon_reject String Defines the next action to perform if the change request is rejected.
chg_urgency Int Indicates the urgency level of the change request, used in priority calculation.
chg_user_input String Stores any user input provided during change request creation or processing.
chg_variables String Lists variables or custom parameters associated with the change request.
chg_watch_list String Lists users who receive notifications or updates about the change request.
chg_wf_activity String References the workflow activity record associated with the change request.
chg_wf_activity_link String Provides a hyperlink to the workflow activity record associated with the change.
chg_work_end Datetime Displays the date and time when work on the change request was completed.
chg_work_notes String Contains internal work notes added by team members handling the change.
chg_work_notes_list String Lists all work notes linked to the change request in chronological order.
chg_work_start Datetime Displays the date and time when work on the change request began.
ci_sys_id String Lists the sys_id that uniquely identifies the CI record in the CMDB.
ci_asset String References the asset record linked to this CI.
ci_asset_link String Provides a hyperlink to the related asset record.
ci_asset_tag String Shows the asset tag assigned to the CI for inventory tracking purposes.
ci_assigned Datetime Displays the date and time when the CI was assigned to a user or department.
ci_assigned_to String Lists the user or entity currently responsible for the CI.
ci_assigned_to_link String Provides a hyperlink to the record of the user assigned to the CI.
ci_assignment_group String Specifies the group responsible for managing or maintaining the CI.
ci_assignment_group_link String Provides a hyperlink to the assignment group record for the CI.
ci_attestation_score Int Displays the attestation score representing the level of data accuracy or compliance for the CI.
ci_attested Bool Indicates whether the CI has been reviewed and attested for accuracy.
ci_attested_by String Lists the user who attested the CI.
ci_attested_by_link String Provides a hyperlink to the record of the user who performed the attestation.
ci_attested_date Datetime Specifies the date and time when the CI was attested.
ci_attributes String Lists additional attributes or metadata describing the CI.
ci_can_print Bool Indicates whether the CI has printing capabilities, if applicable.
ci_category String Specifies the category of the CI, such as hardware, software, or service.
ci_change_control String References the change control policy that governs modifications to the CI.
ci_change_control_link String Provides a hyperlink to the change control policy record.
ci_checked_in Datetime Displays the date and time when the CI was checked in after use or maintenance.
ci_checked_out Datetime Displays the date and time when the CI was checked out for use, testing, or maintenance.
ci_comments String Stores general comments related to the CI record.
ci_company String Specifies the company or organization associated with the CI.
ci_company_link String Provides a hyperlink to the company record linked to the CI.
ci_correlation_id String Lists the correlation identifier used to link the CI with related records or systems.
ci_cost Float Shows the financial cost associated with the CI, such as purchase or maintenance cost.
ci_cost_cc String Specifies the cost center code used for financial tracking of the CI.
ci_cost_center String References the cost center responsible for the financial allocation of the CI.
ci_cost_center_link String Provides a hyperlink to the cost center record associated with the CI.
ci_delivery_date Datetime Displays the date and time when the CI was delivered to the organization.
ci_department String Specifies the department responsible for or using the CI.
ci_department_link String Provides a hyperlink to the department record related to the CI.
ci_discovery_source String Lists the discovery source that provided the CI data, such as a monitoring or import process.
ci_dns_domain String Specifies the DNS domain associated with the CI if applicable.
ci_due Datetime Indicates the due date for maintenance, renewal, or other scheduled activity related to the CI.
ci_due_in String Specifies the remaining time before the CI's due date, shown as a relative value.
ci_duplicate_of String References another CI record that this one duplicates.
ci_duplicate_of_link String Provides a hyperlink to the duplicated CI record.
ci_environment String Specifies the operational environment of the CI, such as production, staging, or development.
ci_fault_count Int Tracks the number of faults or incidents associated with the CI.
ci_first_discovered Datetime Shows the date and time when the CI was first discovered by the discovery system.
ci_fqdn String Lists the Fully Qualified Domain Name (FQDN) associated with the CI, if applicable.
ci_gl_account String Specifies the general ledger account used for financial tracking of the CI.
ci_install_date Datetime Displays the date and time when the CI was installed in the environment.
ci_install_status Int Indicates the current installation status of the CI, such as installed, pending, or retired.
ci_invoice_number String Lists the invoice number associated with the CI purchase.
ci_ip_address String Displays the IP address assigned to the CI, if applicable.
ci_justification String Contains the justification or reason for maintaining the CI in the CMDB.
ci_last_discovered Datetime Shows the most recent date and time when the CI was discovered or verified by the discovery system.
ci_lease_id String Lists the lease identifier associated with the CI, if it is under a lease agreement.
ci_life_cycle_stage String Specifies the current life cycle stage of the CI, such as in design, in use, or retired.
ci_life_cycle_stage_link String Provides a hyperlink to the record defining the life cycle stage of the CI.
ci_life_cycle_stage_status String Indicates the current status within the CI's life cycle stage, such as active or pending review.
ci_life_cycle_stage_status_link String Provides a hyperlink to the record defining the life cycle stage status.
ci_location String Specifies the physical or logical location of the CI.
ci_location_link String Provides a hyperlink to the location record associated with the CI.
ci_mac_address String Lists the Media Access Control (MAC) address assigned to the CI if it is a networked device.
ci_maintenance_schedule String References the maintenance schedule associated with the CI.
ci_maintenance_schedule_link String Provides a hyperlink to the maintenance schedule record.
ci_managed_by String Lists the user or entity responsible for managing the CI.
ci_managed_by_group String Specifies the group responsible for managing or overseeing the CI.
ci_managed_by_group_link String Provides a hyperlink to the management group record associated with the CI.
ci_managed_by_link String Provides a hyperlink to the user record of the person managing the CI.
ci_manufacturer String Specifies the manufacturer of the CI.
ci_manufacturer_link String Provides a hyperlink to the manufacturer's record.
ci_model_id String References the model identifier for the CI, defining its type or specification.
ci_model_id_link String Provides a hyperlink to the CI model record.
ci_model_number String Lists the model number assigned by the manufacturer.
ci_monitor Bool Indicates whether the CI is currently being monitored by a system or tool.
ci_name String Lists the name assigned to the CI for identification in the CMDB.
ci_operational_status Int Indicates the operational status of the CI, such as active, inactive, or decommissioned.
ci_order_date Datetime Displays the date and time when the CI was ordered.
ci_owned_by String Lists the user or department that owns the CI.
ci_owned_by_link String Provides a hyperlink to the record of the owner of the CI.
ci_po_number String Lists the Purchase Order (PO) number associated with the CI.
ci_purchase_date Date Specifies the date when the CI was purchased.
ci_schedule String References the schedule governing maintenance or operational routines for the CI.
ci_schedule_link String Provides a hyperlink to the schedule record.
ci_serial_number String Lists the serial number assigned to the CI by the manufacturer.
ci_short_description String Provides a brief description summarizing the purpose or function of the CI.
ci_skip_sync Bool Indicates whether synchronization with the discovery or update process is skipped for this CI.
ci_start_date Datetime Specifies the date and time when the CI became operational or active in the environment.
ci_subcategory String Defines the subcategory of the CI, providing further classification within its main category.
ci_support_group String Lists the support group responsible for providing assistance or maintenance for the CI.
ci_support_group_link String Provides a hyperlink to the support group record.
ci_supported_by String References the user or entity providing technical support for the CI.
ci_supported_by_link String Provides a hyperlink to the support provider record.
ci_sys_class_name String Specifies the system class name defining the CI record type within the CMDB hierarchy.
ci_sys_class_path String Displays the system path that represents the CI's class hierarchy in the CMDB.
ci_sys_created_by String Lists the user or process that created the CI record.
ci_sys_created_on Datetime Displays the date and time when the CI record was created.
ci_sys_domain String Specifies the domain to which the CI record belongs.
ci_sys_domain_path String Shows the hierarchical domain path for the CI record.
ci_sys_mod_count Int Tracks the number of modifications made to the CI record.
ci_sys_tags String Lists any system tags applied to the CI record for categorization or tracking.
ci_sys_updated_by String Lists the user or process that last updated the CI record.
ci_sys_updated_on Datetime Displays the date and time when the CI record was last updated.
ci_unverified Bool Indicates whether the CI has not yet been verified in the CMDB.
ci_vendor String Specifies the vendor that supplied the CI.
ci_vendor_link String Provides a hyperlink to the vendor record.
ci_warranty_expiration Date Lists the date when the CI's warranty expires.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9454