ElegantInsights

HaloPSA reports, in plain English.

Ask a question, get a production-ready SQL report for your HaloPSA, HaloITSM, and HaloCRM data, no SQL required.

Here's everything you need to get the most out of ElegantInsights.

Try asking

Show all open tickets grouped by agentLast month's SLA breaches by clientTime logged per client this quarterAssets with warranties expiring in 90 days

What ElegantInsights does

You describe the report you want in plain English. The assistant generates a SQL query tailored to HaloPSA, which you can run to produce the report. It understands the Halo database schema, your configured preferences, and the patterns that work with the Halo reporting engine, so you get a working query, not just a guess.

Use the search box at the top of the sidebar (or press /Ctrl + K) to jump straight to a topic.