Blog

17
SEP
2018

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? 

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

Timo Tautenhahn
Ü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

Teilen

  • google-share

Kommentare Cancel reply

*

*

captcha *

Categories

  • Admin Area (1)
  • Data Stories (1)
  • Developer (2)
  • Embedding API (2)
  • Extension API (11)
  • Geek Stuff (3)
  • Hacks (1)
  • Ideas (8)
  • Industry Related (1)
  • Neuigkeiten (6)
  • News (3)
  • Performance (2)
  • Salesforce (1)
  • SAP (1)
  • Success Stories (1)
  • Tableau 10 (1)
  • Tableau 9 (1)
  • Tableau Server (3)
  • Tableau Visualization Extensions (1)
  • Tipps & Tricks (10)
  • Tips & Tricks (1)
  • Tutorials (14)
  • Visual Inspiration (8)

Tags

artilize Azure bericht Cloud Cloud Database conference Datalake dynamisch embed Embedding Extension API Extract API html javascript api kpi mobile munich news on-demand on-tour parameter RLS Salesforce SAP SAP BW Security Snowflake SSO tc Write Back

Last posts

Timo Tautenhahn - Tableaufans.com - Tableau Visualization Extensions - Create and share your own chart types - Live Devs on Stage TC21

Tableau Visualization Extensions

Thursday, 11. November 2021

How to configure Tableau Online Single Sign-On with Salesforce as Identity Provider?

Monday, 16. November 2020

Tableau Extensibility Framework

Thursday, 17. September 2020

Embedding Tableau Responsively

Tuesday, 26. May 2020

Show Empty Rows and Columns

Tuesday, 24. December 2019
  • Blog
  • About
  • Contact
  • Legal
© 2019 - tableaufans.com - All rights reserved
Concept and design: www.emodia.de