How do I remove data from Viewtracker?

What has been deleted cannot be restored! Proceed with caution and back up the table or the entire database beforehand.

→ Read about the Viewtracker Data Structure in general

Deleting views of specific content from the database

1. Stop your Confluence.
   

2. Remove the Viewtracker data with the following SQL:
   

   SQL

   DELETE FROM AO_05769A_VISIT_ENTITY WHERE CONTENT_ID=86639844;

3. Start Confluence again. The deleted entries are now gone.

Deleting views by date

If you would like to remove views by date, follow these steps: 

1. Stop your Confluence
   

2. Remove the Viewtracker data with the following SQL:

   
   Example for MySQL
   

   SQL

   DELETE FROM AO_05769A_VISIT_ENTITY 
   WHERE VISIT_TIME < DATE_SUB(NOW() , INTERVAL 12 MONTH);

   Example for Microsoft SQL
   

   SQL

   DELETE FROM AO_05769A_VISIT_ENTITYsq 
   WHERE DATEADD(year, 2, VISIT_TIME) < getdate();

3. Start Confluence again. The deleted entries are now gone.