SQL & Reporting

Halo ITSM

Downloadable SQL scripts and reporting helpers for Halo — optimised for real dashboards, exports, and operational reporting.

← Back to Halo Runbooks & Automation →
Reporting SLA Ageing Agent filters

Reporting SQL

Expand an item to view the SQL, copy it, or download the raw file.

HALO Scoped reporting by agent team Limit results to the logged-in agent’s teams

Use this when you want agent-facing reports to only show tickets that match one of the agent’s section memberships.

SQL 
Loading…
HALO Resolved this month Tickets closed in the current month
SQL 
Loading…
HALO Resolved this month (closed by logged-in agent) Tickets closed this month by $agentid
SQL 
Loading…
HALO SLA status Open tickets right now (breach + targets)
SQL 
Loading…
HALO Ticket age Open tickets right now (age buckets)
SQL 
Loading…
HALO Re-open behaviour (closed this month) Closed this month → reopened patterns
SQL 
Loading…
HALO Opened this month (still open) Tickets created this month and not yet cleared
SQL 
Loading…
HALO First-time fix (closed this month) Tickets closed this month resolved on first pass
SQL 
Loading…

Support the build

Buy me a coffee