Siebel EIM >  Delete records in Audit Trail based on DELETE MATCHES

Delete records in Audit Trail based on DELETE MATCHES

Here is an example of deleting Service Request Audit Trail records with a last updated criteria.
The DELETE MATCHES criteria listed below is given merely as an example and can be modified for each customer's business needs.

[PURGE_AUDIT_ITEM]
TYPE = DELETE
BATCH = 100
TABLE = EIM_AUDIT_ITEM
ONLY BASE TABLES = S_AUDIT_ITEM
DELETE MATCHES = S_AUDIT_ITEM, (BUSCOMP_NAME = 'Service Request' AND LAST_UPD < '2011-12-31 01:00:00.000')
COMMIT EACH PASS = TRUE
COMMIT EACH TABLE = TRUE
ROLLBACK ON ERROR = TRUE
UPDATE STATISTICS = FALSE

Here is another partial example for Service Request records where a list of ROW_IDs can be provided:

DELETE MATCHES = S_AUDIT_ITEM, (BUSCOMP_NAME = 'Service Request' AND FIELD_NAME=?Description? AND RECORD_ID in (list of SR?s ROW_IDs)).

 

When using DELETE MATCHES, it is not required to load EIM table with the records.
EIM will perform the delete based on the criteria specified in DELETE MATCHES parameter and the
targeted records will be inserted into EIM table for reference and so that these records can be
manually archived to an external location if desired. So if you search EIM_AUDIT_ITEM for records and their status,
you might get strange results. This is the expected behavior.

You cannot perform an EIM delete job by using the DELETE EXACT to purge audit trail records.
DELETE MATCHES must be used to delete Audit Trail records. If you are trying to delete records in tables without
index keys, DELETE MATCHES is the correct way to do this.