you can do this by three steps:
1. Enable readonly access to the internal PG database Enabling External Access to the Tableau Server Database
2. Learn about the data you need to get the job done Workgroups Database
We use historical_events a bunch for understanding the views and user patterns. And you can join up to hist_event_types to find the event type of "Access"
3. Connect via Tableau Desktop Connecting to the Tableau Server Database