Tableau Server – How to see who deleted a workbook?
Which problem does it solve?
To figure out why content doesn’t show up anymore. Did a user delete it? Has it been a Tableau Server administrator job (REST API / TabCmd)?
Can I use this for my Tableau Server environment?
Yes, if you’ve got access to the Tableau Server repository on Postgres.
SQL Statement from within the video?
SELECT ‘User named: ‘ || a.name || ‘, Deleted workbook: ‘|| b.name as WhoDidIt
FROM historical_events c,
where c.historical_event_type_id in
(select type_id from historical_event_types
where name = ‘Delete Workbook’)
and c.created_at > (now() – interval ’24 hour’)
and c.hist_workbook_id = b.id
and c.hist_actor_user_id = a.id
Links from within the video?
Jeff Krieg’s original post: https://community.tableau.com/message/433508#433508
How to enable the “readonly” user: Tableau Server Documentation