Build reports
LOOP ships three Report Builder datasources, so you can build compliance reports without writing SQL. Create one from Site administration → Reports → Report builder → New report and pick the datasource you need.
User certifications
The current picture: one row per person per certification.
Columns to start from: full name, certification, status, expiration date, issuing course. Everything else Report Builder can reach from those — the person's email, the course, the other dates — can be added.
Use it for live compliance overviews: who is not covered on Fire Safety right now.
Certification message logs
Every notice LOOP has sent.
Columns to start from: full name, certification, trigger event, sent at, delivery status. The error recorded on a failed send can be added.
Use it to show that people were warned, and to audit delivery failures.
Certification history
Every certificate ever issued.
Columns to start from: full name, certification, course completed, completion date, end of the certificate's validity. The start of the validity and the edition's order can be added.
Use it for audit trails and year-on-year reporting. History rows stay after the certification they belong to is deleted, so a report on it keeps working.
Scheduling and sharing
These are ordinary Report Builder reports once created: schedule them, share them by audience, export them. Nothing about them is specific to LOOP after that point.
A report reads stored figures
Reports read the state Moodle has stored, so on a site whose cron has stopped a report shows the last state cron left behind, with nothing in the report itself to say so. The LOOP pages show the date the figures were worked out; a Report Builder report does not. See Scheduled tasks.
When a spreadsheet is enough
User status, Certification history, Message logs and Reports sent each have Download table data as below the table, in CSV, Excel, HTML, JSON, ODS and PDF. It exports exactly what the filters currently select, which is usually quicker than building a report. Exports are not blocked when the licence lapses.