problem_metric
Summarizes metrics for problem records, including resolution times and recurring issue trends.
Columns
| Name | Type | References | Description |
| md_sys_id | String | Provides the system identifier (sys_id) for the problem metric definition record. | |
| md_active | Bool | Indicates whether the problem metric definition is active and currently in use. | |
| md_description | String | Describes the purpose or logic of the problem metric definition. | |
| md_field | String | Specifies the field used as the basis for the problem metric calculation. | |
| md_name | String | Displays the name assigned to the problem metric definition. | |
| md_number | String | Identifies the reference number associated with the problem metric definition. | |
| md_order | Int | Determines the order in which the problem metric definitions are executed or displayed. | |
| md_script | String | Contains the script logic used to define or calculate the problem metric. | |
| md_sys_class_name | String | Indicates the system class name defining the record type for the problem metric definition. | |
| md_sys_created_by | String | Identifies the user who created the problem metric definition record. | |
| md_sys_created_on | Datetime | Shows the date and time when the problem metric definition record was created. | |
| md_sys_mod_count | Int | Tracks how many times the problem metric definition record has been modified. | |
| md_sys_name | String | Specifies the system name of the problem metric definition as stored in ServiceNow. | |
| md_sys_package | String | Indicates the system package that contains the problem metric definition. | |
| md_sys_package_link | String | Provides a link to the related system package record. | |
| md_sys_policy | String | Defines the policy applied to the problem metric definition record. | |
| md_sys_scope | String | Indicates the application scope that the problem metric definition belongs to. | |
| md_sys_scope_link | String | Provides a link to the related application scope record. | |
| md_sys_tags | String | Lists tags associated with the problem metric definition for classification or reporting. | |
| md_sys_update_name | String | Displays the update name for version tracking and package management. | |
| md_sys_updated_by | String | Identifies the user who last updated the problem metric definition. | |
| md_sys_updated_on | Datetime | Shows the date and time when the problem metric definition record was last updated. | |
| md_table | String | Specifies the table associated with the problem metric definition. | |
| md_timeline | Bool | Indicates whether the metric appears on the problem's timeline. | |
| md_type | String | Defines the type of metric, such as duration-based or count-based. | |
| mi_sys_id | String | Provides the sys_id for the problem metric instance record. | |
| mi_business_duration | Long | Shows the business duration calculated for the metric, excluding non-business hours. | |
| mi_calculation_complete | Bool | Indicates whether the metric calculation for the problem record is complete. | |
| mi_definition | String | References the metric definition associated with the problem metric instance. | |
| mi_definition_link | String | Provides a link to the related metric definition record. | |
| mi_duration | Long | Displays the total duration of 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 calculation is based. | |
| mi_field_value | String | Displays the value of the field used in the metric calculation. | |
| mi_id | String | Stores the unique identifier for the metric instance. | |
| mi_start | Datetime | Specifies the date and time when the metric measurement started. | |
| mi_sys_created_by | String | Identifies the user who created the problem metric instance record. | |
| mi_sys_created_on | Datetime | Shows the date and time when the problem metric instance record was created. | |
| mi_sys_mod_count | Int | Tracks how many times the metric instance record has been modified. | |
| mi_sys_tags | String | Lists tags associated with the problem metric instance for filtering or analysis. | |
| mi_sys_updated_by | String | Indicates the user who last updated the problem metric instance record. | |
| mi_sys_updated_on | Datetime | Displays the date and time when the problem metric instance record was last updated. | |
| mi_table | String | Specifies the table to which the metric instance record belongs. | |
| mi_value | String | Shows the metric's calculated value based on the problem record data. | |
| prb_sys_id | String | Provides the sys_id for the problem record. | |
| prb_active | Bool | Indicates whether the problem record is active or closed. | |
| prb_activity_due | Datetime | Shows the date and time when the next activity for the problem is due. | |
| prb_additional_assignee_list | String | Lists additional users assigned to the problem record. | |
| prb_approval | String | Specifies the current approval status of the problem record. | |
| prb_approval_history | String | Displays the history of approvals for the problem record. | |
| prb_approval_set | Datetime | Indicates when the approval status was last set. | |
| prb_assigned_to | String | Identifies the user currently assigned to the problem. | |
| prb_assigned_to_link | String | Provides a link to the record of the user assigned to the problem. | |
| prb_assignment_group | String | Specifies the assignment group responsible for resolving the problem. | |
| prb_assignment_group_link | String | Provides a link to the related assignment group record. | |
| prb_business_duration | Long | Shows the total business duration of the problem from start to resolution. | |
| prb_business_service | String | References the business service affected by the problem. | |
| prb_business_service_link | String | Provides a link to the related business service record. | |
| prb_calendar_duration | Long | Displays the total elapsed time between the problem's creation and closure. | |
| prb_close_notes | String | Contains notes added when closing the problem record. | |
| prb_closed_at | Datetime | Shows the date and time when the problem record was closed. | |
| prb_closed_by | String | Identifies the user who closed the problem record. | |
| prb_closed_by_link | String | Provides a link to the user record of the person who closed the problem. | |
| prb_cmdb_ci | String | References the configuration item (CI) affected by the problem. | |
| prb_cmdb_ci_link | String | Provides a link to the related configuration item record. | |
| prb_comments | String | Stores general comments added to the problem record. | |
| prb_comments_and_work_notes | String | Combines user comments and work notes for full context. | |
| prb_company | String | Specifies the company associated with the problem record. | |
| prb_company_link | String | Provides a link to the related company record. | |
| prb_contact_type | String | Indicates how the problem was reported, such as phone or email. | |
| prb_correlation_display | String | Displays information used to correlate this problem with other records. | |
| prb_correlation_id | String | Contains a unique correlation identifier linking related problems. | |
| prb_delivery_plan | String | References the delivery plan associated with resolving the problem. | |
| prb_delivery_plan_link | String | Provides a link to the related delivery plan record. | |
| prb_delivery_task | String | Specifies the delivery task associated with the problem resolution. | |
| prb_delivery_task_link | String | Provides a link to the related delivery task record. | |
| prb_description | String | Contains a detailed description of the problem and its impact. | |
| prb_due_date | Datetime | Indicates the date and time when the problem resolution is due. | |
| prb_escalation | Int | Shows the escalation level assigned to the problem. | |
| prb_expected_start | Datetime | Specifies when work on the problem is expected to begin. | |
| prb_follow_up | Datetime | Indicates the follow-up date for monitoring problem progress. | |
| prb_group_list | String | Lists groups involved in the problem resolution process. | |
| prb_impact | Int | Rates the problem's impact on business operations. | |
| prb_knowledge | Bool | Indicates whether the problem record is marked for knowledge article creation. | |
| prb_known_error | Bool | Specifies whether the problem has been identified as a known error. | |
| prb_location | String | Identifies the location associated with the problem record. | |
| prb_location_link | String | Provides a link to the related location record. | |
| prb_made_sla | Bool | Indicates whether the problem met its defined Service Level Agreement (SLA). | |
| prb_major_problem | Bool | Specifies whether the problem is classified as a major problem. | |
| prb_number | String | Displays the unique number assigned to the problem record. | |
| prb_opened_at | Datetime | Shows the date and time when the problem record was created. | |
| prb_opened_by | String | Identifies the user who created the problem record. | |
| prb_opened_by_link | String | Provides a link to the user record of the problem's creator. | |
| prb_order | Int | Defines the problem's sequence or priority in workflows. | |
| prb_parent | String | References the parent problem, if this record is a child. | |
| prb_parent_link | String | Provides a link to the related parent problem record. | |
| prb_priority | Int | Specifies the priority level of the problem based on impact and urgency. | |
| prb_problem_state | Int | Indicates the current state of the problem, such as open or resolved. | |
| prb_reassignment_count | Int | Tracks the number of times the problem has been reassigned. | |
| prb_rejection_goto | String | Specifies the action or location to redirect to if approval is rejected. | |
| prb_rejection_goto_link | String | Provides a link to the related rejection handling record. | |
| prb_related_incidents | Int | Shows the number of incidents linked to this problem. | |
| prb_review_outcome | String | Summarizes the results of the post-resolution problem review. | |
| prb_rfc | String | References the Request for Change (RFC) associated with the problem. | |
| prb_rfc_link | String | Provides a link to the related change request record. | |
| prb_route_reason | Int | Specifies the routing reason used for workflow transitions. | |
| prb_service_offering | String | References the specific service offering affected by the problem. | |
| prb_service_offering_link | String | Provides a link to the related service offering record. | |
| prb_short_description | String | Gives a concise summary of the problem. | |
| prb_sla_due | Datetime | Shows when the problem's SLA resolution is due. | |
| prb_state | Int | Indicates the current workflow state of the problem record. | |
| prb_sys_class_name | String | Specifies the system class name defining the problem record type. | |
| prb_sys_created_by | String | Identifies the user who created the problem record. | |
| prb_sys_created_on | Datetime | Shows the date and time when the problem record was created. | |
| prb_sys_domain | String | Indicates the domain to which the problem record belongs. | |
| prb_sys_domain_path | String | Displays the full domain path for the problem record. | |
| prb_sys_mod_count | Int | Tracks how many times the problem record has been modified. | |
| prb_sys_tags | String | Lists tags applied to the problem record for categorization or reporting. | |
| prb_sys_updated_by | String | Identifies the user who last updated the problem record. | |
| prb_sys_updated_on | Datetime | Shows the date and time when the problem record was last updated. | |
| prb_task_effective_number | String | Specifies the effective number used to track the task within the problem record. | |
| prb_time_worked | String | Shows the total time worked on the problem, recorded in hours or minutes. | |
| prb_u_comments | String | Contains user-defined comments specific to the problem record. | |
| prb_u_some_test_field | String | Stores custom field data used for testing or configuration purposes. | |
| prb_universal_request | String | References the related universal request, if applicable. | |
| prb_universal_request_link | String | Provides a link to the related universal request record. | |
| prb_upon_approval | String | Defines the action to take when the problem is approved. | |
| prb_upon_reject | String | Defines the action to take when the problem is rejected. | |
| prb_urgency | Int | Specifies how quickly the problem needs to be addressed. | |
| prb_user_input | String | Captures additional information entered by users during problem resolution. | |
| prb_variables | String | Stores variable data associated with the problem workflow. | |
| prb_watch_list | String | Lists users who are notified of updates to the problem record. | |
| prb_wf_activity | String | References the workflow activity associated with the problem. | |
| prb_wf_activity_link | String | Provides a link to the related workflow activity record. | |
| prb_work_around | String | Describes the temporary solution or workaround implemented for the problem. | |
| prb_work_end | Datetime | Specifies when work on the problem was completed. | |
| prb_work_notes | String | Contains notes entered by users while working on the problem. | |
| prb_work_notes_list | String | Lists all work notes associated with the problem for reference. | |
| prb_work_start | Datetime | Specifies when work on the problem began. |