Reports
Export scan data and generate sterilization process reports
Filters
Sterilization Process Reports
No finalized processes found. Adjust filters and try again.
Export Scan Logs to CSV
Quick Reports
Daily Summary
Scan counts grouped by day for the selected period
View SQL
SELECT DATE(scanned_at) as scan_date, clinic_id, COUNT(*) as scans FROM VIROSYS.LOGGING.QR_SCAN_LOGS GROUP BY 1, 2 ORDER BY 1 DESC
Clinic Activity
Total scans and unique users per clinic
View SQL
SELECT clinic_id, COUNT(*) as total_scans, COUNT(DISTINCT user_id) as unique_users FROM VIROSYS.LOGGING.QR_SCAN_LOGS GROUP BY 1 ORDER BY 2 DESC
Hourly Distribution
Scan volume by hour of day
View SQL
SELECT HOUR(scanned_at) as hour_of_day, COUNT(*) as scans FROM VIROSYS.LOGGING.QR_SCAN_LOGS GROUP BY 1 ORDER BY 1
User Productivity
Scans per user per day
View SQL
SELECT DATE(scanned_at) as scan_date, user_id, clinic_id, COUNT(*) as scans FROM VIROSYS.LOGGING.QR_SCAN_LOGS GROUP BY 1, 2, 3 ORDER BY 1 DESC, 4 DESC