HaloPSA Unassigned Tickets Report (free SQL)

Open tickets more than a day old with no agent. It also catches Halo's placeholder agent literally named Unassigned, which most homemade reports miss.

SELECT TOP 500
    f.Faultid   AS [Ticket],
    a.aareadesc AS [Client],
    f.Symptom   AS [Summary],
    f.sectio_   AS [Team],
    f.dateoccured AS [Created],
    DATEDIFF(DAY, f.dateoccured, GETDATE()) AS [Age (days)]
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 (f.Assignedtoint IS NULL OR f.Assignedtoint <= 0 OR u.uname = 'Unassigned')
  AND DATEDIFF(DAY, f.dateoccured, GETDATE()) >= 1
  AND ISNULL(r.RTIsOpportunity,0) = 0 AND ISNULL(r.RTIsProject,0) = 0
ORDER BY [Age (days)] 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 >= 1 to >= 0 to see today's too.
sectio_ is the team name (a legacy truncated column, not a typo).