{"id":10890,"date":"2024-05-14T16:29:10","date_gmt":"2024-05-14T21:29:10","guid":{"rendered":"https:\/\/www.rushworth.us\/lisa\/?p=10890"},"modified":"2024-05-14T16:29:15","modified_gmt":"2024-05-14T21:29:15","slug":"tableau-who-deleted-that-workbook","status":"publish","type":"post","link":"https:\/\/www.rushworth.us\/lisa\/?p=10890","title":{"rendered":"Tableau &#8212; Who Deleted That Workbook?!?"},"content":{"rendered":"\n<p>While Tableau doesn&#8217;t have anything nice like a &#8216;dumpster&#8217; from which you can restore a deleted workbook, it <em>does<\/em> at least keep tables for historic events like workbook deletion. The following query finds records where a workbook with FOOBAR in its name was deleted. It lists all of the event info as well as info on the user who deleted it. Near as I can tell, the &#8220;created&#8221; date for the historical_events table is the date the workbook was deleted (from my restore, I know the workbook itself was created last year!)<\/p>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: sql; title: ; notranslate\" title=\"\">\nSELECT historical_events.*, hist_workbooks.*, hist_users.*\nFROM historical_events\nleft outer join historical_event_types on historical_event_types.type_id = historical_events.historical_event_type_id \nleft outer join hist_workbooks on hist_workbooks.id = historical_events.hist_workbook_id \nleft outer join hist_users on hist_users.id = historical_events.hist_actor_user_id \nWHERE historical_event_types.name = &#039;Delete Workbook&#039;\nand hist_workbooks.name like &#039;%FOOBAR%&#039;\n;\n\n<\/pre><\/div>","protected":false},"excerpt":{"rendered":"<p>While Tableau doesn&#8217;t have anything nice like a &#8216;dumpster&#8217; from which you can restore a deleted workbook, it does at least keep tables for historic events like workbook deletion. The following query finds records where a workbook with FOOBAR in its name was deleted. It lists all of the event info as well as info &hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1852],"tags":[1822,2005],"class_list":["post-10890","post","type-post","status-publish","format-standard","hentry","category-tableau","tag-tableau","tag-tableau-server"],"_links":{"self":[{"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/posts\/10890","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=10890"}],"version-history":[{"count":1,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/posts\/10890\/revisions"}],"predecessor-version":[{"id":10891,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=\/wp\/v2\/posts\/10890\/revisions\/10891"}],"wp:attachment":[{"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=10890"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=10890"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.rushworth.us\/lisa\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=10890"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}