Reports from GLPI data, with or without writing code.
A syntax-highlighted SQL editor, ready-made dashboards, scheduled e-mail reports. It reads the tables and writes to none of them.
Pick a metric and a breakdown; the bars redraw with sample data.
Main screenA syntax-highlighted SQL editor, ready-made dashboards, scheduled e-mail reports. It reads the tables and writes to none of them.
The problem
GLPI's own dashboards are fixed templates; management asks IT the same questions every time ("which unit opened how many tickets this month, where did we miss the SLA") and the answer arrives copied into Excel.
What I built
Analiz puts a reporting layer inside GLPI: queries are written and formatted in a highlighted editor, results become tables or charts and are arranged on dashboards. Reports are e-mailed to distribution lists on a day-and-hour schedule. The other Sayru plugins add their own dashboards here.
Technical notes
- Report updates are additive: existing dashboards and queries are never rewritten
- Install SQL compatible with MySQL 8 and MariaDB
- Translation calls sped up with an empty locale file
Highlights
- Monaco-based SQL editor, formatter and database navigator
- Ready-made reports: Pusula, Kale, Data Quality and Mühür dashboards
- Scheduled delivery: day/hour plan, distribution lists from GLPI users and groups
- Filters: date range, priority, ITIL record types; a Risk Matrix chart type
- Read-only: SELECT only, resource limits, pagination