Support queue aging review from synthetic ticket data — Python demo

Self-initiated Rivetfern demonstration using synthetic support-ticket metadata. No real helpdesk or customer account is connected; this is not paid client work.

The standard-library Python tool validates dates, priorities, status and supplied SLA-day inputs; quarantines conflicting duplicate ticket IDs; skips exact duplicates; and produces a sorted queue of open and pending tickets. It flags rows past or at their supplied date threshold and counts unassigned cases. Closed tickets remain in the summary without an invented resolution time. The outputs include an exception CSV, a compact JSON summary and SHA-256 file hashes. The tool sends no customer messages and updates no helpdesk.

I used AI assistance during development, reviewed the code and ran the tests. See the [public case study and code bundle](https://www.twine.net/signin This sample uses calendar days and treats each supplied SLA as an input. Business hours, holidays and contractual service-level policy need explicit agreement for real use.