Just wondering what the criteria was for determining if a workbook is "old"?
Can you add the ability to validate the age based on last viewed date? This would be useful to set a standard for content owners, that their content needs to be relevant and viewed or it will be archived.
We typically define 'old' via the 'wb_last_view_time' column in our query to postgres. One can either filter there via a where clause or define it outside of postgres via a tableau workbook you can pull down and filter in your script. It depends on the business need but our version of old is anything > 60 days.
Hope that helps. I'd be happy to talk specifics if you need.
too bad, the link you gave is dead now.
Would you have nother one?
I'm working on an update that makes this quicker and more robust (leverages the pg_largeobject). I'll post back once it's done.
Mike we'd like to move/store the objects in a shared drive. Any way that is possible?