Answer

To access audit data for all workbooks on the Tableau Server, ensure the following steps are completed as prerequisites:

• Enable the Repository: Ensure that the Tableau server repository is enabled to facilitate the retrieval of comprehensive audit data.
• Connect to the Tableau Server Repository: To access data from the Tableau Server repository in Tableau Desktop or Server, you may need to install the PostgreSQL driver as noted in the Tableau Online Help.

Follow the below  steps:

SELECT a.name as User,

  d.name as Event,

  b.name as Workbook,

 c.created_at as Date

 FROM historical_events c,

 historical_event_types d,

 hist_users a,

 hist_workbooks b

where c.hist_workbook_id = b.id

and c.hist_actor_user_id = a.id

and c.historical_event_type_id=d.type_id

order by b.name, d.name

5. Create a sheet and arrange dimensions and measures according to your needs. Customize the view as desired, and apply filters based on specific requirements. Refer to the below snapshot as an example.

Additional Information