CA Service Management

CA SDM 12.7 Audit Log List

  • 1.  CA SDM 12.7 Audit Log List

    Posted 08-29-2014 07:23 AM

    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:

    "OP=SEARCH+FACTORY=audlog+QBE.GT.id=0"

    By changing it as follows:

    "OP=SEARCH+FACTORY=audlog"

    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.