Neuu / HaloPSA reporting
Free, tested SQL reports and schema notes for MSPs running HaloPSA. Paste into a Custom SQL Query and go. Runs inside your own Halo, so no third party ever sees your data.
Download all 7 freeGuide
How to use ChatGPT or Claude to configure HaloPSA: the setup order, the business questions to answer first, a copy-paste prompt and rules for AI browser agents.
ReadFree SQL
Free HaloPSA SQL report: closed tickets with billable time logged but no invoice, last 90 days. Find billing leakage fast.
ReadFree SQL
Free HaloPSA SQL report for QBRs: ticket volume per client, per ticket type, per month for the last 6 months.
ReadGuide
How to get ChatGPT or Claude to write working HaloPSA custom SQL reports: the schema context and Halo parser rules to paste in first.
ReadGuide
A practical map of HaloPSA's database for custom SQL reports: FAULTS, ACTIONS, AREA, UNAME and the joins between them.
ReadGuide
Fixes for HaloPSA custom SQL report errors: Invalid SQL Statement, ORDER BY clause is invalid, Operand data type bit is invalid.
ReadFree SQL
Free HaloPSA SQL report: open tickets with no activity for 5+ days, by client and agent.
ReadFree SQL
Free HaloPSA SQL report: hours logged per agent in the last 30 days as a utilisation percentage against a target you set.
ReadFree SQL
Free HaloPSA SQL report: billable and non-billable hours per agent for the last 30 days, with billable percentage.
ReadFree SQL
Free HaloPSA SQL report: open tickets older than a day with no agent assigned, including the 'Unassigned' placeholder agent.
ReadFree SQL
Free HaloPSA SQL report: SLA resolution breach count and breach % by client and urgency, last 30 days.
ReadThe pack
SLA, utilisation, client profitability, billing leakage and QBR packs, plus the full schema cheat sheet and dashboard recipes. Free updates.
Get it for £79New: the AI kit
100 setup questions in the right order, 11 prompts that stop the AI guessing, and the rules for letting an agent click through Halo safely.
Get it for £39