Power BI Connector for ServiceNow

Build 25.0.9454

change_request_metric

Aggregates performance metrics for change requests, such as resolution times and Service Level Agreement (SLA) compliance.

Columns

Name Type References Description
md_sys_id String Defines the system identifier (sys_id) that uniquely identifies the metric definition record in ServiceNow.
md_active Bool Indicates whether the metric definition is currently active and being used to collect data.
md_description String Provides a detailed explanation of what the metric measures and how it is calculated.
md_field String Specifies the database field that the metric definition monitors for changes or values.
md_name String Lists the name assigned to the metric definition for easy identification.
md_number String Displays the unique number associated with the metric definition record.
md_order Int Specifies the order in which the metric definition is evaluated or processed.
md_script String Contains a script used to define custom logic for metric calculation or evaluation.
md_sys_class_name String Identifies the system class name of the metric definition record within the ServiceNow schema.
md_sys_created_by String Shows the user or system process that originally created the metric definition.
md_sys_created_on Datetime Displays the date and time when the metric definition record was created.
md_sys_mod_count Int Tracks the number of times the metric definition record has been modified.
md_sys_name String Lists the internal system name used to identify the metric definition in ServiceNow.
md_sys_package String Specifies the package that contains the metric definition, grouping it with related components.
md_sys_package_link String Provides the hyperlink reference to the package record containing the metric definition.
md_sys_policy String References the system policy governing the behavior or security of the metric definition.
md_sys_scope String Defines the application scope to which the metric definition belongs.
md_sys_scope_link String Provides the hyperlink reference to the application scope record.
md_sys_tags String Lists system tags assigned to the metric definition for classification or search filtering.
md_sys_update_name String Displays the name of the update set that last modified the metric definition.
md_sys_updated_by String Shows the user or process that last updated the metric definition record.
md_sys_updated_on Datetime Displays the date and time when the metric definition was last updated.
md_table String Specifies the name of the table to which the metric definition applies.
md_timeline Bool Indicates whether the metric definition includes a timeline for tracking historical performance.
md_type String Specifies the type of metric, such as duration-based or event-based.
mi_sys_id String Defines the sys_id that uniquely identifies the metric instance record in ServiceNow.
mi_business_duration Long Tracks the business duration measured by the metric, excluding non-working hours.
mi_calculation_complete Bool Indicates whether the metric calculation for the record is complete.
mi_definition String Specifies the definition or rule used to calculate the metric instance.
mi_definition_link String Provides the hyperlink reference to the metric definition record associated with the instance.
mi_duration Long Records the total elapsed duration measured for the metric instance, including both business and non-business hours.
mi_end Datetime Specifies the date and time when the metric measurement ended.
mi_field String Lists the database field used as the source for the metric value.
mi_field_value String Displays the actual value of the monitored field at the time the metric was evaluated.
mi_id String Stores a unique identifier assigned to the metric instance for internal reference.
mi_start Datetime Lists the date and time when the metric measurement began.
mi_sys_created_by String Shows the user or system process that created the metric instance record.
mi_sys_created_on Datetime Displays the date and time when the metric instance record was created.
mi_sys_mod_count Int Tracks how many times the metric instance record has been updated.
mi_sys_tags String Lists system tags applied to the metric instance for classification or reporting.
mi_sys_updated_by String Shows the user or process that last modified the metric instance record.
mi_sys_updated_on Datetime Displays the date and time when the metric instance record was last updated.
mi_table String Specifies the database table where the metric instance record resides.
mi_value String Lists the final calculated value of the metric instance.
chg_sys_id String Defines the sys_id of the associated change request linked to this metric.
chg_active Bool Indicates whether the linked change request is currently active.
chg_activity_due Datetime Specifies the due date and time for the next workflow activity in the change request.
chg_additional_assignee_list String Lists additional users or groups assisting with the execution of the change request.
chg_approval String Displays the approval status of the change request, such as requested, approved, or rejected.
chg_approval_history String Provides a historical record of all approval actions for the change request.
chg_approval_set Datetime Lists the date and time when the approval status of the change request was last updated.
chg_assigned_to String Identifies the user assigned to handle the change request.
chg_assigned_to_link String Provides the hyperlink reference to the user record assigned to the change request.
chg_assignment_group String Specifies the group responsible for executing or reviewing the change.
chg_assignment_group_link String Provides the hyperlink reference to the group record associated with the change.
chg_backout_plan String Describes the contingency plan for reverting changes if the implementation fails.
chg_business_duration Long Tracks the total business duration of the change request, excluding non-working hours.
chg_business_service String Lists the business service affected or improved by the change request.
chg_business_service_link String Provides the hyperlink reference to the business service record in ServiceNow.
chg_cab_date Date Specifies the scheduled date for the Change Advisory Board (CAB) review.
chg_cab_delegate String Lists the delegate assigned to represent a CAB member during review.
chg_cab_delegate_link String Provides the hyperlink reference to the delegate record associated with the CAB process.
chg_cab_recommendation String Captures the recommendations or notes provided by the CAB following their review of the change.
chg_cab_required Bool Indicates whether the change requires review or approval from the CAB.
chg_calendar_duration Long Records the total elapsed duration of the change request, including both business and non-business hours.
chg_category String Classifies the change request into a category, such as software, hardware, or infrastructure.
chg_change_plan String Outlines the detailed steps or strategy for executing the change.
chg_close_code String Lists the closure code describing how the change was completed, such as successful or failed.
chg_close_notes String Provides notes entered when closing the change, including implementation results and lessons learned.
chg_closed_at Datetime Displays the date and time when the change request was officially closed.
chg_closed_by String Lists the user who closed the change request after completion.
chg_closed_by_link String Provides the hyperlink reference to the user record who performed the closure.
chg_cmdb_ci String References the Configuration Item (CI) from the Configuration Management Database (CMDB) impacted by the change.
chg_cmdb_ci_link String Provides the hyperlink reference to the CMDB record representing the affected Configuration Item.
chg_comments String Stores user-entered comments describing decisions, updates, or collaboration notes for the change.
chg_comments_and_work_notes String Combines user comments and work notes into a unified log for audit tracking.
chg_company String Lists the company or customer organization associated with the change request.
chg_company_link String Provides the hyperlink reference to the company record in ServiceNow.
chg_conflict_last_run Datetime Displays the date and time when the system last performed a conflict detection check for overlapping changes.
chg_conflict_status String Indicates the result of the most recent conflict check, such as no conflicts or conflict detected.
chg_contact_type String Specifies the communication channel used to submit the change request, such as email, portal, or phone.
chg_correlation_display String Displays a readable reference linking the change to related records such as incidents or problems.
chg_correlation_id String Stores the correlation identifier connecting the change request to related records in other systems or modules.
chg_delivery_plan String Specifies the delivery plan guiding the change's implementation and deployment activities.
chg_delivery_plan_link String Provides the hyperlink reference to the delivery plan record.
chg_delivery_task String References the delivery task associated with the execution of the change.
chg_delivery_task_link String Provides the hyperlink reference to the delivery task record linked to the change request.
chg_description String Provides a detailed description of the change request, including its purpose, scope, and implementation details.
chg_due_date Datetime Lists the date and time when the change is expected to be completed.
chg_end_date Datetime Displays the date and time when the change process concludes.
chg_escalation Int Indicates the escalation level of the change request based on urgency or business impact.
chg_expected_start Datetime Specifies the date and time when the change implementation is expected to begin.
chg_follow_up Datetime Lists the scheduled date for post-implementation review or verification of the change.
chg_group_list String Lists the user groups involved in reviewing, approving, or executing the change request.
chg_impact Int Specifies the impact level of the change on services or users, typically represented numerically (for example, 1 = high or 3 = low).
chg_implementation_plan String Describes the plan detailing how the change will be implemented.
chg_justification String Explains the business or technical justification for implementing the change request.
chg_knowledge Bool Indicates whether the change request is linked to a Knowledge Base (KB) article for reference or documentation.
chg_location String Lists the physical or organizational location associated with the change request.
chg_location_link String Provides the hyperlink reference to the location record.
chg_made_sla Bool Indicates whether the SLA objectives for the change request were met.
chg_number String Displays the unique number assigned to the change request for identification.
chg_on_hold Bool Indicates whether the change request is currently on hold and awaiting further action or information.
chg_on_hold_reason String Specifies the reason why the change request has been placed on hold, such as dependency issues or pending approval.
chg_on_hold_task String References the specific task or workflow step that caused 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 Identifies the user who created or initiated the change request.
chg_opened_by_link String Provides the hyperlink reference to the user record who opened the change request.
chg_order Int Specifies the order of execution or sequencing for the change within a workflow or project.
chg_outside_maintenance_schedule Bool Indicates whether the change is scheduled to occur outside of approved maintenance windows.
chg_parent String References the parent change request or record associated with the current change.
chg_parent_link String Provides the hyperlink reference to the parent change record in ServiceNow.
chg_phase String Specifies the current phase of the change lifecycle, such as planning, testing, or implementation.
chg_phase_state String Lists the detailed state of the change within the current phase, such as awaiting approval or completed.
chg_priority Int Specifies the priority level of the change request, typically derived from impact and urgency.
chg_production_system Bool Indicates whether the change impacts a production environment or live system.
chg_reason String Explains the reason for initiating the change request, such as compliance, maintenance, or performance improvement.
chg_reassignment_count Int Tracks how many times the change request has been reassigned between users or groups.
chg_rejection_goto String Specifies the workflow state to transition to automatically when the change request is rejected.
chg_rejection_goto_link String Provides the hyperlink reference to the rejection transition record or target state.
chg_requested_by String Identifies the user who requested or sponsored the change.
chg_requested_by_date Datetime Displays the date and time when the change request was formally submitted.
chg_requested_by_link String Provides the hyperlink reference to the user record associated with the change request submission.
chg_review_comments String Lists the comments provided by reviewers during the change review process.
chg_review_date Date Specifies the most recent date when the change request was reviewed by approvers or the CAB.
chg_review_status Int Indicates the numeric code representing the review status, such as pending, approved, or rejected.
chg_risk Int Represents the numeric risk rating of the change request, where a higher value indicates greater risk.
chg_risk_impact_analysis String Documents the risk and impact analysis conducted before implementing the change.
chg_route_reason Int Specifies the routing reason code used in workflow transitions for the change request.
chg_scope Int Defines the scope of the change numerically, representing the breadth or number of affected systems.
chg_service_offering String Lists the specific service offering impacted by the change request.
chg_service_offering_link String Provides the hyperlink reference to the associated service offering record in ServiceNow.
chg_short_description String Provides a concise summary describing the purpose or intent of the change request.
chg_sla_due Datetime Displays the date and time by which the SLA commitment must be fulfilled.
chg_start_date Datetime Lists the date and time when the change implementation is scheduled to start.
chg_state Int Specifies the numeric code representing the current state of the change request, such as 1 = New or 3 = Approved.
chg_std_change_producer_version String Identifies the version of the standard change producer used to create the change record.
chg_std_change_producer_version_link String Provides the hyperlink reference to the standard change producer version record.
chg_sys_class_name String Identifies the system class name of the change request record in the ServiceNow schema.
chg_sys_created_by String Shows the user or process that originally created the change request record.
chg_sys_created_on Datetime Displays the date and time when the change request record was created in ServiceNow.
chg_sys_domain String Specifies the domain associated with the change request in a multi-domain configuration.
chg_sys_domain_path String Defines the hierarchical domain path representing the record's organizational placement.
chg_sys_mod_count Int Tracks how many times the change request record has been modified since its creation.
chg_sys_tags String Lists any system tags associated with the change request for categorization or reporting purposes.
chg_sys_updated_by String Shows the user or system 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 modified.
chg_task_effective_number String Lists the effective task number linked to the change request for tracking and reporting consistency.
chg_test_plan String Describes the testing plan used to validate the success of the change before deployment to production.
chg_time_worked String Tracks the total time logged by users while working on the change request.
chg_type String Specifies the type of change request, such as standard, emergency, or normal.
chg_u_comments String Stores custom comments or additional remarks added by users for extended tracking.
chg_u_some_test_field String Holds data for a custom test field used for evaluation or internal process testing.
chg_unauthorized Bool Indicates whether the change was performed without authorization or prior approval.
chg_universal_request String References a universal request record that relates to or triggered the change request.
chg_universal_request_link String Provides the hyperlink reference to the universal request record in ServiceNow.
chg_upon_approval String Specifies the automated workflow action executed upon approval of the change request.
chg_upon_reject String Defines the automated workflow action triggered when the change request is rejected.
chg_urgency Int Represents the urgency level of the change request numerically, where lower values indicate higher urgency.
chg_user_input String Stores custom user input or variable data submitted during the change request process.
chg_variables String Lists all variable values captured through dynamic forms associated with the change request.
chg_watch_list String Specifies the list of users or groups subscribed to receive notifications about updates to the change request.
chg_wf_activity String References the workflow activity record associated with the automation of the change.
chg_wf_activity_link String Provides the hyperlink reference to the workflow activity record that manages automation for the change.
chg_work_end Datetime Lists the date and time when work on the change implementation ended.
chg_work_notes String Stores work notes entered by users to document the change's progress, decisions, or issues.
chg_work_notes_list String Displays the full list of historical work notes added to the change request for auditing and tracking.
chg_work_start Datetime Lists the date and time when work on the change implementation began.

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