Remove unwanted and older data from the knowledge usage metrics [kb_usage_metrics] table through the data retention policy.

Before you begin

Role required: maint and admin

About this task

Activating the data retention policy for the kb_usage_metrics table deletes records that you no longer need.

Procedure

  1. Navigate to All > System Maintenance > Table Cleanup.
  2. In the Tablename column, search for kb_usage_metrics and click the kb_usage_metrics link.
  3. On the Auto Flush form, activate the kb_usage_metrics table cleanup job by selecting the Active check box.
  4. (Optional) Adjust the duration the system waits before deleting the records by modifying the value in the Age in seconds field.
    By default, the Age in seconds field value is set to 2,592,000 seconds (equivalent to 30 days). For more information, see Autoflush form.
  5. Click Update.