Definitions / restored
Restored
An interruption whose customers have supply again, by the ticket being closed in the outage management system.
control · Head of Network Operations · version 1
OMS tickets restored in the period (on or before now), with how long each was open.
Latest change: First version.
SQL
SELECT o.id AS outage_id, o.feeder_id, o.source, o.opened_at, o.restored_at, o.customers,
round(date_diff('second', o.opened_at, o.restored_at) / 60.0, 1) AS minutes_open
FROM outages o
WHERE o.restored_at >= {period_start} AND o.restored_at < {period_end} AND o.restored_at <= {now}
ORDER BY o.restored_at, o.id
Tests
| meaning | test | result | observed | expected |
|---|---|---|---|---|
| control | count_between | pass | 56 | between 0.0 and 400.0 |
| control | unique | pass | {'duplicates': 0} | outage_id unique |