Richard,

Your approach will work for file data, but a lot of the TDPs don't
accurately register filespace sizes.  Only the OP will know what the
impact of that might be in his environment.

I would go for an export allactive preview=yes.  It might run for quite
a while.

Regards

Steve

Steven Harris
TSM Admin, Canberra Australia

On 19/07/2011 4:42 AM, Richard Sims wrote:

If your clients are doing unfettered incremental backups of file systems, then 
the following would yield a MB approximation, very quickly:
       SELECT SUM(CAPACITY*PCT_UTIL/100) FROM FILESPACES
which is based upon TSM's information about the file system as gotten from the 
last client operation.  By definition, the files on the client represent all 
the Active files in TSM storage where the activity is incremental backups.

    Richard Sims