Power BI Connector for ServiceNow

Build 25.0.9454

kb_feedback_task_metric

Summarizes feedback metrics for Knowledge Base (KB) tasks, such as helpfulness ratings and response counts.

Columns

Name Type References Description
mi_sys_id String Provides the system identifier (sys_id) for the metric instance associated with the KB feedback task.
mi_business_duration Long Shows the total business time spent on the feedback task, calculated based on the assigned schedule.
mi_calculation_complete Bool Indicates whether the calculation of this metric instance has been fully completed.
mi_definition String References the definition record that describes how the metric is calculated.
mi_definition_link String Provides a direct link to the metric definition record in ServiceNow.
mi_duration Long Displays the total elapsed time for the metric in milliseconds.
mi_end Datetime Specifies the date and time when the metric measurement ended.
mi_field String Identifies the field on which the metric is based or measured.
mi_field_value String Displays the value of the field being measured in the metric instance.
mi_id String Provides the internal identifier for tracking the metric instance.
mi_start Datetime Specifies the date and time when the metric measurement started.
mi_sys_created_by String Indicates the user who 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 the number of times the metric instance record has been modified.
mi_sys_tags String Contains any tags applied to the metric instance for categorization or reporting.
mi_sys_updated_by String Indicates the user who last updated the metric instance record.
mi_sys_updated_on Datetime Displays the date and time of the last update to the metric instance.
mi_table String Specifies the database table associated with the metric instance.
mi_value String Shows the result or measured value captured by the metric instance.
kft_sys_id String Provides the sys_id for the KB feedback task.
kft_active Bool Indicates whether the feedback task is currently active and open for processing.
kft_activity_due Datetime Displays the date and time when the next activity or action on the feedback task is due.
kft_additional_assignee_list String Lists additional users assigned to assist with resolving or reviewing the feedback task.
kft_approval String Specifies the current approval status of the feedback task, such as pending, approved, or rejected.
kft_approval_history String Contains a record of all approval actions performed on the feedback task.
kft_approval_set Datetime Shows the date and time when the approval status of the feedback task was last updated.
kft_assigned_to String Indicates the user currently assigned to handle the feedback task.
kft_assigned_to_link String Provides a link to the profile of the user assigned to the feedback task.
kft_assignment_group String Specifies the group responsible for completing or reviewing the feedback task.
kft_assignment_group_link String Provides a link to the assignment group record.
kft_business_duration Long Shows the total business time spent working on the feedback task, excluding non-business hours.
kft_business_service String References the business service associated with the feedback task, if applicable.
kft_business_service_link String Provides a link to the related business service record.
kft_calendar_duration Long Displays the total elapsed calendar time spent on the feedback task.
kft_close_notes String Contains notes entered when the feedback task was closed, explaining the resolution or actions taken.
kft_closed_at Datetime Shows the date and time when the feedback task was closed.
kft_closed_by String Indicates the user who closed the feedback task.
kft_closed_by_link String Provides a link to the profile of the user who closed the task.
kft_cmdb_ci String References the Configuration Item (CI) related to the feedback task, if relevant.
kft_cmdb_ci_link String Provides a link to the related Configuration Item record.
kft_comments String Contains comments or updates added to the feedback task by users.
kft_comments_and_work_notes String Combines user comments and internal work notes for complete task tracking.
kft_company String Specifies the company associated with the feedback task.
kft_company_link String Provides a link to the company record related to the task.
kft_contact_type String Indicates how the feedback was received, such as via email, portal, or phone.
kft_correlation_display String Displays information about related records, useful for identifying linked feedback or tickets.
kft_correlation_id String Provides a unique identifier used to correlate related records or processes.
kft_delivery_plan String References the delivery plan that governs task fulfillment or tracking.
kft_delivery_plan_link String Provides a link to the associated delivery plan record.
kft_delivery_task String References the specific delivery task linked to the feedback activity.
kft_delivery_task_link String Provides a link to the related delivery task record.
kft_description String Gives a detailed explanation of the feedback task's purpose and context.
kft_due_date Datetime Displays the date and time by which the feedback task must be completed.
kft_escalation Int Indicates the escalation level or priority assigned to the feedback task.
kft_expected_start Datetime Specifies the expected date and time when work on the feedback task should begin.
kft_feedback String References the feedback record associated with this task.
kft_feedback_link String Provides a link to the related feedback record.
kft_feedback_task_type String Defines the type of feedback task, such as review, correction, or follow-up.
kft_follow_up Datetime Specifies the date and time for follow-up actions on the feedback task.
kft_group_list String Lists additional groups that are involved in managing the feedback task.
kft_impact Int Indicates the business impact level of the feedback task, such as low, medium, or high.
kft_knowledge Bool Specifies whether the feedback task is linked to a KB article.
kft_location String Specifies the physical or virtual location associated with the feedback task.
kft_location_link String Provides a link to the location record in ServiceNow.
kft_made_sla Bool Indicates whether the feedback task was completed within the defined Service Level Agreement (SLA) timeframe.
kft_number String Displays the unique number assigned to the feedback task for tracking purposes.
kft_opened_at Datetime Shows the date and time when the feedback task was created or opened.
kft_opened_by String Indicates the user who created or initiated the feedback task.
kft_opened_by_link String Provides a link to the profile of the user who opened the feedback task.
kft_order Int Defines the order or sequence in which the feedback task is processed relative to others.
kft_outcome String Specifies the result or resolution of the feedback task.
kft_outcome_link String Provides a link to the detailed outcome record.
kft_parent String References the parent task or record related to the feedback task.
kft_parent_link String Provides a link to the parent task record.
kft_priority Int Indicates the priority level assigned to the feedback task.
kft_reassignment_count Int Tracks how many times the feedback task has been reassigned to a different user or group.
kft_rejection_goto String Specifies the record or process the task should redirect to if rejected.
kft_rejection_goto_link String Provides a link to the record or workflow step triggered upon rejection.
kft_resolution_code String Specifies the resolution category or code that classifies how the task was resolved.
kft_route_reason Int Indicates the reason for routing or reassigning the task.
kft_service_offering String References the specific service offering associated with the feedback task.
kft_service_offering_link String Provides a link to the related service offering record.
kft_short_description String Provides a concise summary describing the feedback task.
kft_sla_due Datetime Displays the date and time when the task's SLA is set to expire.
kft_state Int Indicates the current state of the feedback task, such as open, in progress, or closed.
kft_sys_class_name String Specifies the system class that defines the record type of the feedback task.
kft_sys_created_by String Identifies the user who created the feedback task record.
kft_sys_created_on Datetime Shows the date and time when the feedback task was created.
kft_sys_domain String Specifies the domain to which the feedback task belongs in multi-domain environments.
kft_sys_domain_path String Defines the domain hierarchy path for the feedback task record.
kft_sys_mod_count Int Tracks the total number of modifications made to the feedback task record.
kft_sys_tags String Lists tags applied to the feedback task for easier classification and reporting.
kft_sys_updated_by String Indicates the user who last updated the feedback task.
kft_sys_updated_on Datetime Displays the date and time when the feedback task was last updated.
kft_task_effective_number String Shows the task number used for process tracking and reporting.
kft_time_worked String Records the total time spent working on the feedback task.
kft_u_comments String Contains additional comments entered by users for internal or review purposes.
kft_u_some_test_field String Represents a custom field used for testing or supplementary task data.
kft_universal_request String References the universal request record linked to the feedback task, if applicable.
kft_universal_request_link String Provides a link to the associated universal request record.
kft_upon_approval String Defines the action taken automatically once the feedback task receives approval.
kft_upon_reject String Defines the action triggered if the feedback task is rejected.
kft_urgency Int Specifies how urgently the feedback task needs to be addressed.
kft_user_input String Captures any input or response provided by the user submitting the feedback.
kft_variables String Lists variables or parameters associated with the feedback task for workflow processing.
kft_watch_list String Lists users who are notified of updates to the feedback task.
kft_wf_activity String References the workflow activity currently associated with the task.
kft_wf_activity_link String Provides a link to the active workflow record managing the feedback task.
kft_work_end Datetime Displays the date and time when the most recent work session ended.
kft_work_notes String Contains internal work notes detailing actions taken on the feedback task.
kft_work_notes_list String Lists all work notes associated with the feedback task in chronological order.
kft_work_start Datetime Displays the date and time when the most recent work session began.
md_sys_id String Provides the sys_id for the metric definition associated with the task.
md_active Bool Indicates whether the metric definition is currently active and being applied to records.
md_description String Describes the purpose and scope of the metric definition.
md_field String Specifies the field the metric definition applies to for tracking performance or timing.
md_name String Displays the name of the metric definition as it appears in ServiceNow.
md_number String Provides a unique number assigned to the metric definition.
md_order Int Defines the display order of this metric among other definitions.
md_script String Contains the script used to calculate or customize the metric behavior.
md_sys_class_name String Specifies the system class for the metric definition record.
md_sys_created_by String Indicates the user who created the metric definition record.
md_sys_created_on Datetime Shows the date and time when the metric definition record was created.
md_sys_mod_count Int Tracks how many times the metric definition record has been modified.
md_sys_name String Specifies the system-generated name for the metric definition.
md_sys_package String References the update set or package containing the metric definition.
md_sys_package_link String Provides a link to the related update set or package record.
md_sys_policy String Defines the system policy governing updates to this metric definition.
md_sys_scope String Specifies the application scope that owns the metric definition.
md_sys_scope_link String Provides a link to the application scope record.
md_sys_tags String Lists tags used to categorize the metric definition.
md_sys_update_name String Specifies the update name associated with the metric definition.
md_sys_updated_by String Indicates the user who last updated the metric definition record.
md_sys_updated_on Datetime Displays the date and time of the most recent update to the metric definition.
md_table String Defines the database table to which this metric applies.
md_timeline Bool Indicates whether the metric appears on the task's timeline visualization.
md_type String Specifies the metric type, such as duration, count, or state change.

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