FOR ANALYSTS FOR BI PROS FOR EVERYONE Tableau
How to use TWB Auditor with TableauFS: Audit Tableau Server files directly
July 15, 2015
0
, , , , , ,

If you never heard about this powerful and extremely useful tool by Andy Cotgreave then you missed something serious. It makes life easier with auditing all your tableau workbooks on your computer, getting information like which workbook connects to where, what are the used tables and fields, calculations – things what we desperately need during our daily professional life. This is an example what can you do with it: Here’s a link to a published version of the Viz workbook. However, it missed one important function:

Audit workbooks directly on the server

This is not the case anymore. With TableauFS which runs perfectly on Windows with Docker you can directly index/audit your remote server.

So, let’s get it started

Firstly get the latest version of TWB Auditor from (http://community.tableau.com/thread/118450) and mount your Tableau Server as window share.  For more information about mounted drives of Tableau Server please check my previous note here: https://databoss.starschema.net/tableaufs-on-windows-with-docker/  Mount it as a drive and check if you can access the files.

Adding stuff to make it “TableauFS compliant”

Due to two things (first is file naming differences on local, windows file systems vs network file systems and second is read only file system adds read only flag for all files) you need slightly change Andy’s tool. No worries, few lines only.

You should change the file mask in FileList module:

The DeleteUnpackagedWorkbook function was unable to delete temp files from my temp folder(c:\usres…\temp\..). It is caused by that, on TableuFS shared drive every file is read only. So when the files were unzipped by the TWB Auditor was also read only. I have inserted a short code to remove read-only attribute from files if there is any:

 

Just change/add the highlighted lines and move forward.

How to use the TWB Auditor

After downloading & unzipping TWB Auditor, open the TWB Auditor - data.accdb  Please note that you will need an MS Access to use it, obviously.

Start Screen

Here you can easily start with a double click the audit of your workbooks, with the “Audit all workbooks in a folder”. Then select the proper option for audit:

Check for twbx files in subdirectories

Check for twbx files in subdirectories

As you can see I would like to search for TWBX files (check the “include packaged workbooks”) on my Z:\ shared drive where my Tableau Server was previously mounted.

After the audit is completed you will see the results of the audit, which workbooks has been audited, and what is the workbook path. After the run is completed, just close TWB Auditor.

These are not local files if you know what I mean

These are not local files if you know what I mean

Using the results

Open the TWB auditor - viz.twb  workbook which is located where you have unzipped the Twb Auditor. Please do read  the TWB Auditor introduction worksheet.

Do not forget to read the instructions and refresh the datasources

Do not forget to read the instructions and refresh the datasources

And refresh all the data sources.  (Data / Refresh all extracts)

What’s in my workbooks

What’s in my workbooks

On “What’s in my workbooks” will provide you information about each workbook and their worksheets.

On other sheet you can check the connection type of the workbooks:

Connection Info

Or you can easily check “Where is that field used” :

audit7

One word: lovely.

Rerunning the audit

Just one more important thing: if you need to refresh the audit database and you don’t want to accumulate your audit history, just hit “Delete all data from TWB Auditor” before the next run.

That’s it, simple and easy (sometimes even fast). In case if you have any questions or issues just drop a comment.

 

Tamás Földi

Tamás Földi

Director of IT Development at Starschema
Decades of experience with data processing and state of the art programming. From nuclear bomb explosion simulation to distributed file systems. ethical hacking, real time stream processing practically I always had a great fun with those geeky ones and zeros.
Tamás Földi

There are 0 comments

Related items

/ You may check this items as well

Pasted image at 2018_01_09 04_59 PM

Python Experiments in Tableau 1. – Add live currency conversion to Tableau Dashboards using TabPy

If you never heard about this powerful and extrem...

Read more
Tableau Docker

HOWTO: Tableau Server Linux in Docker Container

If you never heard about this powerful and extrem...

Read more
Tableau Consistency Checker

Tableau Filestore Consistency Checker – How Repository Maps to Filestore

If you never heard about this powerful and extrem...

Read more