In TrueSight Capacity Optimization (TSCO) how can one set an aging parameter for Reports cleanup? We need to setup repository cleanup for the report results, to prevent our report repository from reaching 100% full on the file system.

This article describes how to set reports retention and how to automatically delete old reports.

Steps for TrueSight Capacity Optimization (TSCO) versions 11.3 and later

By default the last 100 report results are ALWAYS retained for each report.

For TrueSight Capacity Optimization versions 11.0 and earlier 

Note: This article works on TrueSight Capacity Optimization 10.0 only if you have installed CHF4 for CP1 or newer CHF
This solution works for both TSCO instance running on an Oracle DB and on Postgres

1. Preliminary steps

• Edit the "Database Cleaner" in TSCO system tasks

• Verify if it's part of the "maintenance activity chain", if so select the chain and unschedule it

• Go back to the "Database Cleaner" configuration page and edit its run configuration in Advanced mode

2. Adding the custom cleanup queries into Database Cleaner task Run confguration

• Add the following 2 properties to the Database Cleaner Task, replacing "100" with the desired number results you want to keep for each report:

   For StandardReport.custom.query entry Value is:
 

DELETE FROM rep_result t1 WHERE (repid, rundate) IN (SELECT repid, rundate FROM (SELECT t2.repid, t2.rundate, ROW_NUMBER () OVER (PARTITION BY repid ORDER BY rundate DESC) RANK FROM rep_result t2) WHERE RANK > 100)

   For StandardReportProps.custom.query entry Value is:

DELETE FROM rep_result_props t1 WHERE (repid, rundate) IN (SELECT repid, rundate FROM (SELECT t2.repid, t2.rundate, ROW_NUMBER () OVER (PARTITION BY repid ORDER BY rundate DESC) RANK FROM rep_result t2) WHERE RANK > 100)

3. Enabling the custom cleanup queries  (changes for BCO 9.X)

Append the following string to the query.name.list property of the Database Cleaner Task to remove the reports out of the RANK from the database:

;StandardReportProps;StandardReport
 

3. Enabling the custom cleanup queries (changes for TSCO 10.0 CP1 CHF4 or 10.3 or 10.5 or 10.7)

Add the following property to the Database Cleaner Task:additional.tables

Append the following string to the additional.tables property of the Database Cleaner Task to remove the reports out of the RANK from the database:

StandardReportProps;StandardReport
 

4. Final steps

• Save the run configuration
• Go back into the Maintenance activity chain and reschedule it

How To Video