KNOWLEDGE BASE

Changing the Number of Days Historical Events Are Stored


Published: 18 Jul 2014
Last Modified Date: 22 Oct 2014

Question

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

Environment

  • Tableau Server
  • Tableau Server database

Answer

  1. On the computer running Tableau Server, open the Command Prompt window as an administrator and run one of the following commands:
    • On a 32-bit computer: cd "C:\Program Files\Tableau\Tableau Server\<version>\bin"
    • On a 64-bit computer: cd "C:\Program Files (x86)\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.
Did this article resolve the issue?