Incident Response Log

ServiceNow Platform Tickets

@kaggle.vipulshinde_incident_response_log

Table List

1 table(2.3 MB)

Incident Event Log

@kaggle.vipulshinde_incident_response_log.incident_event_log

2.3 MB
119998 rows
36 columns

number Number	incident_state Incident State	active Active	reassignment_count Reassignment Count	sys_mod_count Sys Mod Count	made_sla Made Sla	caller_id Caller Id	opened_by Opened By	opened_at Opened At	sys_created_by Sys Created By	sys_created_at Sys Created At	sys_updated_by Sys Updated By	sys_updated_at Sys Updated At	contact_type Contact Type	location Location	category Category	subcategory Subcategory	u_symptom U Symptom	cmdb_ci Cmdb Ci	impact Impact	urgency Urgency	priority Priority	assignment_group Assignment Group	assigned_to Assigned To	knowledge Knowledge	notify Notify	problem_id Problem Id	rfc Rfc	vendor Vendor	caused_by Caused By	closed_code Closed Code	resolved_by Resolved By	resolved_at Resolved At	closed_at Closed At
INC0000045	New	true			true	Caller 2403	Opened by 8	29/2/2016 01:16	Created by 6	29/2/2016 01:23	Updated by 21	29/2/2016 01:23	Phone	Location 143	Category 55	Subcategory 170	Symptom 72	?	2 - Medium	2 - Medium	3 - Moderate	Group 56	?	true	Do Not Notify	?	?	?	?	code 5	Resolved by 149	29/2/2016 11:29	5/3/2016 12:00
INC0000045	Resolved	true		2	true	Caller 2403	Opened by 8	29/2/2016 01:16	Created by 6	29/2/2016 01:23	Updated by 642	29/2/2016 08:53	Phone	Location 143	Category 55	Subcategory 170	Symptom 72	?	2 - Medium	2 - Medium	3 - Moderate	Group 56	?	true	Do Not Notify	?	?	?	?	code 5	Resolved by 149	29/2/2016 11:29	5/3/2016 12:00
INC0000045	Resolved	true		3	true	Caller 2403	Opened by 8	29/2/2016 01:16	Created by 6	29/2/2016 01:23	Updated by 804	29/2/2016 11:29	Phone	Location 143	Category 55	Subcategory 170	Symptom 72	?	2 - Medium	2 - Medium	3 - Moderate	Group 56	?	true	Do Not Notify	?	?	?	?	code 5	Resolved by 149	29/2/2016 11:29	5/3/2016 12:00
INC0000045	Closed			4	true	Caller 2403	Opened by 8	29/2/2016 01:16	Created by 6	29/2/2016 01:23	Updated by 908	5/3/2016 12:00	Phone	Location 143	Category 55	Subcategory 170	Symptom 72	?	2 - Medium	2 - Medium	3 - Moderate	Group 56	?	true	Do Not Notify	?	?	?	?	code 5	Resolved by 149	29/2/2016 11:29	5/3/2016 12:00
INC0000047	New	true			true	Caller 2403	Opened by 397	29/2/2016 04:40	Created by 171	29/2/2016 04:57	Updated by 746	29/2/2016 04:57	Phone	Location 165	Category 40	Subcategory 215	Symptom 471	?	2 - Medium	2 - Medium	3 - Moderate	Group 70	Resolver 89	true	Do Not Notify	?	?	?	?	code 5	Resolved by 81	1/3/2016 09:52	6/3/2016 10:00
INC0000047	Active	true	1	1	true	Caller 2403	Opened by 397	29/2/2016 04:40	Created by 171	29/2/2016 04:57	Updated by 21	29/2/2016 05:30	Phone	Location 165	Category 40	Subcategory 215	Symptom 471	?	2 - Medium	2 - Medium	3 - Moderate	Group 24	Resolver 31	true	Do Not Notify	?	?	?	?	code 5	Resolved by 81	1/3/2016 09:52	6/3/2016 10:00
INC0000047	Active	true	1	2	true	Caller 2403	Opened by 397	29/2/2016 04:40	Created by 171	29/2/2016 04:57	Updated by 21	29/2/2016 05:33	Phone	Location 165	Category 40	Subcategory 215	Symptom 471	?	2 - Medium	2 - Medium	3 - Moderate	Group 24	Resolver 31	true	Do Not Notify	?	?	?	?	code 5	Resolved by 81	1/3/2016 09:52	6/3/2016 10:00
INC0000047	Active	true	1	3	true	Caller 2403	Opened by 397	29/2/2016 04:40	Created by 171	29/2/2016 04:57	Updated by 804	29/2/2016 11:31	Phone	Location 165	Category 40	Subcategory 215	Symptom 471	?	2 - Medium	2 - Medium	3 - Moderate	Group 24	Resolver 31	true	Do Not Notify	?	?	?	?	code 5	Resolved by 81	1/3/2016 09:52	6/3/2016 10:00
INC0000047	Active	true	1	4	true	Caller 2403	Opened by 397	29/2/2016 04:40	Created by 171	29/2/2016 04:57	Updated by 703	29/2/2016 11:32	Phone	Location 165	Category 40	Subcategory 215	Symptom 471	?	2 - Medium	2 - Medium	3 - Moderate	Group 24	Resolver 31	true	Do Not Notify	?	?	?	?	code 5	Resolved by 81	1/3/2016 09:52	6/3/2016 10:00
INC0000047	Active	true	1	5	true	Caller 2403	Opened by 397	29/2/2016 04:40	Created by 171	29/2/2016 04:57	Updated by 332	1/3/2016 09:14	Phone	Location 165	Category 40	Subcategory 215	Symptom 471	?	2 - Medium	2 - Medium	3 - Moderate	Group 24	Resolver 31	true	Do Not Notify	?	?	?	?	code 5	Resolved by 81	1/3/2016 09:52	6/3/2016 10:00


CREATE TABLE incident_event_log (
  "number" VARCHAR,
  "incident_state" VARCHAR,
  "active" BOOLEAN,
  "reassignment_count" BIGINT,
  "reopen_count" BIGINT,
  "sys_mod_count" BIGINT,
  "made_sla" BOOLEAN,
  "caller_id" VARCHAR,
  "opened_by" VARCHAR,
  "opened_at" VARCHAR,
  "sys_created_by" VARCHAR,
  "sys_created_at" VARCHAR,
  "sys_updated_by" VARCHAR,
  "sys_updated_at" VARCHAR,
  "contact_type" VARCHAR,
  "location" VARCHAR,
  "category" VARCHAR,
  "subcategory" VARCHAR,
  "u_symptom" VARCHAR,
  "cmdb_ci" VARCHAR,
  "impact" VARCHAR,
  "urgency" VARCHAR,
  "priority" VARCHAR,
  "assignment_group" VARCHAR,
  "assigned_to" VARCHAR,
  "knowledge" BOOLEAN,
  "u_priority_confirmation" BOOLEAN,
  "notify" VARCHAR,
  "problem_id" VARCHAR,
  "rfc" VARCHAR,
  "vendor" VARCHAR,
  "caused_by" VARCHAR,
  "closed_code" VARCHAR,
  "resolved_by" VARCHAR,
  "resolved_at" VARCHAR,
  "closed_at" VARCHAR
);