I absolutely love hearing your feedback on the community :-) A lot of people put a lot of good work into our community so it's great to hear it's working.
As for your question, Tableau Server 8.3 should allow access to even more admin tables in the postgres database, allowing you to get an even deeper look into how your users are using Tableau Server. For now, the following video explains the basics of content management:
It's probably not super useful in this case but maybe it'll help. Generally setting strict permissions and organizing sites and projects well, will help to ensure users are seeing the content they should (and not seeing what they shouldnt!).
Another side note: We've recognized the lack of a dedicated space for our Tableau Server admins and while building awesome vizzes is fun, we think having a place to ask finicky permissions questions is also useful. As such, we're working on releasing a space for our Tableau Server admins in the coming weeks. Not only will be have some potentially useful resources, but also invested admins who are ready to answer some questions.
Thanks for the post Fiona!
While I'm not sure if the information you seek is current in the Postgres tables, I absolutely do encourage you to explore these tables as they do contain a vast amount of info, further if there is information that isn't stored in the tables that you would like to know, please tell us, we love getting this kind of feedback.
For an example of some workbooks created using the Postgres tables, you can check out this post:
Also see Mark Jackson post on server admin views.
We've implemented a whole suite of views similar to these that tell us everything we could wish to know about performance, capacity and usage.
We find them absolutely critical to the operation of our service. It's a great selling point to demo them to senior people interested in their areas adopting Tableau. It lets them know that we are in control and have our act together. What other enterprise service can provide you (and your users) with such massive introspection into your own operation? None.
Thanks for the mention Paul!