Document toolboxDocument toolbox

Admin ServiceOptimizer Further Detail Auditing

Many of the actions within a ServiceOptimizer instance are audiited. This section gives some advice on managing thes audit trails.

System and Scheduling Parameters Audit Trail

ServiceOptimizer provides an audit trail facility which allows the system administrator to monitor and, if necessary, undo changes made to the value of any system or scheduling parameter. This facility is provided by a set of audit tables, described in Database Spec, together with a number of database triggers which ensure that details of changes to parameters are recorded in one of the audit tables.

To restore a parameter to its previous value, use SQL as in the following example:

update sp083_system_parameters set
value='<old value>' where name='<param name>';

Job Allocation Audit Trail

ServiceOptimizer provides an audit trail facility which allows the system administrator to monitor and, if necessary, undo changes made to the appointments, activities and job allocation tables. This facility is provided by a set of audit tables, described in Database Spec, together with a number of database triggers which ensure that details of changes to parameters are recorded in one of the audit tables