Out of the box Tableau supplies a number of tools to monitor what is happening on the server. Often these aren’t adequate to get a good view into what’s happening on your server hence you might want to create your own custom admin views. Tableau have allowed, unsupported, querying of the underlying postgres database to create views but until recently there was very little documentation available to help, plus all of the usual ‘do so at your own risk’ warnings. Now things are beginning to change and there are many good sources of information about this database, incluing Tableau themselves now providing a lot of information about their database schema. Andre Pandre wrote up the following very useful post about the underlying Tableau postgres database, essentially bringing all the vital information into one place.
The Tableau postgres database can supply information on the actual server performance as well as what users are doing on the server. My approach to this is from a report usage perspective as, since I look after report development, that’s how my work is judged hence this post is about tracking what the users are doing.
To get started you need your Tableau desktop to be able to connect to the Tableau postgres database, which means installing the postgres driver.
To connect to the underlying Tableau database you need permission, which means sweet talking your Tableau Server administrator, if you’re not an admin yourself, to get access. Once you’re allowed you to connect fire up Tableau and connect to the database. This is what I had to enter to connect to my server, although no guarantee this will also work for your server:
As mentioned earlier my interest is from a report usage perspective and to get all of the data I need to supply my quick view of what my users are doing I connect to the following tables:
NOTE: if you’re interested in monitoring things such as server performance connecting to these tables won’t really help you. Use the data dictionary Tableau now provide.
Next step is to create your report. This is for your usage so create whatever works for you. My version, although unsexy, does what I need it to do, showing me who’s using what, when they’re using it and how often they check it, is here: