Skip to content

Reports and the audit log

Report on training across every client, export the records as CSV or one client's evidence pack, withdraw a certificate, and check an audit log's hash chain.

Reports holds the training records for every client. The Audit log holds every recorded action, per organisation. Between them they answer who was trained on what, and who changed what.

The agency Overview comes first. It flags overdue assignments across all clients and any pool that’s 80% used or more, then shows the key numbers: active client organisations, active learners, published courses, open assignments and certificates issued. Under those, a table gives each active client’s people, assignments, completions, overdue assignments and progress as a percentage.

Reports has one row per assignment of every person who isn’t deactivated, 50 to a page:

Column What it shows
Organisation The client
Learner Their name
Course Title and version
Due The due date
Status Open, Overdue, Passed, Failed, Expired or Withdrawn
Completed The date of the latest completion
Score Its score
Certificate The certificate number

An open assignment past its due date counts as Overdue. Pick an Organisation and a Status and select Apply to filter.

Export CSV downloads every row the filters leave, not only the page on screen, as training-records-<date>.csv. The button shows how many rows it holds.

The columns are: Organisation, Given name, Family name, Email, Job title, Department, Person status, Course, Version, Assigned, Due, Status, Completed, Score, Certificate, Certificate link.

A client admin downloads the same file for their own organisation from their Overview, so a client doesn’t need to ask you for it. Theirs also keeps the people they’ve deactivated, marked deactivated. The record export is the client’s side of it.

The export is safe to open in a spreadsheet. A cell that starts like a formula is written so the spreadsheet shows it as text.

Pick one client under Organisation and select Apply, and two more downloads appear beside Export CSV:

  • Download evidence pack: the PDF the client’s admins download from their Overview, a summary of their AI literacy training with their training records CSV attached and its SHA-256 printed. The evidence pack describes what it holds.
  • Download training records: that client’s own CSV, training-records-<client>-<date>.csv, every record with the people they’ve deactivated, the file their admins download. The pack’s SHA-256 matches this file. It doesn’t match Export CSV, which applies your filters and leaves deactivated people out.

Neither follows the status filter. Both are written to the client’s audit log, as evidence_pack.generated and training_records.exported, so the client sees them.

A pack holds up to 10,000 training records and 50,000 audit events. Past either, Reports shows why in place of the button. To produce one on request, download the client’s training records, run Verify the chain on their audit log, and send both with a note of the chain’s result.

When the record behind a certificate is wrong, for example a course recorded against the wrong person, withdraw the certificate. Open it at /certificate/ followed by its number, select Withdraw certificate, write the reason and select Withdraw. Only agency admins see the button.

A withdrawal can’t be undone. The certificate keeps its number and its row; the withdrawal is recorded next to it with your reason and as certificate.revoked in the client’s audit log. From then on the certificate page says when it was withdrawn and why, its PDF can’t be downloaded, and anyone who checks it is told it was withdrawn, without the reason. The training record stays in the reports and the export as it was.

Audit log shows one organisation’s actions, newest first, 50 to a page: the time, who did it, the action, and a line of detail. It opens on Aigentcy’s own log, where the catalog and the pools are recorded. Pick a client under Organisation and select Show for theirs. Search the page, or filter it by action.

Entries can’t be edited or deleted, by the app or in the database. Each one carries the hash of the one before it in the same organisation. Verify the chain recomputes every hash in the organisation’s log and either confirms they all hold or names the first entry that doesn’t, which means it, or an entry before it, was changed or added outside the app.

The app records these actions:

Action When
organisation.created You create a client organisation with its first admin
organisation.renamed, organisation.archived, organisation.restored You rename, archive or restore one
person.created A client admin adds a person
people.imported, people.onboarded A client admin imports people from CSV or BambooHR
invitation.issued, invitation.accepted Someone is invited, or accepts
person.deactivated Someone is deactivated
training_records.exported A client admin or you download the client’s training records, with the number of rows
evidence_pack.generated A client admin or you download the client’s evidence pack, with the number of rows and the CSV’s SHA-256
integration.connected, integration.disconnected A client connects or disconnects BambooHR
assignment.created A course is assigned
assignment.started, assignment.retaken A learner opens a course for the first time, or again after failing it
completion.recorded A learner passes or fails a course, and with a pass its certificate is issued
certificate.revoked You withdraw a certificate, with your reason
allocation.set You change a client’s seats from a pool
course.created, course.updated You create or edit a course
version.created, version.updated, version.published, version.retired You create, edit, publish or retire a version
package.uploaded, package.rejected, package.discarded A package becomes a module, is turned away, or is discarded
module.removed You remove a module from a draft
pool.created, pool.resized You add or resize a licence pool