Open-AudIT

[quote]A Database Error Occurred

Error Number: 1054

Unknown column 'oa_group_sys.system_id' in 'on clause'

SELECT system.system_id, system.hostname, sys_sw_group.group_members FROM system LEFT JOIN sys_sw_group ON (sys_sw_group.system_id = oa_group_sys.system_id AND sys_sw_group.timestamp = system.timestamp) LEFT JOIN oa_group_sys ON oa_group_sys.system_id = system.system_id WHERE oa_group_sys.group_id = @group AND sys_sw_group.group_name = "Administrators" GROUP BY sys_sw_group.group_id ORDER BY sys_sw_group.system_id

Filename: models/m_oa_report.php

Line Number: 127

Deactivate the report.
Overwrite existing report in code_igniter\application\controllers\reports with attached LocalAdministrators.xml.
Reactivate report.
Let us know how it goes.

No further errors.
But I'm not sure if the query is correct.
I don't get any result. But I'm sure some of my testing collegues are local administrators on their machine.

The report works here. Perhaps you don't have good audit data to display? Can you check for good data in the sys_sw_group table in the the group_members field?