maintenance · v1 · Head of Maintenance
441 tickets
SLA ended in the period, not cancelled, attended at or before due_at.
From in_sla (maintenance) · last week (Mon–Sun) · tables tickets
SQL and the first rows of 441
SELECT id AS ticket_id, building_id, priority, due_at, attended_at, vendor_id FROM tickets WHERE due_at >= TIMESTAMP '2026-10-26 00:00:00' AND due_at < TIMESTAMP '2026-11-02 00:00:00' AND due_at <= TIMESTAMP '2026-11-02 20:00:00' AND status <> 'cancelled' AND attended_at IS NOT NULL AND attended_at <= due_at ORDER BY due_at, id
[
{
"attended_at": "2026-10-22 19:38:24.907214",
"building_id": 34,
"due_at": "2026-10-26 01:15:54.779313",
"priority": "routine",
"ticket_id": 4835,
"vendor_id": 20
},
{
"attended_at": "2026-10-22 18:52:16.786790",
"building_id": 74,
"due_at": "2026-10-26 02:08:58.977548",
"priority": "routine",
"ticket_id": 4836,
"vendor_id": 235
},
{
"attended_at": "2026-10-26 01:09:28.520754",
"building_id": 87,
"due_at": "2026-10-26 02:12:46.855540",
"priority": "emergency",
"ticket_id": 5119,
"vendor_id": 24
},
{
"attended_at": "2026-10-23 02:09:32.297734",
"building_id": 110,
"due_at": "2026-10-26 02:23:34.301918",
"priority": "routine",
"ticket_id": 4838,
"vendor_id": 68
},
{
"attended_at": "2026-10-24 01:06:10.915877",
"building_id": 4,
"due_at": "2026-10-26 03:39:20.639607",
"priority": "routine",
"ticket_id": 4786,
"vendor_id": 263
},
{
"attended_at": "2026-10-25 19:01:20.724159",
"building_id": 18,
"due_at": "2026-10-26 05:20:44.424717",
"priority": "urgent",
"ticket_id": 5057,
"vendor_id": 103
},
{
"attended_at": "2026-10-25 11:41:18.293404",
"building_id": 55,
"due_at": "2026-10-26 06:05:26.603233",
"priority": "urgent",
"ticket_id": 5058,
"vendor_id": 75
},
{
"attended_at": "2026-10-26 02:04:10.179612",
"building_id": 78,
"due_at": "2026-10-26 07:14:13.114016",
"priority": "urgent",
"ticket_id": 5061,
"vendor_id": 82
}
]