On a system where auditing is used extensively , you may encounter the following in the stdlog files:
The following statement took 56941 milliseconds: Clause (SELECT audit_log.change_date, audit_log.audobj_name, audit_log.attr_name, audit_log.id
FROM audit_log WHERE audit_log.id > 0 ORDER BY audit_log.change_date DESC) Input (<None>)
This is due to a user clicking on the "Audit Log List" in the "Service Desk" Folder of the Administrator Tab
The OTB "Audit Log List Menu Tree Resource" is configured as follows:
By changing it as follows:
The system will now present an "Audit Log Search" form instead of a list form.
The user can now provide search criteria and prevent the enumeration of all rows from the "audit_log" table.