How do I remove data from Viewtracker?

→ 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:
   

   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
   

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

   
   

   Example for Microsoft SQL
   

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

   
   

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