New Views for Tableau Server Administrators — BI on BI

By Michael Chen 27 Jan, 2015

During my first efforts exploring the postgres repository in Tableau Server, I was amazed by the sheer expansiveness of the information stored within. Overwhelmed, I thought to myself:

  • “How do I use all this data?”
  • “What questions can I answer with this data?”
  • “What questions should I even be asking?”

Stumbling through column names, not knowing which tables could be joined, or even what information was stored in each table; I quickly realized that I needed the example of an experienced user to guide me.

To educate myself, I sought out the admin views created by Zen Master Mark Jackson [found here] and other amazing Tableau Customers; by tinkering, breaking down (sometimes just breaking), and rebuilding their work, I taught myself how to navigate the repository, to answer important questions, and like so many other Tableau Customers, to explore my data and arrive at new insights.

Through my explorations, I discovered that the data in the repository could do more than just monitor your usage of Tableau Server; it can also be leveraged to help quantify and improve the efficiency of your BI solution, thus using business intelligence on business intelligence. Now, I get to give back to the Tableau Community and share my own creations: Customized Views for Server Insights and Analytics.

Use and Operation

These particular workbooks will exist as a community effort, however at Tableau we are always proudly “eating our own dog food” and have been diligently applying similar workbooks to our own servers – using Tableau on Tableau. Ultimately we hope to provide customers with tools and metrics that will allow you to increase the efficiency of your BI services and make proactive decisions concerning your BI roadmap.

These workbooks will help answer the most common questions you may have about your sever, but my wish is for them to be living, organic entities that can be taken apart, repurposed, and improved upon by anyone; therefore I have exposed every join, every table, and every calculated field I used so that you may learn, play, and experiment to your heart’s content.


  1. Server Sizing Monitor– Dashboards to track background tasks, http requests and actions, server load, and Vizql Sessions.
  2. Data Connections and Permissions– Dashboards to track user permissions and data connections, including which extracts share the same data connections, and what workbooks connect to which published data sources.
  3. View Traffic Monitor– The most popular views on the server, the most active users, and most active days for viewership. This Dashboard tracks and ranks incoming traffic to the server.
  4. Extract Error Monitor– Dashboards to identify extract errors and error types, extract refresh/increment duration, and error messages.
  5. Subscriptions Timer– Dashboards to track late subscription emails for workbooks and views.

Instructions can be found here

Together these workbooks will allow you to not only audit your server, but to discover new insights and explore server operations and usage.


You will need Tableau Desktop installed and have full access to your Tableau Server db to access these workbooks in their entirety; I would advise following the steps in the DAAP documentation.

With the release of 8.2.5, Tableau introduced the read-only user, offering customers a new world of possibilities for monitoring the status and performance of Tableau Server. While the information in the Postgres tables available to the base “Tableau user” was already vast, the tide of information now unleashed with 8.2.5 will allow for insights never before possible. In the past we have provided instructions for how to use the Postgres tables to create custom admin views to monitor your system, with the read-only user, we made this process easier than ever.

Final Words of Encouragement

I hope that these workbooks prove to be useful and educational to the Tableau community. As I said before, it is my wish that these workbooks be both living and ever evolving, so please post your tweaks, hacks and improvements so that your fellow Tableau Customers can learn from your great work. The forum can be found in the new Server Admin section of the Tableau Community Forums. May the force be with you.

Jedi Academy Cadet
Michael Chen


Submitted by Raymond R. on

This is fantastic. Thank you, Michael!

Submitted by Veronica S. on

great tips! this version is really amazing!

Submitted by Israel Rodriguez (não verificado) on

Michael, Awesome!!! extremely well thought out and relevant!!

Submitted by Tomek Z (não verificado) on

I have a problem when trying to set up tags tracking - I want to use hist_ tables structure to do this, but hist_tags table is empty... in spite of the fact that some of my Tableau workbooks do have tags assigned. Do you have an idea what might be the reason?

Submitted by Israel R. on

Wow! How much do I Owe you?

Submitted by Mike K. on

Great stuff thanks for all of the detail, we're going to start using this to police our server!

Submitted by Lee Forst (não verificado) on

Michael, I just came across this and it is fantastic work. I wonder if I would speak to you about creating a view that would allow me to see the workbooks\sheets\custom views people have subscribed to? I've gotten something together, however it is not as friendly as I'd like it to be.