Viewtracker - Analytics for Confluence
Space shortcuts

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: changed title to question

On this page:

Table of Contents


Removing Viewtracker data

This guide is valid for Viewtracker 4.0.0 and newer. 

Warning

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 from the database

  1. Stop your Confluence
  2. Remove the Viewtracker data with the following SQL:

    Localtab Group


    Localtab
    titleSQL

    Example for deleting by Content ID (should work with most SQL dialects):

    Code Block
    languagesql
    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:

    Localtab Group


    Localtab
    titleMySQL

    Example for MySQL:

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



    Localtab
    titleMicrosoft SQL

    Example for Microsoft SQL:

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



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