Use the scripts listed below to perform a deletion of unnecessary records.

1. Deleting from the registry rules executed by Aranda SERVICE DESK. Use the finished field to limit the length of time you want to keep/delete. Delete only the data from rules executed for closed cases using the script:

DELETE FROM ASDK_RULES_EXECUTED_HIST
WHERE caseid NOT IN (
SELECT serv_id
		FROM ASDK_SERVICE_CALL
		WHERE serv_final_status = 0
		UNION ALL
		SELECT inci_id
		FROM ASDK_INCIDENT
		WHERE inci_final_status = 0
		UNION ALL
		SELECT chan_id
		FROM ASDK_CHANGE
		WHERE chan_final_status = 0
		UNION ALL
		SELECT prob_id
		FROM ASDK_PROBLEM
		WHERE prob_final_status = 0
) AND tableid IN (1, 2, 3, 15);

2. Clearing the database error tracking logs.

TRUNCATE TABLE AFW_SQL_ERRORS;

3. Clearing the database runtime tracking logs.

TRUNCATE TABLE AFW_SQL_TIMES;S;

4. Clearing runtime tracking logs related to token replacement for claims.

TRUNCATE TABLE DB_TIMES;

5.Deletion of the history of emails sent by Aranda applications. Use the mail_date_to_send field to limit the period of time that you want to delete from the AFW_MAIL_HISTORY table.