Create Custom Administrative Views

In addition to the pre-built administrative views available on the Maintenance page on the Server, you can use Tableau Desktop to query and build your own analyses of server activity. To do this, you can connect to and query views in the Tableau Server repository using one of two built-in users: the "tableau" or "readonly" user.

To connect to the Tableau Server repository, see Collect Data with the Tableau Server Repository.

  • The tableau user—The tableau user has access to special views and a subset of tables in repository database. These views and tables are provided so that administrators can create custom administrative views. Tableau makes an effort to limit changes to these tables and views so that custom views built with them do not break.

  • The readonly user—The readonly user has access to a large number of the repository tables, providing more data about server usage. Administrators can use these to create custom administrative views too, but many of the tables are intended primarily to support the functioning of Tableau Server and may be changed or removed without warning. This means that views created from these tables can break when the database structure is changed.

For examples of custom administrative views, see the Tableau Community(Link opens in a new window). You can also use the temporary workbook that is generated when you view the built-in Administrative views.

Before you can connect using one of the built-in users, you must enable access to the Tableau Server database. After doing this you can use Tableau Desktop to connect to and query the database as the tableau user or the readonly user.

The tsm configuration 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 tsm configuration 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 when you run tsm maintenance cleanup with the --http-requests-table option. 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.

For more information about the tables in the Tableau Server repository, see Workgroup Database Data Dictionary(Link opens in a new window) .

Thanks for your feedback!Your feedback has been successfully submitted. Thank you!