incident_metric
Provides metrics for incidents, including resolution times, reopen rates, and Service Level Agreement (SLA) performance.
Columns
| Name | Type | References | Description |
| md_sys_id | String | Provides the system identifier (sys_id) that uniquely identifies the metric definition record. | |
| md_active | Bool | Indicates whether the metric definition is currently active and being applied to incidents. | |
| md_description | String | Contains a description of the metric definition, explaining its purpose or calculation logic. | |
| md_field | String | Specifies the field name that the metric definition evaluates or monitors. | |
| md_name | String | Lists the name of the metric definition for identification within the system. | |
| md_number | String | Displays the unique number assigned to the metric definition record. | |
| md_order | Int | Defines the order in which the metric definition is processed relative to others. | |
| md_script | String | Contains the script that defines custom behavior or calculation logic for the metric definition. | |
| md_sys_class_name | String | Specifies the system class name that defines the table structure for the metric definition. | |
| md_sys_created_by | String | Lists the user or process that created the metric definition record. | |
| md_sys_created_on | Datetime | Displays 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 | Lists the internal system name used to identify the metric definition record. | |
| md_sys_package | String | Specifies the application package that contains the metric definition record. | |
| md_sys_package_link | String | Provides a link to the related package record containing this metric definition. | |
| md_sys_policy | String | Defines the update policy applied to the metric definition during system changes. | |
| md_sys_scope | String | Specifies the application scope in which the metric definition exists. | |
| md_sys_scope_link | String | Provides a link to the application scope associated with the metric definition. | |
| md_sys_tags | String | Contains metadata tags for categorizing or filtering the metric definition record. | |
| md_sys_update_name | String | Lists the update set entry name that includes the metric definition record. | |
| md_sys_updated_by | String | Identifies 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 record was last updated. | |
| md_table | String | Specifies the database table to which the metric definition applies. | |
| md_timeline | Bool | Indicates whether the metric definition is included in performance timeline tracking. | |
| md_type | String | Defines the type of metric, such as duration-based, count-based, or custom. | |
| mi_sys_id | String | Provides the sys_id that uniquely identifies the metric instance record. | |
| mi_business_duration | Long | Specifies the total business duration measured for the metric instance. | |
| mi_calculation_complete | Bool | Indicates whether the metric calculation process has been completed. | |
| mi_definition | String | References the metric definition associated with this metric instance. | |
| mi_definition_link | String | Provides a link to the related metric definition record. | |
| mi_duration | Long | Displays the total elapsed duration measured by the metric instance. | |
| mi_end | Datetime | Specifies the end date and time of the measurement period. | |
| mi_field | String | Lists the field evaluated for the metric instance calculation. | |
| mi_field_value | String | Displays the value of the monitored field at the time of measurement. | |
| mi_id | String | Provides the unique identifier for the metric instance within its context. | |
| mi_start | Datetime | Specifies the start date and time of the measurement period. | |
| mi_sys_created_by | String | Lists the user or 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 modified. | |
| mi_sys_tags | String | Contains metadata tags for categorizing or filtering the metric instance record. | |
| mi_sys_updated_by | String | Identifies the user or process that last updated 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 associated with the metric instance. | |
| mi_value | String | Displays the measured or calculated value of the metric instance. | |
| inc_sys_id | String | Provides the sys_id that uniquely identifies the incident record. | |
| inc_active | Bool | Indicates whether the incident is active and currently being worked on. | |
| inc_activity_due | Datetime | Specifies the date and time when the next activity or response is due for the incident. | |
| inc_additional_assignee_list | String | Lists any additional users assigned to assist with the incident resolution. | |
| inc_approval | String | Displays the current approval status of the incident. | |
| inc_approval_history | String | Contains a record of previous approval actions related to the incident. | |
| inc_approval_set | Datetime | Specifies the date and time when the approval status was last set. | |
| inc_assigned_to | String | Indicates the user assigned to handle the incident. | |
| inc_assigned_to_link | String | Provides a link to the user record assigned to the incident. | |
| inc_assignment_group | String | Lists the group responsible for resolving the incident. | |
| inc_assignment_group_link | String | Provides a link to the group record assigned to the incident. | |
| inc_business_duration | Long | Displays the business time elapsed since the incident was opened. | |
| inc_business_service | String | Specifies the business service affected by the incident. | |
| inc_business_service_link | String | Provides a link to the related business service record. | |
| inc_business_stc | Int | Tracks the business Service Transaction Count (STC) associated with the incident. | |
| inc_calendar_duration | Long | Displays the total calendar time elapsed since the incident was created. | |
| inc_calendar_stc | Int | Tracks the calendar-based STC for the incident. | |
| inc_caller_id | String | Identifies the user who reported the incident. | |
| inc_caller_id_link | String | Provides a link to the user record of the caller who reported the incident. | |
| inc_category | String | Specifies the category under which the incident is classified. | |
| inc_caused_by | String | Lists the change, problem, or issue that caused the incident. | |
| inc_caused_by_link | String | Provides a link to the related record that caused the incident. | |
| inc_child_incidents | Int | Indicates the number of child incidents linked to the primary incident. | |
| inc_close_code | String | Specifies the closure code used when resolving the incident. | |
| inc_close_notes | String | Contains notes or comments entered when closing the incident. | |
| inc_closed_at | Datetime | Displays the date and time when the incident was closed. | |
| inc_closed_by | String | Lists the user who closed the incident. | |
| inc_closed_by_link | String | Provides a link to the user record of the individual who closed the incident. | |
| inc_cmdb_ci | String | Specifies the Configuration Item (CI) associated with the incident. | |
| inc_cmdb_ci_link | String | Provides a link to the CI record related to the incident. | |
| inc_comments | String | Contains comments or updates added to the incident during its lifecycle. | |
| inc_comments_and_work_notes | String | Combines both comments and work notes entered for the incident record. | |
| inc_company | String | Identifies the company or business entity associated with the incident. | |
| inc_company_link | String | Provides a link to the company record associated with the incident. | |
| inc_contact_type | String | Specifies how the incident was reported, such as phone, email, or self-service portal. | |
| inc_correlation_display | String | Displays the correlation display name used for linking related incidents. | |
| inc_correlation_id | String | Lists the correlation identifier (ID) used to relate incidents across systems. | |
| inc_delivery_plan | String | References the delivery plan tied to the incident resolution process. | |
| inc_delivery_plan_link | String | Provides a link to the delivery plan record associated with the incident. | |
| inc_delivery_task | String | Specifies the delivery task related to the incident. | |
| inc_delivery_task_link | String | Provides a link to the delivery task record associated with the incident. | |
| inc_description | String | Contains the full description of the incident provided by the reporter or technician. | |
| inc_due_date | Datetime | Displays the target date and time by which the incident should be resolved. | |
| inc_escalation | Int | Indicates the escalation level assigned to the incident. | |
| inc_expected_start | Datetime | Specifies the expected start date and time for incident work. | |
| inc_follow_up | Datetime | Lists the follow-up date and time for reviewing the incident status. | |
| inc_group_list | String | Contains a list of groups that have interacted with the incident. | |
| inc_hold_reason | Int | Specifies the reason code if the incident is placed on hold. | |
| inc_impact | Int | Defines the impact level of the incident, indicating its effect on business operations. | |
| inc_incident_state | Int | Displays the current state of the incident, such as new, in progress, or resolved. | |
| inc_knowledge | Bool | Indicates whether the incident can contribute to a knowledge base article. | |
| inc_location | String | Specifies the location associated with the incident. | |
| inc_location_link | String | Provides a link to the location record related to the incident. | |
| inc_made_sla | Bool | Indicates whether the incident met its SLA targets. | |
| inc_notify | Int | Defines the notification setting applied to updates about this incident. | |
| inc_number | String | Displays the unique incident number assigned by the system. | |
| inc_opened_at | Datetime | Shows the date and time when the incident was first opened. | |
| inc_opened_by | String | Identifies the user who created or opened the incident record. | |
| inc_opened_by_link | String | Provides a link to the user record of the person who opened the incident. | |
| inc_order | Int | Defines the order or sequence for processing related incidents. | |
| inc_parent | String | References the parent record linked to this incident, if applicable. | |
| inc_parent_incident | String | Lists the main incident record that this incident is derived from. | |
| inc_parent_incident_link | String | Provides a link to the parent incident record. | |
| inc_parent_link | String | Provides a link to the parent record associated with this incident. | |
| inc_priority | Int | Displays the priority level of the incident, derived from impact and urgency. | |
| inc_problem_id | String | References the related problem record that the incident is linked to. | |
| inc_problem_id_link | String | Provides a link to the related problem record. | |
| inc_reassignment_count | Int | Tracks how many times the incident has been reassigned to different users or groups. | |
| inc_rejection_goto | String | Specifies the redirection path or action if the incident is rejected. | |
| inc_rejection_goto_link | String | Provides a link to the redirection configuration used for incident rejection. | |
| inc_reopen_count | Int | Indicates how many times the incident has been reopened after being closed. | |
| inc_reopened_by | String | Lists the user who last reopened the incident. | |
| inc_reopened_by_link | String | Provides a link to the user record of the person who reopened the incident. | |
| inc_reopened_time | Datetime | Displays the date and time when the incident was last reopened. | |
| inc_resolved_at | Datetime | Shows the date and time when the incident was resolved. | |
| inc_resolved_by | String | Lists the user who resolved the incident. | |
| inc_resolved_by_link | String | Provides a link to the user record of the resolver. | |
| inc_rfc | String | References the Request for Change (RFC) associated with the incident. | |
| inc_rfc_link | String | Provides a link to the related RFC record. | |
| inc_route_reason | Int | Specifies the routing reason code for the incident. | |
| inc_service_offering | String | Lists the specific service offering affected by the incident. | |
| inc_service_offering_link | String | Provides a link to the service offering record. | |
| inc_severity | Int | Indicates the severity level of the incident, reflecting its urgency and business impact. | |
| inc_short_description | String | Provides a concise summary of the incident for quick reference. | |
| inc_sla_due | Datetime | Displays the due date and time according to the SLA. | |
| inc_state | Int | Specifies the current workflow state of the incident, such as active or closed. | |
| inc_subcategory | String | Lists the subcategory that further classifies the incident type. | |
| inc_sys_class_name | String | Specifies the system class name that defines the incident record type. | |
| inc_sys_created_by | String | Identifies the user or process that created the incident record. | |
| inc_sys_created_on | Datetime | Displays the date and time when the incident record was created. | |
| inc_sys_domain | String | Specifies the domain to which the incident belongs, supporting domain separation. | |
| inc_sys_domain_path | String | Displays the domain path hierarchy for the incident record. | |
| inc_sys_mod_count | Int | Tracks how many times the incident record has been modified. | |
| inc_sys_tags | String | Contains metadata tags for categorizing or filtering the incident record. | |
| inc_sys_updated_by | String | Identifies the user or process that last updated the incident record. | |
| inc_sys_updated_on | Datetime | Displays the date and time when the incident record was last updated. | |
| inc_task_effective_number | String | Provides the effective task number associated with the incident. | |
| inc_time_worked | String | Displays the total amount of time spent working on the incident. | |
| inc_u_comments | String | Contains user-defined comments or notes specific to the incident. | |
| inc_u_some_test_field | String | Represents a custom test field used for internal or development purposes. | |
| inc_u_test_custom_field | String | Specifies a custom field added for tracking additional incident-related data. | |
| inc_universal_request | String | References the associated universal request record. | |
| inc_universal_request_link | String | Provides a link to the universal request record. | |
| inc_upon_approval | String | Defines the workflow action triggered when the incident is approved. | |
| inc_upon_reject | String | Defines the workflow action triggered when the incident is rejected. | |
| inc_urgency | Int | Indicates the urgency level of the incident, affecting its overall priority. | |
| inc_user_input | String | Contains any user-provided input or feedback related to the incident. | |
| inc_variables | String | Lists variables used for incident forms or dynamic data fields. | |
| inc_watch_list | String | Displays users who are subscribed to receive updates about the incident. | |
| inc_wf_activity | String | References the workflow activity currently associated with the incident. | |
| inc_wf_activity_link | String | Provides a link to the related workflow activity record. | |
| inc_work_end | Datetime | Displays the date and time when work on the incident was completed. | |
| inc_work_notes | String | Contains internal notes entered by agents while handling the incident. | |
| inc_work_notes_list | String | Aggregates all work notes associated with the incident. | |
| inc_work_start | Datetime | Displays the date and time when work on the incident began. |