servicenow_incidents

Details about ServiceNow incidents

source_id

Foreign key
Unique identifier of the incident in the ServiceNow system

source_url

string
URL pointing to the incident in ServiceNow

number

string
Incident number in the ServiceNow system

short_description

string
Brief description of the incident

state

string
Current state of the incident (e.g., New, In Progress, Closed)

priority

string
Priority level of the incident

severity

string
Severity level of the incident

urgency

string
Urgency level of the incident

impact

string
Impact level of the incident

category

string
Category of the incident (e.g., Software, Hardware)

opened_at

date
Date and time when the incident was opened

closed_at

date
Date and time when the incident was closed

resolved_at

date
Date and time when the incident was resolved

active

boolean
Whether the incident is currently active

opened_by_id

Foreign key
ID of the user who opened the incident

closed_by_id

Foreign key
ID of the user who closed the incident

resolved_by_id

Foreign key
ID of the user who resolved the incident

caller_id

Foreign key
ID of the caller (user who reported the incident)

service_id

Foreign key
ID of the service associated with the incident

assigned_to_id

Foreign key
ID of the assignee (user who assign to the incident)

assigment_group_id

Foreign key
ID of the group handling the incident

connection_id

Foreign key
Connection ID for the incident.

created_at

date
Date and time when the record was created

updated_at

date
Date and time when the record was last updated