HaloPSA Stale Tickets Report (free SQL)

Open tickets nobody has touched in 5 or more days, worst first. Run it every morning and nothing rots in the queue.

SELECT TOP 500
    f.Faultid          AS [Ticket],
    a.aareadesc        AS [Client],
    f.Symptom          AS [Summary],
    u.uname            AS [Agent],
    f.Flastactiondate  AS [Last Action],
    DATEDIFF(DAY, f.Flastactiondate, GETDATE()) AS [Days Silent]
FROM FAULTS f
JOIN AREA a        ON a.Aarea = f.Areaint
LEFT JOIN UNAME u  ON u.Unum  = f.Assignedtoint
JOIN REQUESTTYPE r ON r.RTid  = f.Requesttype
WHERE f.datecleared IS NULL AND ISNULL(f.FDeleted,0) = 0
  AND DATEDIFF(DAY, f.Flastactiondate, GETDATE()) >= 5
  AND ISNULL(r.RTIsOpportunity,0) = 0 AND ISNULL(r.RTIsProject,0) = 0
ORDER BY [Days Silent] DESC

How to add it

In Halo go to Configuration → Reporting → Reports (or the Reports module) and click New.
Set Data Source to Custom SQL Query and paste the SQL.
Click Load Report to preview, then save it. You can feed it into a dashboard widget.

Tweaks

Change >= 5 to your own threshold.
Add AND u.uname = 'Your Name' for a personal view.
Uses Flastactiondate, so no ACTIONS join and it stays fast.