KNOWLEDGE BASE

Changing the Number of Days Historical Events Are Stored


Published: 18 Jul 2014
Last Modified Date: 17 Jun 2020

Question

How to change the number of days historical events are stored in the Tableau Server database.

Environment

  • Tableau Server
  • Tableau Server database

Answer

Option 1: For Tableau Server on Linux and Tableau Server on Windows 2018.2 and Newer  

  1. On the computer running Tableau Server, open the Command Prompt as an administrator and navigate to the Tableau Server bin folder, located by default at C:\Program Files\Tableau\Tableau Server\<version>\bin
  2. At the command prompt, run the following commands in order:

    • tsm stop 
    • tsm configuration set -k wgserver.audit_history_expiration_days -v <config_value>
    • tsm pending-changes apply
    • tsm start


 

Option 2: For Tableau Server on Windows 2018.1 and Older 

  1. On the computer running Tableau Server, open the Command Prompt as an administrator and navigate to the Tableau Server bin folder, located by default at C:\Program Files\Tableau\Tableau Server\<version>\bin
  2. At the command prompt, run the following commands in order:

    • tabadmin stop 
    • tabadmin set wgserver.audit_history_expiration_days <number of days> 
    • tabadmin config
    • tabadmin start

Additional Information

  • By default, historical event data is stored for 183 days.
  • Entries that are older than 183 days are purged with a reap job.
  • Non-historical records are purged every seven days, or whenever tabadmin backup or tabadmin cleanup is run.

Discuss this article... Feedback Forum
Did this article resolve the issue?