Power BI Connector for ServiceNow

Build 25.0.9454

incident

Tracks incidents that document issues, service disruptions, or user-reported problems.

Columns

Name Type ReadOnly References Description
sys_id [KEY] String False

Provides the system identifier (sys_id) that uniquely identifies each incident record within the platform.

active Bool False

Indicates whether the incident is currently active and still being worked on, helping to distinguish open records from closed ones.

activity_due Datetime False

Displays the date and time when the next scheduled activity, task, or response is due for the incident.

additional_assignee_list String False

Lists additional users assigned to assist with resolving or progressing the incident beyond the primary assignee.

approval String False

Specifies the current approval status of the incident, showing whether it requires, awaits, or has received approval.

approval_history String True

Contains a historical log of all approval actions, including approvers, decisions, and timestamps.

approval_set Datetime False

Displays the date and time when the approval status was last updated or finalized.

assigned_to String False

Identifies the user currently responsible for handling and resolving the incident.

assigned_to_link String False

Provides a link to the user record of the assignee responsible for the incident.

assignment_group String False

Lists the support or functional group to which the incident has been assigned for resolution.

assignment_group_link String False

Provides a link to the group record responsible for managing the incident.

business_duration Long False

Shows the total business time elapsed while the incident was being processed, excluding non-business hours.

business_impact String False

Describes the potential or actual impact of the incident on business operations or services.

business_service String False

Specifies the business service that is directly affected by the incident, used for service impact analysis.

business_service_link String False

Provides a link to the business service record impacted by the incident.

business_stc Int False

Tracks the business Service Transaction Count (STC), helping measure the service load affected by the incident.

calendar_duration Long False

Displays the total calendar time elapsed from when the incident was created until resolution.

calendar_stc Int False

Tracks the calendar-based STC related to the incident.

caller_id String False

Identifies the user who initially reported or raised the incident.

caller_id_link String False

Provides a link to the user record of the person who reported the incident.

category String False

Specifies the primary category used to classify and route the incident appropriately.

cause String False

Describes the underlying or suspected cause that triggered the incident.

caused_by String False

References the change, task, or problem record that directly caused the incident.

caused_by_link String False

Provides a link to the related record that caused the incident, enabling root cause tracking.

child_incidents Int False

Displays the number of child incidents linked to this primary record, useful for managing related issues.

closed_at Datetime False

Shows the date and time when the incident was officially closed.

closed_by String False

Identifies the user who completed the resolution and closed the incident.

closed_by_link String False

Provides a link to the user record of the person who closed the incident.

close_code String False

Specifies the closure code or reason used to finalize the incident, such as 'Solved Remotely' or 'Resolved by Change'.

close_notes String False

Contains detailed notes or comments added during the incident closure process.

cmdb_ci String False

Specifies the Configuration Item (CI) impacted by the incident, linking it to the Configuration Management Database (CMDB).

cmdb_ci_link String False

Provides a link to the CI record associated with the incident.

comments String True

Contains general comments added by users, providing communication history on the incident.

comments_and_work_notes String True

Combines public comments and internal work notes for a complete incident discussion log.

company String False

Identifies the customer company, vendor, or organization associated with the incident.

company_link String False

Provides a link to the company record related to the incident.

contact_type String False

Specifies how the incident was reported, such as by email, phone, chat, or self-service portal.

contract String False

References the contract or service agreement that covers the affected user or service.

contract_link String False

Provides a link to the related contract record governing the service or support terms.

correlation_display String False

Displays the correlation label used to connect this incident with related records in other systems.

correlation_id String False

Lists the correlation identifier (Id) that uniquely links related incidents across systems or integrations.

delivery_plan String False

References the delivery plan or workflow sequence associated with resolving the incident.

delivery_plan_link String False

Provides a link to the delivery plan record linked to the incident.

delivery_task String False

Lists the specific delivery task created as part of the incident's resolution process.

delivery_task_link String False

Provides a link to the delivery task record associated with this incident.

description String False

Contains a detailed explanation of the issue or request described in the incident.

due_date Datetime False

Displays the target date and time by which the incident should be resolved based on service targets.

escalation Int False

Indicates the current escalation level of the incident, showing whether it requires higher-priority attention.

expected_start Datetime False

Specifies the expected date and time when work on the incident should begin.

follow_up Datetime False

Defines a follow-up date and time for checking progress or validating resolution.

group_list String False

Lists all user groups that have participated in handling or reviewing the incident.

hold_reason Int False

Specifies the reason why the incident is currently on hold, such as pending user input or awaiting approval.

impact Int False

Indicates the impact level of the incident, showing how broadly it affects business services or users.

incident_state Int False

Displays the current workflow state of the incident, such as new, in progress, or resolved.

knowledge Bool False

Indicates whether the incident is marked as a candidate for creating a Knowledge Base article.

location String False

Specifies the site or office location associated with the incident or affected user.

location_link String False

Provides a link to the related location record within the system.

made_sla Bool False

Indicates whether the incident met all Service Level Agreement (SLA) response and resolution targets.

notify Int False

Defines the notification preference for sending updates or alerts about this incident.

number String False

Displays the unique system-generated incident number used for tracking and reporting.

opened_at Datetime False

Shows the date and time when the incident was first created and logged in the system.

opened_by String False

Identifies the user who opened or initiated the incident record.

opened_by_link String False

Provides a link to the user record of the individual who opened the incident.

order Int False

Defines the order or sequence in which related incidents are processed or displayed.

origin_id String False

References the unique identifier of the originating record that created the incident.

origin_table String False

Specifies the source table that the incident originated from, if it was automatically created.

parent String False

References the parent record related to this incident, such as a higher-level task or issue.

parent_incident String False

Lists the main incident record to which this one is linked as a child.

parent_incident_link String False

Provides a link to the parent incident record for easy navigation.

parent_link String False

Provides a link to the parent task or source record associated with the incident.

priority Int False

Specifies the priority level of the incident, calculated based on impact and urgency.

problem_id String False

References the problem record linked to the incident, indicating it may share a root cause.

problem_id_link String False

Provides a link to the related problem record for root cause analysis.

reassignment_count Int False

Tracks how many times the incident has been reassigned to another user or group.

rejection_goto String False

Specifies the workflow or state transition triggered if the incident is rejected.

rejection_goto_link String False

Provides a link to the workflow configuration or rejection rule.

reopened_by String False

Lists the user who reopened the incident after it was previously closed.

reopened_by_link String False

Provides a link to the user record of the person who reopened the incident.

reopened_time Datetime False

Displays the date and time when the incident was last reopened.

reopen_count Int False

Shows how many times the incident has been reopened after closure.

resolved_at Datetime False

Displays the date and time when the incident was marked as resolved.

resolved_by String False

Identifies the user who resolved the incident.

resolved_by_link String False

Provides a link to the user record of the resolver.

rfc String False

References the Request for Change (RFC) record associated with the incident.

rfc_link String False

Provides a link to the related RFC record.

route_reason Int False

Specifies the routing reason code used when the incident was assigned to a particular group or user.

service_offering String False

Lists the specific service offering affected by the incident, tied to a business service.

service_offering_link String False

Provides a link to the related service offering record.

severity Int False

Indicates the severity level of the incident, reflecting its urgency and overall business impact.

short_description String False

Provides a brief summary or headline describing the nature of the incident.

skills String False

Lists the required skills or expertise needed to handle and resolve the incident.

sla_due Datetime False

Displays the date and time when the SLA response or resolution is due.

state Int False

Indicates the current workflow state of the incident, such as active, pending, or closed.

subcategory String False

Specifies the subcategory used for more granular classification of the incident type.

sys_class_name String False

Defines the system class name that determines the structure and behavior of the incident record.

sys_created_by String False

Lists the user or process that originally created the incident record.

sys_created_on Datetime False

Displays the date and time when the incident record was created in the system.

sys_domain String False

Specifies the domain or partition the incident belongs to, supporting multi-tenant environments.

sys_domain_path String False

Displays the domain path hierarchy that defines where the incident sits within domain separation.

sys_mod_count Int False

Tracks the number of times the incident record has been modified or updated.

sys_tags String False

Contains metadata tags used for filtering, searching, or categorizing the incident record.

sys_updated_by String False

Identifies the user or process that last modified the incident record.

sys_updated_on Datetime False

Displays the date and time when the incident was last updated.

task_effective_number String False

Provides the effective task number used internally to track the incident within workflows.

time_worked String False

Displays the total time spent working on the incident across all assignees.

universal_request String False

References the universal request record associated with the incident, if applicable.

universal_request_link String False

Provides a link to the universal request record related to this incident.

upon_approval String False

Defines the action or workflow that runs automatically when the incident receives approval.

upon_reject String False

Defines the action or workflow triggered when the incident is rejected during processing.

urgency Int False

Specifies the urgency level of the incident, influencing its calculated priority.

user_input String False

Contains additional input, feedback, or notes provided by the end user.

u_comments String False

Stores user comments or supplementary details specific to this incident.

u_some_test_field String False

Represents a custom field used for testing or tracking internal workflow behavior.

u_test_custom_field String False

Specifies a custom field created for capturing additional incident-related data.

variables String False

Lists dynamic variables used for data collection, automation, or workflow customization.

watch_list String False

Lists users who are subscribed to receive email or system notifications about the incident.

wf_activity String False

References the workflow activity currently associated with the incident's progress.

wf_activity_link String False

Provides a link to the workflow activity record related to the incident.

work_end Datetime False

Displays the date and time when work on the incident was completed.

work_notes String True

Contains internal work notes and technical updates entered by agents while resolving the incident.

work_notes_list String False

Lists all work notes associated with the incident in chronological order.

work_start Datetime False

Displays the date and time when work on the incident began.

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