SLA Risk Sweep
Run this on a regular cadence (every 15 to 30 minutes during business hours) to scan all open tickets, compute time remaining against SLA windows, and surface any ticket that is at risk or already breaching.
- Pull all open tickets from Zendesk with status "new," "open," or "pending" and filter to those not yet resolved.
- For each ticket, compute two numbers: time remaining until first-response SLA and time remaining until resolution SLA.
- Classify each ticket: Breaching: SLA window already elapsed with no response or resolution.