Routine~13min

The Maintenance Ticket Closed Before The Technician Arrived

Facilities audit found 6 tickets where closed_at is earlier than the technician's own arrived_at timestamp on the same ticket — all logged by the same contractor, TECH-09, who appears to have been pre-closing tickets to hit an SLA dashboard target before actually showing up. A few tickets show the fix closed just 3-5 minutes after arrival — that's a genuinely fast fix, not a red flag.

Tables you'll query

tickets

What you'll learn

Date & Time FunctionsJOINs
Investigate this case →