Tableau Server – How to see who deleted a workbook?

Kommentare : 0

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.

How to?

<span data-mce-type="bookmark" style="display: inline-block; width: 0px; overflow: hidden; line-height: 0;" class="mce_SELRES_start"></span><span data-mce-type=”bookmark” style=”display: inline-block; width: 0px; overflow: hidden; line-height: 0;” class=”mce_SELRES_start”></span>&lt;span data-mce-type=”bookmark” style=”display: inline-block; width: 0px; overflow: hidden; line-height: 0;” class=”mce_SELRES_start”&gt;&lt;/span&gt;

SQL Statement from within the video?
SELECT ‘User named: ‘ || a.name || ‘, Deleted workbook: ‘|| b.name as WhoDidIt
FROM historical_events c,
hist_users a,
hist_workbooks b
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

Über den Autor

Timo originally coded his own BI-application by making use of different JAVA libraries. He Worked for IBM as BI-specialist and BA-architect before he joined Tableau. Favorite subject: JavaScript API