it_incidents
Outages and degradations of business systems. One row is one incident.
- One row is
- one incident
- Columns
- 7
- Rows in Sample
- 487
- Rows in Standard
- 487
- Rows in Full
- 487
This table describes the company, not individual guests, so it is identical in all three sizes.
Columns
| Column | Type | What it holds | Values or range |
|---|---|---|---|
| it_incident_idkey | integer | Unique id for the row. | |
| system_id | integer | Links to it_systems. | |
| started_at | date and time | When it began. | 2018-01-06 13:40 to 2025-12-31 07:26 |
| resolved_at | date and time | When service was restored. | 2018-01-06 18:11 to 2025-12-31 09:59 |
| severity | text | SEV1 worst to SEV3 mildest. | SEV1; SEV2; SEV3 |
| root_cause | text | Cause recorded after review. | capacity; change; configuration drift; hardware failure; unknown; vendor outage |
| caused_by_change_id | integer | The change blamed, when one was identified. Links to change_requests. Can be empty. |
How it connects
This table points to
- system_id matches it_systems.system_id
- caused_by_change_id matches change_requests.change_id
First five rows
Taken from the Sample size, exactly as they appear in the file. Empty cells are empty in the data.
| it_incident_id | system_id | started_at | resolved_at | severity | root_cause | caused_by_change_id |
|---|---|---|---|---|---|---|
| 50001 | 1 | 2018-01-06 13:40:16 | 2018-01-06 18:11:36 | SEV2 | vendor outage | |
| 50002 | 7 | 2018-01-13 07:32:27 | 2018-01-13 08:15:35 | SEV2 | vendor outage | |
| 50003 | 5 | 2018-02-03 08:34:29 | 2018-02-03 10:41:31 | SEV1 | hardware failure | |
| 50004 | 3 | 2018-02-06 17:03:39 | 2018-02-06 17:12:50 | SEV3 | capacity | |
| 50005 | 1 | 2018-02-22 09:00:02 | 2018-02-22 13:23:07 | SEV1 | unknown |