4 of 4 people found this helpful
I do not know of any way to do this currently. I wouldn't recommend manually editing the internal Postgres repository as it could lead to instability and issues for the Server. I would however, recommend taking extracts of the internal Postgres which you can manipulate as you see fit for your own custom admin views. This will allow you to cleanup your internal files more frequently without risking losing info without a backup: Remove Unneeded Files.
As for the retention period, this article should help: http://onlinehelp.tableau.com/current/server/en-us/help.htm#adminview_postgres.htm
The tabadmin set option auditing.enabled controls whether Tableau Server collects historical user activity and other information in the repository. It is enabled by default. Be aware that collecting historical events impacts the size of Tableau Server's backup file (.tsbak).
- All hist_ tables are controlled by the tabadmin set option wgserver.audit_history_expiration_days, which controls how many days of event history are kept in the repository and has default value of 183 days.
- The _http_requests table is cleaned of all data older than 7 days every time tabadmin cleanup or tabadmin backup is used. For more information, see Remove Unneeded Files.
- The _background_tasks table is cleaned automatically and keeps data for the last 30 days.
- All other tables with names that begin with a "_" prefix contain current data.
Tableau technical support has responded me on one of my issue raised with them for the data retention on the repository table, the user activity on the repository table is retained only for 30 days.