I'm on vacation now but as long as I return I will update the public repo as well.
Quick tip: copy/rsync your tableaufs folder to an another drive to make the audit faster. It will also help you with handling the tempfiles created by the auditor.
We have about 3500 workbooks. Interwork Powertools for Tableau takes forever, and last time I tried running it on the whole server it stopped because it had used all of the disk space.
Without copy/rsync, the TWB Auditor took maybe 1 hour to audit the +2000 version 7,8 and 9 workbooks that it was able to find on TableauFS. However, I don't use TableauFS directly on the prod environment (I don't want to break anything!). I restore a backup on another machine, disable all the schedules and use that for my TableauFS/TWB Auditor audit.
BTW, I had to modify the DeleteUnpackagedWorkbook function of TWB Auditor. I think the correction you had made to the TWB Auditor code was not removing the readonly attributes of the folders (for example, 'images' folder that's part of the .twbx):
If fso.FileExists(txtWorkbook) Then
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objFolder = objFSO.GetFolder(fso.GetFile(txtWorkbook).ParentFolder)
Set colFiles = objFolder.Files
For Each objFile In colFiles
If objFile.Attributes And ReadOnly Then
objFile.Attributes = objFile.Attributes Xor ReadOnly
For Each SubFolder In objFolder.SubFolders
If SubFolder.Attributes And ReadOnly Then
SubFolder.Attributes = objFile.Attributes Xor ReadOnly
' yes - delete its folder
I did not want to bother Tamas about a post he made 2 years ago...so thanks for tagging him for me!
To be honest we have a super-secret tool to gather metadat information (lineage, database columns used, calculations, etc) from the postgres repository itself. We built for systems with thousands of worbook and it's *really* fast. I generates CSV files or SQL tables with the results.
As I see you're a man of culture, if you'd like I can send you this tool to test it on your end. just send a mail to tfoldi (a) starschema.net