Reporting

Folder: reporting/ Colour: Brown #ca5010

Report packs, system logs, audit trails, and curated dashboards for cross-module analytics.

Report Packs (reporting/packs/)

Multi-page reports designed once — cover, headings, charts, tables and your own commentary from Tickets, Service Status, Software and Assets/Intune — and exported as a PDF for any period. A Word-like designer with a ribbon, drag and drop, and text edited on the page; private until shared with analysts, teams or departments.

👉 Report Packs · 🛠️ Developer Guide

System Logs

• Login attempt tracking — successes and failures with IP and user agent
• Email import logs — every mailbox check with imported / rejected counts
• System event logs — administrative actions

All tables searchable and sortable.

Intune Dashboard (reporting/intune/)

Curated dashboard of Microsoft Intune device aggregations.

KPI strip

Five at-a-glance metrics with threshold-based tone (green/red flags):

• Total devices
• Compliant % — green/red threshold flagging
• Encrypted % — green/red threshold flagging
• Stale 30+ days — count of devices not seen by Intune in 30+ days
• Recently enrolled — last 7 days

Eight Chart.js widgets

• Compliance breakdown (Compliant / Non-compliant / Unknown)
• OS distribution (Windows / macOS / iOS / Android)
• Owner type (Corporate vs Personal)
• Top manufacturers
• Top OS versions
• Last-sync window distribution (today / this week / month / older / stale)
• 90-day enrolment trend (line)
• Encryption by OS (stacked bar — Encrypted / Not encrypted per OS)

A single API call returns all aggregates so the dashboard renders fast. The toolbar shows the timestamp of the most recent Intune sync job for transparency.

Drill-down

Click any chart slice/bar/point or any KPI card to open a modal listing the matching devices with name, user, OS, compliance pill, encryption state, and last sync. Paginated (25 rows per page). The modal footer has an Export CSV button that downloads every matching row with a UTF-8 BOM so Excel reads it correctly.

Help

Interactive guide at reporting/help.php covering ticket reports, system logs, data interpretation, filters, and reporting best practices.

Key Tables

Table	Purpose
login_attempts	Login successes and failures with IP, user agent
mailbox_activity_log	Email import / rejection audit
system_event_logs	Administrative actions
intune_devices	Intune-synced device records (data source for the Intune dashboard)
report_packs	Report pack designs (one JSON document each)
report_pack_shares	Who each report pack is shared with, to view or edit

On a phone

All five pages work on a phone — see Mobile: Reporting. The four-item nav moves into the drawer behind the ☰ button; the two log tables and the Intune drill-down device list become a card per row, each value printed against its column heading; and the Intune drill-down fills the screen instead of floating in the middle of it. The desktop is unchanged.